S
Studebaker
I have 2 tables: Table A & Table B
Table A has field names: This is a table of owners of rental rooms.
owner ID, last name, first name, street, city, state, postal code, telephone
The owner ID I have picked in this table to be the primary key b/c it is
unique to each owner.
Table B has field names: This is a table of rental rooms
Room #, # of Bedrooms, # of Bathrooms, Sleeps How Many?, Linens, Weekly
Rate, Owner Last Name, and I added Owner ID.
I had trouble setting the primary key for this one. I chose the Room# as the
primary key b/c it is unique to each room. I added a field name called owner
ID here b/c I'm going to relate these 2 tables. Is that the idea behind
choosing a primary key for Table B? I didn't make Owner ID or any other field
in this table the primary key b/c you can have more than one owner ID rent
out a room.
Can someone verify I have the right idea?
Thank you.
Table A has field names: This is a table of owners of rental rooms.
owner ID, last name, first name, street, city, state, postal code, telephone
The owner ID I have picked in this table to be the primary key b/c it is
unique to each owner.
Table B has field names: This is a table of rental rooms
Room #, # of Bedrooms, # of Bathrooms, Sleeps How Many?, Linens, Weekly
Rate, Owner Last Name, and I added Owner ID.
I had trouble setting the primary key for this one. I chose the Room# as the
primary key b/c it is unique to each room. I added a field name called owner
ID here b/c I'm going to relate these 2 tables. Is that the idea behind
choosing a primary key for Table B? I didn't make Owner ID or any other field
in this table the primary key b/c you can have more than one owner ID rent
out a room.
Can someone verify I have the right idea?
Thank you.