475 Quiz 2 

Wednesday, March 17

Topics: 


ERD Modeling

Conceptual Design

Local Logical Design

Normalization

Oracle SQL (Data Definition and Manipulation)


Maximum 80 points

Section A (Definitions and one example for each) 

Section B (Short Answer Questions) 

Section C (True or False & Fill-in the blnks) 

Section D (Multiple Choice Questions) 

Section E (Normalization. Convert a table into 1NF, 2NF, and 3NF) 

Section F (Write SQL commands for creating tables and making queries)