Jpower24 Posted April 20, 2007 Share Posted April 20, 2007 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted April 20, 2007 Share Posted April 20, 2007 Normalize the following table. Sounds like homework to me. Quote Link to comment Share on other sites More sharing options...
Jpower24 Posted April 20, 2007 Author Share Posted April 20, 2007 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 22, 2007 Share Posted April 22, 2007 OK, well, how far did you get? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.