relationships

[20sunflower]

Could someone please check the relationships between these entities? I think I've forgot to include a primary key in the reservations table. I think the primary key should be guest ID. Also, do I need a composite key?

Thanks

 

[DCrake]

Haven't you forgotten something?

 

[JamesMcS]

What entities?

 

[20sunflower]

What entities?

I thought I could upload a screen shot of the relationships, but the file is too big.

 

[20sunflower]

I have 3 tables:
guests
rooms
reservations

with the primary key in the guest table as guest ID
with the primary key in the rooms table as room number

do I need a primary key in the reservations table?

 

[vbaInet]

Zip it and upload it. Or save it as a Jpeg. This was in response to your other post.

 

[20sunflower]

Zip it and upload it. Or save it as a Jpeg. This was in response to your other post.

How do I do that? Sorry for the dumb question but I don't know. I have the image saved in a word doccument.

 

[vbaInet]

Use Paint (i.e. Accessories > Pain) and paste the screenshot in there, then Save As (or something like that).

Or

Right-click the word document and Save As > Send to Archive.

 

[20sunflower]

Use Paint (i.e. Accessories > Pain) and paste the screenshot in there, then Save As (or something like that).

Or

Right-click the word document and Save As > Send to Archive.

Thanks. I've attached it as a JPEG now I think