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 Employee Name Base Salary Commission Percentage Department Number Department Name Manager ID Manager Name Product Number Product Name Unit Price Quantity (of product sole) Office Number Office Size Office Window After discussion with the company, it was determined that the following functional dependencies hold for the
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 Employee Name Base Salary Commission Percentage Department Number Department Name Manager ID Manager Name Product Number Product Name Unit Price Quantity (of product sole) Office Number Office Size Office Window After discussion with the company, it was determined that the following functional dependencies hold for the
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter2: Data Models
Section: Chapter Questions
Problem 15P
Related questions
Question
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
Employee Name
Base Salary
Commission Percentage
Department Number
Department Name
Manager ID
Manager Name
Product Number
Product Name
Unit Price
Quantity (of product sole)
Office Number
Office Size
Office Window
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.
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
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.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning