You are given a table with sample data Your task is to norma

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.

Solution

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 )