answersLogoWhite

0

📱

Database Programming

Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.

8,803 Questions

What are the steps involved in planning database files?

There are five steps to planning database files. These steps are collecting information, determining objects, modeling said objects, determining every object's information, and determining the relationships the objects have with one another.

What is customer database?

A costumer database is an organized collection of comprehensive data about individual costumers or prospects, including geographic, demographic, psychographic, and behavioral data.

What would you want to track with your database?

I would want my database to do everything-manage and track my donors, foundations and grants, constituents and events, send mass e-mails, manage my staff records, vendor records and store contact information gathered on my website as well as push financial information like donations into QuickBooks so I won't have to re-enter everything twice.

What do Malabsorptive procedures do?

Malabsorptive procedures help patients lose weight by limiting the amount of nutrients and calories the intestine can absorb

Has the role of management changed?

Years ago, managers were thought of as people who were the boss. While that might still be true in the early twenty-first century, many managers view themselves as leaders rather than as people who tell subordinates what to do

Why global query optimization is difficult in distributed dbms?

1:parallel execution

2: Additional communication cost

3: Transparency and replication

What is a Multi-user DBMS Architecture?

A Multi-user DBMS Architecture is one big system of users and queries. The use of these are to over look and execute plans safely and does not violate and integrity constraints.

Why need to turn un-normalization data into 1NF?

Un-normalization of data will return the actual values of outcome, which is real value. Because we scale the data in normalization process.

What is strong and weak entity set?

the enitity which is set primary key is said to be strong entity and the entity which does not set primary key is said to be weak entity.

Is a query the same as a filter?

Not exactly. A query is much more powerful. Essentially it can filter records, but queries can do all sorts of other things that filters cannot do. A filter will reduce down the amount of records you see by apply a condition. You can then scroll through the visible records. A query can do the same thing, but it will give you a list of the records. It can deal with more complex conditions and do many other things like delete records, change values in records, build new tables and many other things that filters cannot do. You would use a filter for simple things, like to filter out all the people working in a particular department, but would use a query for something more complex like to show the people working in a particular department, who are earning a certain amount of pay and have worked in the company for more than a certain amount of years.

What is the difference between derived attribute and normal attribute?

A normal attribute is an attribute present in a schema and which has to be entered while entering a tuple.

A derived Attribute is one which can be inferred(derived) from another normal attribute and it need not be a part of a schema.

For e.g.-> In a schema, Date-of-Birth is a normal attribute.While Age is a derived attribute which can be derived from the Date-of-Birth

What is advantage of paper based records?

Here are some examples:

  • Written records are not destroyed when hard drives crash.
  • You can access them without power
  • Originals can be maintained
  • Inexpensive compared to some forms of electronic data storage

What is Covered entities?

a licensed medical provider of any kind

5 Explain why the allocation of records to blocks affects database-system performance significantly?

To access a record, the entire block that containg the target record must be loaded into the main memory and it is time consuming. It involes seek time, rotational delay and block transfer time.

Trending Questions
How many binary trees are possible with 3 nodes? Functions of schema? For what reasons may the results of scientific polls not be acurate? You're creating a workbook called Contacts which is currently open Which steps will move the Agents worksheet from the Employees workbook to between Sheet1 and Sheet2 in the Contacts workbook? Which network configuration allows each node to communicate directly with every other node? How does database management software interrogate a database? Smallest unit of space on a hard drive that can be used to store a file? What are the significance OF A COMPUTERIZED SYSTEM? When you are pulling or extracting information out of the database with a query - you can use to set conditions that must be met for a record to be displayed? What are the disadvantages of data leakage? Is 16KB a lot of data? Why we drag delete index and create index for process chains in sap bi? I am considering a new OS currently vista What is a good one for quickness and gaming? What is Outer Join SQL used for according to Wikipedia? What structure can you implement for the database to speed up table reads? What is the difference between Supervised and unsupervised methods in data mining? Use of data dictionary in a dbms? What is done to a record so the DBMS will not process it again? What are the disadvantages of revenue system? 1 How do you upload a database directly on to a server 2 how do you download the database from a server Kindly tell me all possibilities as soon sa possible.?