Access Database - computers

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!

  1. 👍
  2. 👎
  3. 👁

Respond to this Question

First Name

Your Response

Similar Questions

  1. education tecnology

    1)what is a database: A)a group of information in slides B)a digital collection of information that can be sorted , organized , and analyzed C)a cart that is displays data from several fields D) a group of records about one person

  2. EDTECH

    UNIT 4 lesson 4 All of this information is part of a ___ in a database. a. record b. row c. column d. field What other information do you need to add to complete the database above? a. cell fill color b. fields c. field names d.

  3. ED TECH

    What is the purpose of filters in a database? A. Filters allow you to see only the records that meet specific criteria. B. Filters delete unnecessary data. C. Filters create charts based on specific criteria. D. Filters put data

  4. Technology

    Which of the following is true about filters in Microsoft® Excel databases? A. Filters sort information in alphabetical order. B. Filters create fields that describe the remaining data. C. Filters make it easier to find specific

  1. Educational Technology and Online Learning

    The field names in a database are also known as_____? Category or column headings The name of a row Individual cells in a database Records

  2. 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..?

  3. Math

    A state university wants to increase its retention rate of 4% for graduating students from the previous year. After implementing several new programs during the last two years, the university reevaluated its retention rate.

  4. Math

    A real estate company owns 218 efficiency apartments, which are fully occupied when the rent is $940 /month. The company estimated that for each $25 increase in rent, 5 apartments will become unoccupied. What rent should be

  1. Math

    Scott Mason purchased a 5-unit apartment building as an investment before he retired. From the rent he collects each month, Scott pays out $1,025 for expenses. How much rent must he charge for each of the 5 apartments if he wants

  2. Technology

    1. What is a database? a group of information in slides a digital collection of information that can be sorted, organized, and analyzed* a chart that displays data from several fields a group of records about one person 2.for

  3. statistics

    David wants to rent an unfurnished apartment for next semester. He took a random sample of 9 apartments adversised in the local Halifax paper, and recorded the rental rates. The rents (in $ per month) were: 500 650 600 505 450 550

  4. IT Information Systems Technology

    Why are database management systems important in the business community? Give atleast two reasons. Let's begin with what a database is. A database is a collection of data records. These records are on your computer and a program

You can view more similar questions or ask a new question.