CSE :: Database System 2 - CS
- When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
- Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
- When building a database from an existing set of tables, we still need to consider normalization principles.
- We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
- One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.
- We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
Whatsapp
Facebook
