Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

Why is job analysis considered to be a basic HR tool?

Answered: 1 week ago

Question

Know how to use reservations systems to inventory demand.

Answered: 1 week ago