Normalization of Multiple Reports SUBJECT REPORT SUBJECTS CURRENTLY

Normalization of Multiple Reports SUBJECT REPORT SUBJECTS CURRENTLY APPROVED Subject Code Subject Name Subject Description Subject Credit CS 830 Introduction to Databases Database Technology 15 CS 577 Object-Oriented Programming Computer Programming for Technologist C++ Programming 15 C Programming 10 Software Engineering Analysis and Design 10 CS 670 CS 825

Normalization of Multiple Reports LECTURER REPORT LECTURER DETAILS LECTURER'S NUMBER LECTURER'S NAME LECTURER'S OFFICE No. LECTURER'S PHONE No. LECTURING: AS 200 GUISEPPE BLOGGS Bldg 63 Room 130 52246 SUBJECT CODE SUBJECT NAME CS 830 Introduction to Databases CS 825 Software Engineering Analysis and Design Note: A given subject may have several lecturers.

Normalization of Multiple Reports STUDENT REPORT STUDENT DETAILS STUDENT No. S 1234567 STUDENT NAME Poindexter Jones STUDENT ADDRESS 23 Wide Road, Kew, 3101 COURSE ENROLLED BSc MODE OF STUDY Internal LECTURER NUMBER AS 200 LECTURER NAME Guiseppe Bloggs ACADEMIC RECORD: SUBJECT CODE SUBJECT NAME YEAR / SEMESTER GRADE CS 830 Introduction to Databases 2007/1 A CS 891 Computing Fundamentals 2007/1 B

Normalization of Multiple Reports SOLUTIONS SUBJECTS REPORT 1 NF, 2 NF , 3 NF, BCNF SUBJECT (subject#, subject_name, subject_desc, subject_credit)

Normalization of Multiple Reports LECTURER REPORT: UNF: LECTURER (lect#, lect_name, lect_office, lect_phone, (subject#, subject_name)) 1 NF: LECTURER (lect#, lect_name, lect_office, lect_phone) TEACH (lect#, subject_name) 2 NF: LECTURER (lect#, lect_name, lect_office, lect_phone) TEACH (lect#, subject#) SUBJECT (subject#, subject_name) 3 NF, BCNF: LECTURER (lect#, lect_name, lect_office, lect_phone ) TEACH (lect#, subject#) SUBJECT (subject#, subject_name)

Normalization of Multiple Reports STUDENT REPORT: UNF: STUDENT (stu#, stu_name, stu_address, stu_crse, stu_mode, lect#, lect_name, {subject#, subject_name, yr_sem, grade}) 1 NF: STUDENT (stu#, stu_name, stu_address, stu_crse, stu_mode, lect#, lect_name) AC-REC (stu#, subject_name, yr_sem, grade) 2 NF: STUDENT (stu#, stu_name, stu_address, stu_crse, stu_mode, lect#, lect_name) AC-REC (stu#, subject#, yr_sem, grade) SUBJECT (subject#, subject_name) 3 NF, BCNF: STUDENT (stu#, stu_name, stu_address, stu_crse, stu_mode, lect#) LECTURER (lect#, lect_name) AC-REC (stu#, subject#, yr_sem, grade) SUBJECT (subject#, subject_name)

Collected BCNF Relations 1. SUBJECT (subject#, subject_name, subject_desc, subject_credit) 2. LECTURER (lect#, lect_name, lect_office, lect_phone) 3. TEACH (lect#, subject#) 4. SUBJECT (subject#, subject_name) 5. STUDENT (stu#, stu_name, stu_address, stu_crse, stu_mode, lect#) 6. LECTURER (lect#, lect_name) 7. AC-REC (stu#, subject#, yr_sem, grade) 8. SUBJECT (subject#, subject_name)

Final Relations/Tables (Combine 1. 4. & 8. ) SUBJECT (subject#, subject_name, subject_desc, subject_credit) (Combine 2. & 6. ) LECTURER (lect#, lect_name, lect_office, lect_phone) (From 3. ) TEACH (lect#, subject#) (From 5. ) STUDENT (stu#, stu_name, stu_address, stu_crse, stu_mode, lect#) (From 7. ) AC-REC (stu#, subject#, yr_sem, grade)