MIS 114 - Database Management Systems for Business
Normalization Practice Problems
Normalize each of the following relations to fourth normal form if it is needed. Indicate primary key using single underline, and foreign key using double underlines. State your assumption(s) that has to be realistic and logical.
a. GRADE_REPORT (STUDENT ID, STUDENTNAME, STUDENT ADDRESS, STUDENT MAJOR, COURSE ID, COURSE TITLE, INSTRUCTOR NAME, INSTRUCTOR OFFICE, GRADE)
b. PART_SUPPLIER (PART NO., PART DESCRIPTION, VENDOR ID, VENDOR NAME, VENDOR ADDRESS, UNIT COST)
Assumption: many-to-many relationship between PART NO and VENDOR ID.
c. PROJ (PROJECT ID, EMPLOYEE ID, EMPLOYEE ADDRESS, TOTAL HOURS, TASK ID)
Assumptions: many-to-many relationship between PROJECT ID and EMPLOYEE ID, and many-to-many relationship between PROJECT ID and TASK ID.
d. CLASS2 (COURSE NO., ROOM, SECTION NO., CAPACITY)
e. CLASS3 (COURSE NO., COURSE_NAME, ROOM, SECTION NO. CAPACITY)
f. PROJECT (PROJECT ID, EMPLOYEE SALARY, EMPLOYEE ID)
Assumption: many-to-many relationship between PROJECT ID AND EMPLOYEE ID
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- free client database management software
- nonprofit database management software
- database management best practices
- database management system textbook pdf
- database management system book pdf
- client database management free
- free school database management software
- database management system pdf books
- common database management systems
- access database management system
- database management pdf
- database management systems list