1. To keep track of students and their advisors, a university uses the table structure shown below. Assuming that the sample data are representative, draw a dependency diagram in Powerpoint that shows all functional dependencies including both partial and transitive dependencies. (Hint: Look at the sample values to determine the nature of the relationships.)
|
Attribute Name |
Sample Value |
Sample Value |
Sample Value |
Sample Value |
|
STUDENT_ID |
123456 |
478596 |
123456 |
389987 |
|
STUDENT_NAME |
Kim Brutt |
Mary King |
Kim Brutt |
Donald Nouglle |
|
ADVISOR_ID |
123 |
473 |
567 |
123 |
|
ADVISOR_NAME |
John Smith |
Kim Young |
Julia Roberts |
John Smith |
|
DEPARTMENT_CODE |
AIT |
CS |
ECE |
AIT |
|
DEPARTMENT_NAME |
Applied Information Technology |
Computer Science |
Electrical Engineering |
Applied Information Technology |
|
APPOINTMENT_DATE |
01/01/2009 |
05/03/2009 |
03/06/2009 |
01/01/2009 |
2. Using the initial dependency diagram drawn in question 1, remove all partial dependencies, draw the new dependency diagrams in Powerpoint, and identify the normal forms for each table structure you created.
3. Using the table structures you created in question 2, remove all transitive dependencies, and draw the new dependency diagrams in Powerpoint. Also identify the normal forms for each table structure you created. If necessary, add or modify attributes to create appropriate determinants or to adhere to the naming conventions.
4. Using the results of question 3, draw the fully labeled Crow’s Foot ERD in Powerpoint. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |