Prepared for MIS 6326 by Dr. Sumit Sarkar
FIRST NORMAL FORM (1NF)
Lakewood College
Grade Report
Name: Emily Williams ID: 2688300458
Address: 208 Brooks Hall
Major: Information Systems
CourseID Course Instructor Instructor Grade
Title Name Location
IS 3100 Database Mngnt Codd B104 A
IS 3200 Systems Analysis Parsons B 317 B
STUDENT S. NAME ADDRESS MAJOR COURSE C. TITLE INSTRUC INSTR GR
ID ID -TOR OFFICE
268300458 Williams 208 Brooks MIS IS 3100 Intro MIS Davis B104 A
IS 3200 Database Codd B318 A
543291073 Baker 104 Philips ACCT IS 3100 Intro MIS Davis B104 B
IS 3200 Database Codd B318 A
ACC2000 Intro Acct Bennett B222 B
Prepared for MIS 6326 by Dr. Sumit Sarkar
SECOND NORMAL FORM (2NF)
STUDENT S. NAME ADDRESS MAJOR COURSE C. INSTRUC- INSTR GR
ID ID TITLE TOR OFFICE
268300458 Williams 208 Brooks MIS IS 3100 Intro MIS Davis B104 A
268300458 Williams 208 Brooks MIS IS 3200 Database Codd B318 A
543291073 Baker 104 Philips ACCT IS 3100 Intro MIS Davis B104 B
543291073 Baker 104 Philips ACCT IS 3200 Database Codd B318 A
543291073 Baker 104 Philips ACCT ACC2000 Intro Acct Bennett B222 B
Prepared for MIS 6326 by Dr. Sumit Sarkar
THIRD NORMAL FORM (3NF)
COURSE C. INSTRUC- INSTR
ID TITLE TOR OFFICE
IS 3100 Intro MIS Davis B104
IS 3200 Database Codd B318
ACC2000 Intro Acct Bennett B222
Prepared for MIS 6326 by Dr. Sumit Sarkar
BOYCE-CODD NORMAL FORM (BCNF)
STUDENT_ ID MAJOR ADVISOR
123 Physics Einstein
123 Music Mozart
456 Biology Darwin
789 Physics Bohr
999 Physics Einstein
Assumptions:
- Each student may major in several subjects
- A student has one advisor for each major area
- Each advisor advises in one area only
- Each major area has several advisors
- An advisor may advise several students in one major area
Prepared for MIS 6326 by Dr. Sumit Sarkar
FOURTH NORMAL FORM (4NF)
COURSE INSTRUCTOR TEXTBOOK
Management White Drucker
Green Peters
Black
Finance Gray Weston
Gilford
Course Instructor Textbook
Management White Drucker
Management Green Drucker
Management Black Drucker
Management White Peters
Management Green Peters
Management Black Peters
Finance Gray Weston
Finance Gray Gilford
Prepared for MIS 6326 by Dr. Sumit Sarkar
REFERENTIAL INTEGRITY
CUSTOMER
CUSTOMER NAME ADDRESS CITY/ST/ZIP DISCOUNT
NO
1273 Contemporary Designs 123 Oak Street Austin, TX 28348 5
1279 ABC Supply 208 Brooks Buffalo, NY 16829 5
2256 Commonwealth Builders 104 Philips Ave San Francisco, CA 91284 10
2345 Fred’s Furniture 50 High Street Denver Co 80617 5
ORDER
ORDER NO ORDER DATE PROMISED DATE CUSTOMER NO
61396 2/4/98 2/21/98 2256
61400 3/7/98 4/7/98 2345
64219 3/19/98 4/4/98 1273