CSE :: Database System 2 - CS
- The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
- The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
- When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.
- Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
- One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.
- One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.
- One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.
- When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.