Business
Engineering
Math
Science
Social ScienceSTUDENTSTUDENT 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
- 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"
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
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
Expert Answer
Image Transcriptionclose
STUDENT NAME ADVISOR ID ADVISOR NAME DEPARTMENT_CODE DEPARTMENT_NAME APPOINTMENT DATE STUDENT ID
Following dependencies are present in given table:
Image Transcriptionclose
STUDENT_ID- STUDENT_NAME ADSVISOR_ID ADVISOR_NAME, DEPARTMENT_CODE, DEPARTMENT_NAME DEARTMENT_CODE -DEPARTMENT_NAME STUDENT_ID, ADVISOR_ID -» APPOINTMENT_DATE
Hence primary key will be (STUDENT_ID, ADVISOR_ID). Both partial and transitive dependencies are present ...
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
Engineering
Computer Science
Related Computer Science Q&A
Find answers to questions asked by student like you
Show more Q&A addQ: 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...
