You are given a table with sample data. Your task is to normalize the tables. Yo
ID: 3930109 • Letter: Y
Question
You are given a table with sample data. Your task is to normalize the tables. Your solution should not show tables with data. Instead, represent each table in this format:
TABLENAME (column, column, column … , column)
Underline the primary key for each table you create. If the table has a foreign key, it should be italicized.
Salesperson Number
Salesperson Lname
Dept ID
Dept Manager LName
Order Number
Order Date
Order Total
134
Katz
003
Davis
0112
10/15/11
$403.00
137
Smith
004
Johnson
0117
10/16/11
$135.00
134
Katz
003
Davis
0121
10/16/11
$338.50
a. Using the proper arrow notation, list any functional dependencies you have identified between attributes.
Salesperson Number
Salesperson Lname
Dept ID
Dept Manager LName
Order Number
Order Date
Order Total
134
Katz
003
Davis
0112
10/15/11
$403.00
137
Smith
004
Johnson
0117
10/16/11
$135.00
134
Katz
003
Davis
0121
10/16/11
$338.50
Explanation / Answer
Please find the answer below:
SALESPERSON (Salesperson Number, Salesperson Lname, Dept ID ); Here Dept ID refers DEPARTMENT table's primary key Dept ID
DEPARTMENT (Dept ID, Dept Manager LName)
ORDER (Order Number, Order Date, Order Total)
SALESPERSON_ORDER (Salesperson Number, Order Number); Here Salesperson Number refers to the SALESPERSON table's primary key : Salesperson Number; and Order Number refers to ORDER table's primary key Order Number
a)There are few functional dependencies identified in the relation, they are :
i) Salesperson Lname, Dept ID -> Salesperson Number (Salesperson Lname and Dept ID depends on salesperon number)
ii) Dept Manager LName -> Dept ID (Dept Manager LName depends on the dept id)
iii) Order Date, Order Total -> Order Number (Order Date and Order Total depends on Order Number )
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.