WebCT-chapter07sols

# WebCT-chapter07sols - Answers to Chapter 7 Problems 1...

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

Answers to Chapter 7 Problems 1. stdcity FDs and sample data that violates the FDs. The rows refer to the sample data below. stdcity offerno is violated by the first two rows and the last two rows stdcity offterm is violated by the last two rows stdcity enrgrade is violated by the first two rows and the last two rows stdcity courseno is violated by the first two rows and the last two rows stdcity crsdesc is violated by the first two rows and the last two rows stdssn stdcity stdclass offerno offterm offyear enrgrade courseno crsdesc s1 seattle jun o1 fall 2005 3.5 c1 db s1 seattle jun o2 fall 2005 3.3 c2 vb s2 bothell jun o3 spring 2006 3.1 c3 oo s2 bothell jun o2 fall 2005 3.4 c2 vb 2. stdcity FDs not violated by the original sample data are listed below along with a reference to new rows (after row 4) that violate the FDs. stdcity stdssn is violated by either the first or second row and the fifth row stdcity stdclass is violated by either the first or second row and the fifth row stdcity offyear is violated by either the first or second row and the fifth row stdssn stdcity stdclass offerno offterm offyear enrgrade courseno crsdesc s1 seattle jun o1 fall 2006 3.5 c1 db s1 seattle jun o2 fall 2006 3.3 c2 vb s2 bothell jun o3 spring 2007 3.1 c3 oo s2 bothell jun o2 fall 2006 3.4 c2 Vb s3 seattle SR O1 fall 2007 3.3 C1 DB 3. PatZip FDs and sample rows that violate the FDs. The rows refer to the sample data below. PatZip PatNo is not violated by the sample data PatZip PatAge is not violated by the sample data PatZip VisitDate is not violated by the sample data PatZip VisitNo is not violated by the sample data PatZip ProvNo is violated by the first two rows PatZip ProvSpecialty is violated by the first two rows PatZip Diagnosis is violated by first two rows

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

View Full Document
2/23/2011 Answers to Chapter 7 Problems VisitNo VisitDate PatN PatAge PatCity PatZip ProvN o ProvSpecialty Diagnosis V1002 0 1/13/2007 P1 35 DENVER 80217 D1 INTERNIST EAR INFECTION V1002 0 1/13/2007 P1 35 DENVER 80217 D2 NURSE PRACTITIONER INFLUENZA V9303 0 1/20/2007 P3 17 ENGLEWOO D 80113 D2 NURSE PRACTITIONER PREGNANCY V8211 0 1/18/2007 P2 60 BOULDER 85932 D3 CARDIOLOGIST MURMUR 4. PatZip FDs not violated by the original sample data are listed below along with a reference to the new rows (after row 4) that violate the FDs. PatZip PatNo is violated by the third and fifth rows PatZip PatAge is violated by the third and fifth rows PatZip VisitDate is violated by the third and fifth rows PatZip VisitNo is violated by the third and fifth rows VisitNo VisitDate PatNo PatAge PatCity PatZip ProvNo ProvSpecialty Diagnosis V10020 1/13/2004 P1 35 DENVER 80217 D1 INTERNIST EAR INFECTION V10020 1/13/2004 P1 35 DENVER 80217 D2 NURSE PRACTITIONER INFLUENZA V93030 1/20/2004 P3 17 ENGLEWOOD 80113 D2 NURSE PRACTITIONER PREGNANCY V82110 1/18/2004 P2 60 BOULDER 85932 D3 CARDIOLOGIST MURMUR V34210 1/18/2004 P4 65 ENGLEWOOD 80113 D3 CARDIOLOGIST IRREGULAR BEAT
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 02/21/2011 for the course MIS 310 taught by Professor Staff during the Spring '08 term at George Mason.

### Page1 / 11

WebCT-chapter07sols - Answers to Chapter 7 Problems 1...

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

View Full Document
Ask a homework question - tutors are online