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)
G1(STUDENT ID, STUDENTNAME, STUDENT ADDRESS, STUDENT MAJOR)
G2(COURSE ID, COURSE TITLE, INSTRUCTOR NAME)
G3(INSTRUCTOR NAME, INSTRUCTOR OFFICE)
G4(STUDENT ID, COURSE ID, 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.
P1(PART NO., PART DESCRIPTION)
P2(VENDOR ID, VENDOR NAME, VENDOR ADDRESS)
P3(PART NO., VENDOR ID, UNIT COST)
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.
P1(PROJECT ID, EMPLOYEE ID, TASK ID, TOTAL HOURS)
P2(EMPLOYEE ID, EMPLOYEE ADDRESS)
P3(PROJECT ID, TASK ID)
d. CLASS2 (COURSE NO., ROOM, SECTION NO., CAPACITY)
C1 (COURSE NO., ROOM, SECTION NO.)
C2 (ROOM, CAPACITY)
e. CLASS3 (COURSE NO., COURSE_NAME, ROOM, SECTION NO., CAPACITY)
C1 (COURSE NO., COURSE_NAME)
C2 (COURSE NO., SECTION NO, ROOM)
C3 (ROOM, CAPACITY)
f. PROJECT (PROJECT ID, EMPLOYEE SALARY, EMPLOYEE ID)
Assumption: many-to-many relationship between PROJECT ID AND EMPLOYEE ID
P1 (PROJECT ID, EMPLOYEE ID)
P2 (EMPLOYEE SALARY, 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 download
- concept of normalization and the most common normal forms
- functional dependencies and
- normal forms and normalization
- normalization of solutions mit opencourseware
- nominalization practice worksheet 1
- database design normalization note exercises
- chapter 4 normalization villanova
- normalization exercise solutions uncg
- normalization exercises
- extra normalization practice problems for final exam