1 / 8

SUBJECT REPORT

This report discusses the process of normalization for multiple reports, including lecturer details, student details, and academic records.

mercedesj
Download Presentation

SUBJECT REPORT

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SUBJECTS CURRENTLY APPROVED Subject Code Subject Name Subject Description Subject Credit CS830 Introduction to Databases Database Technology 15 CS577 Object-Oriented Programming C++ Programming 15 CS670 Computer Programming for Technologist C Programming 10 CS825 Software Engineering Analysis and Design Analysis and Design 10 Normalization of Multiple Reports SUBJECT REPORT

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

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

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

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

  6. 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}) • 1NF: • STUDENT (stu#, stu_name, stu_address, stu_crse, stu_mode, lect#, lect_name) • AC-REC (stu#, subject#, subject_name, yr_sem, grade) • 2NF: • STUDENT (stu#, stu_name, stu_address, stu_crse, stu_mode, lect#, lect_name) • AC-REC (stu#, subject#, yr_sem, grade) • SUBJECT (subject#, subject_name) • 3NF, 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)

  7. 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)

  8. 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)

More Related