Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Rem Cat 01 Please find the database table below. Staff Staff Name si Mahta Salim Al Badi Dept (RoomNo, Location) IT, New Building ProjectID P1

image text in transcribed
Rem Cat 01 Please find the database table below. Staff Staff Name si Mahta Salim Al Badi Dept (RoomNo, Location) IT, New Building ProjectID P1 Project Name IOT 300 P2 350 6 P3 500 A S2 Zuwalna Rashid Al Alowi P3 Big Data Accounting Accounting Big Data BS Main Bulding EN Engg Building B 375 400 S4 Rahman Al Abri P2 B P1 500 A Assume that above table has following functional dependencies: Stal > StaffName, Dept PrajectID -> Project Name Staff, Project Rem Remi - Cat Find the Primary key of the table. (1 Mark) Check the conditions of First Normal Form (INF) to check if the table is in 1NF, it No, make it INF compliant. (2 Marks) Check the conditions of Second Normal Form (2NF) on the resultant tables to check if the tables are in 2NF, if No, make them 2NF compliant (2.5 Marks Check the conditions of Third Normal Form (BNF) on the resultant tables to check if the tables are in 3NF, if No, make them 3NF compliant. 25 Maries) When you are sure that all the tables are in 3NF, name all the tables with suitable names and mark the primary keys. (2 Marks)

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

Step: 3

blur-text-image

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

Advanced Database Systems For Integration Of Media And User Environments 98

Authors: Yahiko Kambayashi, Akifumi Makinouchi, Shunsuke Uemura, Katsumi Tanaka, Yoshifumi Masunaga

1st Edition

9810234368, 978-9810234362

More Books

Students also viewed these Databases questions