Asked by DAVE
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!
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!
Answers
There are no AI answers yet. The ability to request AI answers is coming soon!
There are no human answers yet. A form for humans to post answers is coming very soon!