STUDENTSTUDENT ID STUDENT_NAMEADVISOR IDADVISORADVISOR_NAME DEPARTMENT_CODEADVISOR IDDEPARTMENTDEPARTMENT CODEDEPARTMENT_NAMEAPPOINTMENTSTUDENT IDADVISOR IDAPPOINTMENT_DATE Attribute NameSample ValueSample ValueSample ValueSample ValueSTUDENT ID123456123456478596389987Kim BruttSTUDENT_NAMEDonald NouglleKim BruttMary KingADVISOR_ID123473567123John SmithADVISOR_NAMEJohn SmithKim YoungJulia RobertsDEPARTMENT_CODE AITЕСЕCSAITDEPARTMENT NAME Applied Information ComputerTechnologyElectricalApplied InformationTechnologyEngineeringScienceAPPOINTMENT_DATE 01/01/200905/03/200903/06/200901/01/2009

Question
Asked Sep 27, 2019
  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
help_outline

Image Transcriptionclose

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

fullscreen
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
help_outline

Image Transcriptionclose

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

fullscreen
check_circle

Expert Answer

star
star
star
star
star
1 Rating
Step 1
STUDENT NAME
ADVISOR ID
ADVISOR NAME
DEPARTMENT_CODE DEPARTMENT_NAME APPOINTMENT DATE
STUDENT ID
help_outline

Image Transcriptionclose

STUDENT NAME ADVISOR ID ADVISOR NAME DEPARTMENT_CODE DEPARTMENT_NAME APPOINTMENT DATE STUDENT ID

fullscreen
Step 2

Following dependencies are present in given table:

STUDENT_ID- STUDENT_NAME
ADSVISOR_ID ADVISOR_NAME, DEPARTMENT_CODE,
DEPARTMENT_NAME
DEARTMENT_CODE
-DEPARTMENT_NAME
STUDENT_ID, ADVISOR_ID -» APPOINTMENT_DATE
help_outline

Image Transcriptionclose

STUDENT_ID- STUDENT_NAME ADSVISOR_ID ADVISOR_NAME, DEPARTMENT_CODE, DEPARTMENT_NAME DEARTMENT_CODE -DEPARTMENT_NAME STUDENT_ID, ADVISOR_ID -» APPOINTMENT_DATE

fullscreen
Step 3

Hence primary key will be (STUDENT_ID, ADVISOR_ID). Both partial and transitive dependencies are present ...

STUDENT TABLE
STUDENT_ID
STUDENT_NAME
ADVISOR TABLE
ADVISOR_ NAME DEPARTMENT_CODE DEPARTMENT_NAME
ADVISOR_ID
APPOINTMENT TABLE:
APPOINTMENT DATE
STUDENT ID
ADVISOR ID
help_outline

Image Transcriptionclose

STUDENT TABLE STUDENT_ID STUDENT_NAME ADVISOR TABLE ADVISOR_ NAME DEPARTMENT_CODE DEPARTMENT_NAME ADVISOR_ID APPOINTMENT TABLE: APPOINTMENT DATE STUDENT ID ADVISOR ID

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Related Computer Science Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

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...

question_answer

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.

question_answer

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...

question_answer

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 ...

question_answer

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://...

question_answer

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:

question_answer

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 ...

question_answer

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.

question_answer

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...