Normalise the following collection of attributes that describe a library loan. S
ID: 3840595 • Letter: N
Question
Normalise the following collection of attributes that describe a library loan. Show the First Normal Forms that are derived, the second Normal Forms and the Third Normal Forms. First identify the primary key of each collection by underlining the attribute(s). LOAN (BORROWER_ID, BORROWER_ADDRESS, DATE_OF_BIRTH, FINES_DUE_AMT, (BOOK_ISBN, COPY_NUMBER, TITLE, (AUTHOR), PUBLISHER, PUBLISH_DATE, PURCHASE_DATE, LOAN_DATE, DUE_DATE, RETURN_DATE)) Normalise the following collection of attributes that describe a student's enrolment. As above, show the First Normal Forms that are derived, the second Normal Forms and the Third Normal Forms. Identify the primary key of each collection by underlining the attribute(s). ENROLMENT (STUDENT_ID, SEMESTER_ADDRESS, HOME ADDRESS, COURSE_CODE, COURSE_NAME, COURSE_START_DATE, EMAIL, PHONE, (SUBJECT_CODE, SUBJECT_NAME, YEAR_ENROLLED, SEMESTER_ENROLLED, SCORE, GRADE))Explanation / Answer
8.) The first normal form of the library loan database is given as :
The Primary key of the first normal table used to identify each record is BOOK_ISBN.
The Second Normal form of the database is :
The Primary key new table BOOK_COPY should be both BOOK_ISBN and COPY_NUMBER , because BOOK_ISBN alone cannot be uniquely used to identify the copies.
The third normal form of database is given as:
The Primary key new table Library_Loan_Copy is PUBLISHER and primary key of BOOK_COPY table has two primary keys BOOK_ISBN and COPY_NUMBER to identify uniquely.
9.) The first normal form of student's enrollment database is :
The primary key of the database is STUDENT_ID which is used to uniquely identify records.
The SECOND normal form of database is :
The primary key used to uniquely identify the table STUDENT_INFO is STUDENT_ID and SUBJECT_INFO.
The third normal form of the database is :
The primary key of the table is SUBJECT_CODE.
The Primary key of the table is SUBJECT_ID and SUBJECT_CODE is the foriegn key
The primary key of the table is COURSE_CODE and STUDENT_ID.
Library_Loan BORROWER_ID BORROWER_ADDRESS DATE_OF_BIRTH FINES_DUE_AMT BOOK_ISBN COPY_NUMBER TITLE AUTHOR PUBLISHER PUBLISH_DATE DUE_DATE RETURN_DATE LOAN_DATERelated Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.