Access Database - computers

posted by .

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!

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. IT Information Systems Technology

    Why are database management systems important in the business community?
  2. IT

    In this assignment, you are going to be gathering information about the future students of NSU at one of our open houses. Since there will be plenty of student candidates with interests on different programs, I would like you to create …
  3. Computers in Business

    I am in need of help with Microsoft Office Access 07. I am trying to set relationship tables and I have to enforce referential integrity on all 4 of my tables and cannot get it to work. What do I need to do?
  4. Database Essentials

    2 questions. what is the importance of databases in business world?
  5. crj216

    Define database and explain how you could use a simple database (like Microsoft Access or Microsoft Excel) to track criminal offenses in your local community. Discuss what criteria you would use to categorize offenses and why. Explain …
  6. computers

    which one of the following elements must be contained in an access database
  7. Access

    A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named uery1, which combines the data from the tables. If the Products table is deleted, what will happen …
  8. computer science

    Which term best describes a collection of student information and grades that might be similarly displayed in both Excel and Access?
  9. computer science

    I need a realational database containing information about music performers, their recordings, and the composers of the music they recorded (no redundancies). Elements should include: database file contains at least 3 tables relationships …
  10. computer

    The field names in a database are also known as A. category or column heading ** B. The name of a row C. Individual cells in a database D. Records Am I right..?

More Similar Questions