Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Convert to following table in 1NF further identify partial dependency and convert in 2NF and at last identify transitive dependency and convert in
1. Convert to following table in 1NF further identify partial dependency and convert in 2NF and at last identify transitive dependency and convert in 3NF. 7.5 marks MovieID = MID, MovieName = Mname. DirectorID = DID, Directorname = Dname, CompanyID= CID, CompanyName = Cname MID Mname Genre DID Dname CID Cname M01 ABC Horror, D01 Ali Drama M01 ABC Horror, D01 Ali Drama Sci-fi, D02 Saad Drama Sci-fi, D02 Saad Drama Sci-fi, Drama M02 XYZ M02 XYZ M03 AFG Actorid Actorname DateSigning Amount C01 Shaheens A01 Saad 3.12.20 500k C01 Shaheens A02 C02 Falcons A01 Farhan D03 Farhad C03 Lions A01 Saad C02 Falcons A03 Shoaib Saad 3.12.20 13.10.19 13.10.19 27.9.18 450k 300k 350k 300k
Step by Step Solution
★★★★★
3.34 Rating (151 Votes )
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
Database Systems Design Implementation and Management
Authors: Carlos Coronel, Steven Morris
11th edition
9781305323230, 1285196147, 1305323238, 978-1285196145
