{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

DatabaseHW6 - DATABASES HW6 SOLUTIONS Question1 First...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
DATABASES HW6 SOLUTIONS Question1 : First Normal Form Table: General AuthorLast AuthorNum PublisherCode BookCode Schlening 25 TA 1382 O'Rourke 23 TA 1382 SteinBeck 20 PE 2766 SteinBeck 20 PE 5163 Morrison 1 PL 6128 Ambrose 14 TO 6328 - Functional Dependencies : General (BookCode , PublisherCode, AuthorNum , AuthorLast ( - Why it is in First Normal Form : Because the table lacks repeating groups . - Why it is in Second Normal Form : The primary key consists of BookCode and AuthorNum . AuthorLast is a non-key column which is dependent only on AuthorNum , which is a portion of the Primary Key of the table General . 2NF is defined as: No non-key column is dependant on only a portion of the Primary Key. Thus, the example table is in First Normal Form but not in Second Normal Form . Second Normal Form Publisher Name Author AuthorNum BookCode 25 1382 23 2766 20 5163 1 6128 14 6328 PublisherCode BookCode TA 1382 PE 2766 PE 5163 PL 6128 TO 6328 AuthorLast AuthorNum Schlening 25 O'Rourke 23 SteinBeck 20 Morrison 1 Ambrose 14
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
- Conversion Process : 1 . Initial FD : General (BookCode
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern