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.
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
datebase management system
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.
Which national database includes data on all discharged patients regardless of payer?
I think that the answer is the Healthcare Cost and Utilization Project
What do optimists tend to attribute their success to?
their own abilities; things beyond their control
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:
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.