DatabaseHW6_PartA+B

DatabaseHW6_PartA+B - DATABASE HOMEWORK 6 PARTS A+B Part A...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
DATABASE HOMEWORK 6 PARTS A+B Part A : Project Functional Dependencies : TagNumber PriceTag, FreeVersion ProgramCode ProgramName, Purpose, Author, DirectLink, TagNumber, SDBN SDBN IEEECode, CommandLine, GUI, OpenSource IEEECode Windows, Linux, MacOSX, BSD Proof of 2NF : All non key columns are dependant on the full primary key in each table (1 entity .( Proof of 3NF : The only determinants in each table are candidate keys; TagNumber, ProgramCode, SDBN, and IEEECode are all candidate keys . Part B : 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/30/2008 for the course CS 215 taught by Professor Dr.hussain during the Fall '07 term at New Haven.

Page1 / 3

DatabaseHW6_PartA+B - DATABASE HOMEWORK 6 PARTS A+B Part A...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online