Relationshhips

[LauraS20]

I have a list of entitys and attributes associated with them
then i have a list of relationships between them
the problem is for these relationships to be valid i would need to enter more data in to the existing tables and perhaps create new tables.
could someone confirm this for me? and would i be better to stick to existign tables or create new ones as well
this is an assignment.
Cheers
laura

 

[Dwight]

LauraS20,

You need to set up your tables so that each record within the table is unique. Usually you use an autonumber primary key for this. And you need a common field in the table so that you can link it to the other tables. This is where the relationships come in.

For example, if you had two tables with 3 entities (A,B,C). Assume the first table has name info and the second has address info.

TableName
EntityID (autonumber)
Name

TableAddress
AddressID (autonumber)
EntityID
Address

Now you can form a relationship between the two through the common field of Entity ID.

Hope this helps.