Test 3 Review

Bring a GradeMaster form and a pencil to the test. The test will take 50 minutes.

SQL

• Be able to write INSERT, UPDATE, and DELETE statements (see the MySQL notes)
• Know what a view is and how to create one
• Know how views are used in SQL SELECT statements
• Know that views are the key means of abstraction in SQL
• Know the two ways that the database engine can choose internally to process a query that uses a view
• Know how views can help provide a denormalized view of the data in a database to support the reporting needs

Normal Forms

• Know the definitions of 1NF, Boyce-Codd NF, 4NF, Functional Dependency, Multivalued Dependency, Modification Anomaly, Normalization, Denormalization
• Be able to spot violations of 1NF, BCNF, and 4NF
• Know how to correct violations of 1NF, BCNF, and 4 NF
• Know the role of normal forms in database design
• Know what the normal forms are designed to prevent, and be familiar with the examples given in class on scenarios where normalization can be violated

MySQL and ODBC

• Know material from the MySQL notes
• Know the ODBC architecture and material from the ODBC lecture notes