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 Visio 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 NameSample ValueSample ValueSample ValueSample ValueSTUDENT_ID123456478596123456389987STUDENT_NAMEKim BruttMary KingKim BruttDonald NouglleADVISOR_ID123473567123ADVISOR_NAMEJohn SmithKim YoungJulia RobertsJohn SmithDEPARTMENT_CODEAITCSECEAITDEPARTMENT_NAMEApplied Information TechnologyComputer ScienceElectrical EngineeringApplied Information TechnologyAPPOINTMENT_DATE01/01/200905/03/200903/06/200901/01/20092. Using the initial dependency diagram drawn in question 1, remove all partial dependencies, draw the new dependency diagrams in Visio, 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 Visio. 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 Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. AutoSaveM3_1Normalization_Assignment -O SearchffHARSHITH VANGOORHVFileHomeInsertDesignLayoutReferencesMailingsReviewViewHelpA ShareX CutFind- A A Aa v Aa- vАаBЬСcDd AaBЬсcDd AaBbC AаBbСcL AaBbC AaBbСсDd AaB AаBЬСсD AаBbСcDdArialv 10LE CopyE ReplacePasteBIUV ab x, x A - I vI Normal1 No Spac... Heading 1TitleA vHeading 2 Heading 3Heading 4SubtitleSubtle Em...A Select vS Format PainterClipboardFontParagraphStylesEditingQUESTION 11. 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 Visio thatshows all functional dependencies including both partial and transitive dependencies. (Hint: Lookat the sample values to determine the nature of the relationships.)Attribute NameSample ValueSample ValueSample ValueSample ValueSTUDENT_ID123456478596123456389987STUDENT_NAMEKim BruttMary KingKim BruttDonald NougleADVISOR_ID123473567123ADVISOR_NAMEJohn SmithKim YoungJulia RobertsJohn SmithDEPARTMENT_CODE AITCSЕСЕAITDEPARTMENT NAME Applied Information ComputerTechnologyApplied InformationTechnologyElectricalScienceEngineeringAPPOINTMENT_DATE 01/01/200905/03/200903/06/200901/01/20092. 2. Using the initial dependency diagram drawn in question 1, remove all partial dependencies,draw the new dependency diagrams in Visio, and identify the normal forms for each tablestructure you created.3. Using the table structures you created in question 2, remove all transitive dependencies, anddraw the new dependency diagrams in Visio. Also identify the normal forms for each tablestructure you created. If necessary, add or modify attributes to create appropriate determinants orto adhere to the naming conventions.4.3.4. Using the results of question 3, draw the fully labeled Crow's Foot ERD in Visio. The diagrammust include all entities, attributes, and relationships. Primary keys and foreign keys must beclearly identified on the diagram.Page 1 of 1238 wordsD Focus100%

Note: As per our company guidelines we are supposed to answer only first 3 sub parts. Kindly repost…

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 Visio 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 Visio, 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 Visio. 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 Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

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 Visio 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 Visio, 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 Visio. 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 Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.

AutoSave
M3_1Normalization_Assignment -
O Search
ff
HARSHITH VANGOOR
HV
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
A Share
X Cut
Find
- A A Aa v A
a- v
АаBЬСcDd AaBЬсcDd AaBbC AаBbСcL AaBbC AaBbСсDd AaB AаBЬСсD AаBbСcDd
Arial
v 10
LE Copy
E Replace
Paste
BIUV ab x, x A - I v
I Normal
1 No Spac... Heading 1
Title
A v
Heading 2 Heading 3
Heading 4
Subtitle
Subtle Em...
A Select v
S Format Painter
Clipboard
Font
Paragraph
Styles
Editing
QUESTION 1
1. 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 Visio 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 Nougle
ADVISOR_ID
123
473
567
123
ADVISOR_NAME
John Smith
Kim Young
Julia Roberts
John Smith
DEPARTMENT_CODE AIT
CS
ЕСЕ
AIT
DEPARTMENT NAME Applied Information Computer
Technology
Applied Information
Technology
Electrical
Science
Engineering
APPOINTMENT_DATE 01/01/2009
05/03/2009
03/06/2009
01/01/2009
2. 2. Using the initial dependency diagram drawn in question 1, remove all partial dependencies,
draw the new dependency diagrams in Visio, 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 Visio. 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.
3.
4. Using the results of question 3, draw the fully labeled Crow's Foot ERD in Visio. The diagram
must include all entities, attributes, and relationships. Primary keys and foreign keys must be
clearly identified on the diagram.
Page 1 of 1
238 words
D Focus
100%

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.