Data Management and Development Notes

Student id course id 4356789 c1a7 4356789 m1f8 4356789

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview:   •  •  •  •  •  Student ID - > Student name Course ID - > Course 9tle Student ID ? Course ID Course 9tle ? Student name Student ID ? Grade Course ID ? Grade Dependence Student ID Student Name Course ID Course Title Grade Normaliza9on •  Normaliza9on is a “stepped” process –  1st normal form (1NF) –  2nd normal form (2NF) –  3rd normal form (3NF) –  Boyce- Codd normal form –  4th normal form –  5th normal form •  Generally, we don’t go beyond 3NF Normaliza9on •  First Normal Form –  No repea9ng groups and all values need to be “atomic” –  All acributes are dependent on the primary key, or at least part of a composite key No repea9ng groups Student ID Student Name Major Course ID 4356789 John Doe CHEM C1A7 M1F8 P1H6 4487654 Joe Bloe MATH M1F8 M1G3 E9R5 Course Title Basic Chemistry Calculus Basic Physics Calculus Basic Sta9s9cs English Literature Instructor ID 1208890 1390087 1234567 1390087 1423456 1223232 Instructor Name Grade James Buck B- Janice Fawn B Bambi Smith A- Janice Fawn A+ Michael Mike A Peter Peat C+ Student ID Student Name 4356789 John Doe 4356789 John Doe 4356789 John Doe 4487654 Joe Bloe 4487654 Joe Bloe 4487654 Joe Bloe Course Title Basic Chemistry Calculus Basic Physics Calculus Basic Sta9s9cs English Literature Instructor ID 1208890 1390087 1234567 1390087 1423456 1223232 Instructor Name Grade James Buck B- Janice Fawn B Bambi Smith A- Janice Fawn A+ Michael Mike A Peter Peat C+ Major Course ID CHEM C1A7 CHEM M1F8 CHEM P1H6 MATH M1F8 MATH M1G3 MATH E9R5 Atomic acributes Student ID Student Name Major Course ID 4356789 John Doe CHEM C1A7 4356789 John Doe CHEM M1F8 4356789 John Doe CHEM P1H6 4487654 Joe Bloe MATH M1F8 4487654 Joe Bloe MATH M1G3 4487654 Joe Bloe MATH E9R5 Course Title Basic Chemistry Calculus Basic Physics Calculus Basic Sta9s9cs English Literature Instructor ID 1208890 1390087 1234567 1390087 1423456 1223232 Instructor Name James Buck Janice Fawn Bambi Smith Janice Fawn Michael Mike Peter Peat Student ID Stud LNameStud Fname Major Course ID Course Title Instructor ID Instr Lname 4356789 Doe John CHEM C1A7 Basic Chemistry 1208890 Buck 4356789 Doe John CHEM M1F8 Calculus 1390087 Fawn 4356789 Doe 4487654 Bloe 4487654 Bloe John Joe Joe CHEM P1H6 MATH M1F8 MATH M1G3 4487654 Bloe Joe MATH E9R5 Basic Physics Calculus Basic Sta9s9cs English Literature Grade B- B A- A+ A C+ Instr FName Grade James B- Janice B 1234567 1390087 1423456 Smith Fawn Mike Bambi Janice Michael A- A+ A 1223...
View Full Document

Ask a homework question - tutors are online