Raw Enity Relation Database (ERD) and Normalization Diagram (Data Base Managment experiance a must))

Given a set of user specifications for a database, you will create an entity-relationship model and explain your reasons for designing it as you did. the logic, concision, and clarity of your design explanation; and the overall physical appearance of your submission will hold highly in overall review. Project can be done in Power Point or word.
Draw the following ERD model showing both cardinality and connectivity:

* INSTRUCTOR may teach up to 4 CLASSE(S)
* A COURSE may generate infinite CLASSE(S)
* A CLASS has 10 to 30 ENROLLMENTS
* A STUDENT may have 5 ENROLLMENTS
* Hint: There are 5 tables in capital letters above that are connected by 4 relationships.
* Another Hint: All many ends of the connectivity relationships have (1,1) cardinality. Many but one-at-a-time
**I don t have VISIO so please don t use that program even if it is the preferred choice for this type of a project...

Normalization Diagram

Normalize a database to third normal form given a set of tables. Normalized data must makes logical sense. Again, insure that my name is written in any script as programmer etc.

Normalization


A) Given the following table, normalize to 3NF where PKPrimary Key and FK Foreign Key. Hint: 2nd normal form problem


Part Number (PK) Warehouse (PK) Location





B) Given the following table, normalize to 3NF where PKPrimary Key and FK Foreign Key. Hint: transitivity problem
C)


Employee ID (PK) Dept Dept Location