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.

A salesperson can be involved in many orders. Usually a given order will be handled by only one salesperson. But complex orders may involve several salespersons. If you know the Salesperson number, you can figure out the salesperson’s last name and the department in which they work. While a department might have many salespersons it has just one manager. If you know an Order number, you will know the order date and order total. Knowing just an order date reveals nothing important

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

Tables

a. Functional Dependencies