STUDENT STUDENT ID STUDENT_NAME ADVISOR ID ADVISOR ADVISOR_NAME DEPARTMENT_CODE ADVISOR ID DEPARTMENT DEPARTMENT CODE DEPARTMENT_NAME APPOINTMENT STUDENT ID ADVISOR ID APPOINTMENT_DATE Attribute Name Sample Value Sample Value Sample Value Sample Value STUDENT ID 123456 123456 478596 389987 Kim Brutt STUDENT_NAME Donald Nouglle Kim Brutt Mary King ADVISOR_ID 123 473 567 123 John Smith ADVISOR_NAME John Smith Kim Young Julia Roberts DEPARTMENT_CODE AIT ЕСЕ CS AIT DEPARTMENT NAME Applied Information Computer Technology Electrical Applied Information Technology Engineering Science APPOINTMENT_DATE 01/01/2009 05/03/2009 03/06/2009 01/01/2009

Question
  1. Using the table structures you created (in first attachment called "Table Stucture", 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.  **Original table stucture used to draw the fist attachment is attached i=as "Table Structure Orginal"
STUDENT
STUDENT ID STUDENT_NAME
ADVISOR ID
ADVISOR
ADVISOR_NAME DEPARTMENT_CODE
ADVISOR ID
DEPARTMENT
DEPARTMENT CODE
DEPARTMENT_NAME
APPOINTMENT
STUDENT ID
ADVISOR ID
APPOINTMENT_DATE

Image Transcription

STUDENT STUDENT ID STUDENT_NAME ADVISOR ID ADVISOR ADVISOR_NAME DEPARTMENT_CODE ADVISOR ID DEPARTMENT DEPARTMENT CODE DEPARTMENT_NAME APPOINTMENT STUDENT ID ADVISOR ID APPOINTMENT_DATE

Attribute Name
Sample Value
Sample Value
Sample Value
Sample Value
STUDENT ID
123456
123456
478596
389987
Kim Brutt
STUDENT_NAME
Donald Nouglle
Kim Brutt
Mary King
ADVISOR_ID
123
473
567
123
John Smith
ADVISOR_NAME
John Smith
Kim Young
Julia Roberts
DEPARTMENT_CODE AIT
ЕСЕ
CS
AIT
DEPARTMENT NAME Applied Information Computer
Technology
Electrical
Applied Information
Technology
Engineering
Science
APPOINTMENT_DATE 01/01/2009
05/03/2009
03/06/2009
01/01/2009

Image Transcription

Attribute Name Sample Value Sample Value Sample Value Sample Value STUDENT ID 123456 123456 478596 389987 Kim Brutt STUDENT_NAME Donald Nouglle Kim Brutt Mary King ADVISOR_ID 123 473 567 123 John Smith ADVISOR_NAME John Smith Kim Young Julia Roberts DEPARTMENT_CODE AIT ЕСЕ CS AIT DEPARTMENT NAME Applied Information Computer Technology Electrical Applied Information Technology Engineering Science APPOINTMENT_DATE 01/01/2009 05/03/2009 03/06/2009 01/01/2009

Expert Answer

1 Rating

Want to see the step-by-step answer?

See Answer

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

See Answer
*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: Given the following snippet of C++ code: int int1 = -125;unsigned int uInt1 = int1;float float1 = in...

A: The variables are stored in the following format:int1 is a signed int type variable and 32 bits long...

Q: do big data could replace the artistic vision of a creative director? and why?

A: Justification:“Yes”, big data replace the artistic vision of a creative director.

Q: Imagine that you and your team have been hired to develop an improved process for evaluating which s...

A: Student's class 12th as well as his/her Entrance Exam will be checked.The information will be checke...

Q: In C++ Ask the user for three friends names, store the names in an array.  Output the array to a fil...

A: Program://include the required header files#include <iostream>#include<fstream>#include ...

Q: m2 separated by a distance d is given by:F = Gm1m2d 2where G is the universal gravitational constant...

A: A C++  program to display the gravitational force between two objects is given below;Program code://...

Q: Hi,  Please,I have a question with Python,I have to create a Loop and terminate BMI calculation flow...

A: The loop of flow chart for BMI is given as:

Q: This is C++ my programming lab 11.7: Customer AccountsWrite a program that uses a structure to store...

A: Declare the structure Customer_Accounts with the required data fields. Also, declare an array of 20 ...

Q: (check all that apply) The ER model for a small bank system has Customer, Account, CheckingAccount, ...

A: The answer is option D - Employees and their supervisors.

Q: Can a python programmer write a program that takes a picture of its own source code and then hides a...

A: Python is a general purpose, interpreted, high level programming language that is used for developin...