COMPUTER SCIENCE Database normalization

• An entity instance is a single occurrence of on ENTITY TYPE.

• Generalization is bottom up process.

• In an ER diagram, attributes are represented by ELLIPSE.

• The database schema is written in DDL.

• An Embedded pointer provides a secondary access path.

• A Schema describes data elements, records and files and record relationship.

• ODBC stand for Open Database Connectivity.

• 'AS' clause is used in SQL for rename operation.

• 2NF contains no partial functional dependencies.

• 3NF transitive dependencies eliminated.