Answered: Consider the following information for…

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

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.

Expert Solution

Trending now

This is a popular solution!

Step by step

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

Similar questions