Consider the following information for a company which wishes to keep track of certain information about its sales staff and its products and how the products are selling. Specifically, the company has determined that it is interested in the following attributes. Employee ID Product Number Employee Name Product Name Base Salary Unit Price Commission Percentage Quantity (of product sole) Department Number Office Number Department Name Office Size Manager ID Office Window Manager Name After discussion with the company, it was determined that the following functional dependencies hold for the proposed database. Employee ID -> Employee Name Employee ID -> Base Salary Employee ID -> Commission Percentage Employee ID -> Department Number Employee ID -> Department Name Employee ID -> Manager ID Employee ID -> Manager Name Employee ID -> Office Number Employee ID -> Office Size Employee ID -> Office Window Product Number -> Product Name Product Number -> Unit price Department Number -> Department Name Department Number -> Manager ID Department Number -> Manager Name Office Number -> Office Size Office Number -> Office Window {Employee ID, Product Number} -> Quantity 1) Begin by creating a universal relation containing all the attributes. Select a primary key for the relation that will insure that the universal relation is in first normal form. 2) Decompose this table into additional tables as needed to put the set of tables into second normal form. 3) It is possible that none, some, or all of the tables created in step 2 are already in third normal form. Indicate which, if any, of the tables are already in third normal form. If any of the tables are not yet in third normal form, decompose these tables so that the resulting tables are in third normal form.

Consider the following information for a company which wishes to keep track of certain information about its sales staff and its products and how the products are selling. Specifically, the company has determined that it is interested in the following attributes. Employee ID Product Number Employee Name Product Name Base Salary Unit Price Commission Percentage Quantity (of product sole) Department Number Office Number Department Name Office Size Manager ID Office Window Manager Name After discussion with the company, it was determined that the following functional dependencies hold for the proposed database. Employee ID -> Employee Name Employee ID -> Base Salary Employee ID -> Commission Percentage Employee ID -> Department Number Employee ID -> Department Name Employee ID -> Manager ID Employee ID -> Manager Name Employee ID -> Office Number Employee ID -> Office Size Employee ID -> Office Window Product Number -> Product Name Product Number -> Unit price Department Number -> Department Name Department Number -> Manager ID Department Number -> Manager Name Office Number -> Office Size Office Number -> Office Window {Employee ID, Product Number} -> Quantity 1) Begin by creating a universal relation containing all the attributes. Select a primary key for the relation that will insure that the universal relation is in first normal form. 2) Decompose this table into additional tables as needed to put the set of tables into second normal form. 3) It is possible that none, some, or all of the tables created in step 2 are already in third normal form. Indicate which, if any, of the tables are already in third normal form. If any of the tables are not yet in third normal form, decompose these tables so that the resulting tables are in third normal form.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

After discussion with the company, it was determined that the following functional dependencies hold for the
proposed database.
Employee ID -> Employee Name
Employee ID -> Base Salary
Employee ID -> Commission Percentage
Employee ID -> Department Number
Employee ID -> Department Name
Employee ID -> Manager ID
Employee ID -> Manager Name
Employee ID -> Office Number
Employee ID -> Office Size
Employee ID -> Office Window
Product Number -> Product Name
Product Number -> Unit price
Department Number -> Department Name
Department Number -> Manager ID
Department Number -> Manager Name
Office Number -> Office Size
Office Number -> Office Window
{Employee ID, Product Number} -> Quantity

1) Begin by creating a universal relation containing all the attributes. Select a primary key for the relation that
will insure that the universal relation is in first normal form.
2) Decompose this table into additional tables as needed to put the set of tables into second normal form.
3) It is possible that none, some, or all of the tables created in step 2 are already in third normal form. Indicate
which, if any, of the tables are already in third normal form. If any of the tables are not yet in third normal
form, decompose these tables so that the resulting tables are in third normal form.

Expert Solution

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.