Test 2 Review

Database Development

Know information from these lecture notes

Views

• Know what a view is and how to create one
• Know how views are used in SQL statements (SELECT, INSERT, UPDATE, DELETE)
• 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

Data Integrity

Know the various techniques for enforcing data integrity in databases

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

Database Programming

Know information from the Database Programming notes, including:

• Know the general procedure for connecting to a MySQL database and executing a SQL command using a Python program
• Know the two approaches for inserting program variables into a SQL command and which is preferred
• Know what SQL Injection is and how to prevent it