1. Normalization (worth 3.5 points). Answer the questions below about the Customer-Sales Representative table of data.

SalesRep ID	SalesRep Name	Cust ID	Customer Name	Cust StartDate	RegionID	Region Name
S001	Robinson	C5002	Tire World	10/1/2005	R1	Eastern
S001	Robinson	C5003	Auto SuperStore	6/22/2006	R1	Eastern
S002	Martin	C5004	Monster Tires	8/10/2005	R1	Eastern
S002	Martin	C5005	Truck Mart	10/9/2005	R1	Eastern
S003	Thompson	C5006	Tire Carnival	10/1/2005	R2	Western

1. List the attribute(s) that should serve as the primary key for this table of data. (1.0)

2. State the current normal form of the table of data above and list the three types of functional dependencies that exist in the table. (1.0)

3. Normalize the table of data above to 3rd normal (step by step) form and draw the resulting relational schema. Dont forget to specify primary keys & foreign keys and draw the arrows in the correct direction. (1.5)