I have to make a database to track university apartments in access. I am stuck trying to decide what type of tables and field names i should have.
would it make sense to have a table for students including first, last names, address, city, postal code, telephone number
table for apartments including number of bedrooms, rent cost, lease term, utilities, parking, address
and a final table for landlords including first, last names, address, telephone, city, state, postal code, telephone number
does this make sense or am i on the wrong track.. what would i use as the prmary key??
thanks!