need Help Normalizing a table

[Jpower24]

Normalize the following table.  Use the notation CUSTOMER (CustomerID, Name, Street, Zip, Phone)

and ZIPCODES (Zip, City, State) to indicate the name of the table (or new table) followed by the list of columns , where the one(s)  underlined is (are) the primary or the composite key.

 

Member Company Table

 

MemberID Name Company CompanyLocation  

1 John Little ABC Alberta  

2 Sam Waters MCI Barrie  

3 Mel Brooks IBM Toronto  

4 Jill Claiborne MCI Barrie  

5 Ben Stiller AIC Stroud  

6 Fred Flintstone ABC Alberta  

7 Joe Canada RUT Halifax  

8 Greg Ramsey XYZ St Johns  

9 Doug Hope IBM Toronto

 

 

Normalize the following table.  Use the notation CUSTOMER (CustomerID, Name, Street, Zip, Phone)

and ZIPCODES (Zip, City, State) to indicate the name of the table (or new table) followed by the list of columns , where the one(s)  underlined is (are) the primary or the composite key.

 

Member DBKnow table

 

MemberID Name Db Know Db Know Db Know  

1 John Little Access DB2 FoxPro  

2 Sam Waters DBase Clipper  

3 Mel Brooks  

4 Jill Claiborne DB2 Oracle  

5 Ben Stiller Oracle Sybase  

6 Fred Flintstone Informix  

7 Joe Canada  

8 Greg Ramsey Access SQL  

9 Doug Hope

 

 

[fenway]

Normalize the following table.

 

Sounds like homework to me.

[Jpower24]

yea it was schoolwork, a quiz to be exact, so your close. It's over now, and was over when i posted but I still do not know the answer.

[fenway]

OK, well, how far did you get?