
Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Material Type: Assignment; Professor: Barber; Class: Intro to Database Design; Subject: Computer Sci & Info Tech; University: Pellissippi State Technical Community College; Term: Unknown 1989;
Typology: Assignments
1 / 1
This page cannot be seen from the preview
Don't miss anything!
Homework Assignment 3 – 35 Points Due Wednesday, Apr. 15th This Assignment Will Be Discussed In Class and Will Not Be Accepted Late
[ 1 ] (15 pts., 3 ea.) Indicate the highest normal form for each of the following. (BCNF is far enough to consider and no need to decompose.)
[ 2 ] ( 20 pts.) A relation called Rel has been created and has the following SRN:
The following functional dependencies have been identified:
AL AM BN BO CP CQ PQ JD A,BG A.BH A,BI C,DJ E,FK A,B,C,D,E,FR
Decompose the relation into successive relations until all relations are in BCNF. Show the final FDDs and the SRN for each relation. Show your intermediate work but circle the final relations needed to implement a working database.