Homework Help is Here – Start Your Trial Now!
Engineering
Electrical Engineering
3. Given the dependency diagram of attributes (C1,C2,C3,C4,CS) in a table shown in the following figure, (the primary key attributes are underlined) Makao CI C2 C4 CS Create a database with multiple tables from attributes as shown above that are in 3NF, showing PK, non-key attributes, and FK for each table? Assume the tables are already in 1NF. (Hint: 3 tables will result after deducing 1NF→ 2NF -> 3NF] [5 Marks] Show the steps here.

3. Given the dependency diagram of attributes (C1,C2,C3,C4,CS) in a table shown in the following figure, (the primary key attributes are underlined) Makao CI C2 C4 CS Create a database with multiple tables from attributes as shown above that are in 3NF, showing PK, non-key attributes, and FK for each table? Assume the tables are already in 1NF. (Hint: 3 tables will result after deducing 1NF→ 2NF -> 3NF] [5 Marks] Show the steps here.

Electricity for Refrigeration, Heating, and Air Conditioning (MindTap Course List)
Electricity for Refrigeration, Heating, and Air Conditioning (MindTap Course List)
10th Edition
ISBN:9781337399128
Author:Russell E. Smith
Publisher:Russell E. Smith
Chapter17: Commercial And Industrial Air-conditioning Control Systems
Section: Chapter Questions
Problem 22RQ
See similar textbooks
icon
Related questions
Question

No AI, Use pencil and paper

3. Given the dependency diagram of attributes (C1,C2,C3,C4,CS) in a table shown in the following figure, (the primary key attributes are underlined) Makao CI C2 C4 CS Create a database with multiple tables from attributes as shown above that are in 3NF, showing PK, non-key attributes, and FK for each table? Assume the tables are already in 1NF. (Hint: 3 tables will result after deducing 1NF→ 2NF -> 3NF] [5 Marks] Show the steps here.
Transcribed Image Text:3. Given the dependency diagram of attributes (C1,C2,C3,C4,CS) in a table shown in the following figure, (the primary key attributes are underlined) Makao CI C2 C4 CS Create a database with multiple tables from attributes as shown above that are in 3NF, showing PK, non-key attributes, and FK for each table? Assume the tables are already in 1NF. (Hint: 3 tables will result after deducing 1NF→ 2NF -> 3NF] [5 Marks] Show the steps here.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Electricity for Refrigeration, Heating, and Air C…
Electricity for Refrigeration, Heating, and Air C…
Mechanical Engineering
ISBN:
9781337399128
Author:
Russell E. Smith
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS