Short answer questions:
1. Compare and contrast 2 benefits and 2 drawbacks from performing data normalization.
2. Define the concept of "denormalization" and present a case of when denormalization may need to be performed. Also describe the advantages and disadvantages of performing denormalization.
3. Compare and contrast data definition (DDL), data manipulation (DML) and data control language (DCL) in SQL. What is the main purpose of each SQL component and at what stage of DBLC are they used?
4. Explain the difference between the following set of SQL commands: Insert, Update, Delete and Insert command.
5. Explain the difference between the following set of SQL commands: Create table, Alter table, Drop table.
6. Explain the difference between "WHERE" and "HAVING" conditions in a SQL command.
7. Explain the purpose of each of the following SQL commands: INSERT, DELETE, UPDATE, SELECT, GROUP BY, ORDER BY, IN, BETWEEN.