CUST_ID 78 CUST _ID 54 NAME YORK UNIVERSITY NAME SENECA COLLEGE LOCATION NORTH YORK LOCATION NORTH YORK SALES_REP ANDRE MARTIN SALES_REP PARVEZ RAI CUST _ID 74 CUST _ID 43 NAME RYERSON NAME INDIGO BOOKS LOCATION TORONTO LOCATION TORONTO SALES_REP PARVEZ RAI SALES_REP ANDRE MARTIN
View 4
Seneca Courses Inc.
Customer Forms
All customer information for SCI is maintained on file forms. The following are sample customer information forms:
|
CUST_ID |
78 |
|
CUST _ID |
54 |
|
|
|
NAME |
YORK UNIVERSITY |
|
NAME |
SENECA COLLEGE |
|
|
|
LOCATION |
NORTH YORK |
|
LOCATION |
NORTH YORK |
|
|
|
SALES_REP |
ANDRE MARTIN |
|
SALES_REP |
PARVEZ RAI |
|
|
|
CUST _ID |
74 |
|
CUST _ID |
43 |
|
|
|
NAME |
RYERSON |
|
NAME |
INDIGO BOOKS |
|
|
|
LOCATION |
TORONTO |
|
LOCATION |
TORONTO |
|
|
|
SALES_REP |
PARVEZ RAI |
|
SALES_REP |
ANDRE MARTIN |
|
|
Business Rules:
- NAME must always be different for each customer.
- SALES_REP must always have a value.
SALES_REP must be an existing employee.
A customer only has one sales rep, but the sales_rep may have more than one customer.
Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF and explain or list the primary key and foreign
Step by step
Solved in 3 steps
