Answered step by step
Verified Expert Solution
Question
1 Approved Answer
tranaform into 3nf Consider the Student relation schema: Student (stuID, stuName, Dept, Building, Tel, Unit, Grade, Credit) intended to contain data on students, departments, units
tranaform into 3nf
Consider the Student relation schema: Student (stuID, stuName, Dept, Building, Tel, Unit, Grade, Credit) intended to contain data on students, departments, units and student's grades in units. Here each student has a unique stulD, each department is in one building only and has the unique telephone number, and each unit has the unique code. The table below is a snapshot of the data held in the database. stulD stuName Dept Buiding Tel Unit Grade Credit 3588 Daniel Turco COMP F6A 955 ISYS111 HD 3 7644 Tony Johnson COM 2751 Susan Ross Engineering E6B 2931 Jane Wong COMP 3588 Denial Turco COMP 2751 Susan Ross Engineering E6B E6A 9551 ISYS123 D 3 9558 COMP115 HD3 3 E6A E6A 9551 COMP245 F 9551 ISYS125 D 9558 COMP125 P - Table 1: A snapshot of student records (a) (2 marks) The data in the table is susceptible to update anomalies. Briefly explain the mature of the three forms of anomalies (insertion, deletion, and update/modification anomalies). Provide examples of how insertion, deletion, and update anomalies could occur on Table 1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started