Can you please do this problem step by step so I can follow along and understand this better and can you please highlight the answer can you label the parts as well. Problem: 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

Can you please do this problem step by step so I can follow along and understand this better and can you please highlight the answer can you label the parts as well. Problem: 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

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

Can you please do this problem step by step so I can follow along and understand this better and can you please highlight the answer can you label the parts as well.

Problem:

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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 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.