Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 11-21-2006, 12:00 PM   #1
Baseband Member
Join Date: Mar 2005
Posts: 58
Question -Normaliziing a table in Access 2003

I am having trouble determining how to Normalize a table.

The instructions:
Examine the table tblArtist. Normalize the table, creating any new tables you think are necessary to complete the normalization. Define a primary Key for the new table created. Join the new table created to the table tblArtist and enforce referential integrity between the two tables/

The table is: tblArtists

ArtistID (primary Key)
First Name
Last Name
Product ID1
Product ID2
Product ID3

I am lost on this step. Can someone point me in the right direction?

david6789 is offline   Reply With Quote
Old 11-21-2006, 02:18 PM   #2
In Runtime
Join Date: Dec 2005
Posts: 184
Send a message via AIM to Bloodstalker999
Default Re: -Normaliziing a table in Access 2003

What exactly do u need help on? I see the instructions but how far did you get in them? From what it looks like you need to create a new table for products use Product ID1 product ID2 and Product ID3 as the fields and create a Order id field which will be the primary key. Then make an asscoiative table linking the tblartist with the newly created tblorder using ArtistID and OrderID as the primary keys. You have to establish a many to many relationship in this case, threw creating a assocative table linking the two.

I think that is what you need to do, but it depends on your teacher. If you have more specific questions feel free to ask I just finished two database classes with A's, so I kinda know what I am talking about. hehehe ^_^
Live forever or die trying
Bloodstalker999 is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 08:15 AM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0