Good primary key in table from real estate database

Assignment Help Operation Management

Reference no: EM132231414

1. If you need to make changes to a database and you aren't very confident that you will get it right, what is a good thing to do first?

Back up the database

Compact and repair the database

Encrypt the database

Print all all the data in the database

2. To add a predefined table to an existing database, you should use which of the following?

Application part

Blank desktop database

Custom web app

Database template

3. Which of the following would make a good primary key in a table from a real estate database?

House Number

Street Address

Zip Code

None of the above

4. If the real estate company is working on a short term project and needs to find out all real estate agents that have sold houses in Greenwich, CT, what database object in Access would they use?

Table

Query

Form

Report

5. The real estate company has an existing database for their residential property sales and agents. It has tables for agents, property details, and sales transactions. They are getting ready to expand into commercial properties and are planning what additional tables they need to add to the database. Would you recommend creating new tables for the expansion or using existing tables? Explain the things you consider to make this decision.

6. The real estate company company mentioned in the previous question is also thinking about moving their open house schedule from a paper calender to their database. Would you recommend creating new tables for the open house data or using existing tables? Explain the things you consider to make this decision.

7. In the real estate company they have a database to store information about their real estate agents and property listings. How would you describe the relationship between agents and property listings - one-to-one, one-to-many, or many-to-many? Explain why you chose that relationship.

8. In your own words, what is a primary key and why is it important to a database?

Reference no: EM132231414

Questions Cloud

Support teams in the organisation : How you would build and support teams in the organisation?

What role will e-mail and social networking play : How will you execute your plans to be the premier relationship company? What role will e-mail and social networking play?

Cultural facets mentioned compare to those among employers : Discuss how some of cultural facets mentioned compare to those among employers you have worked for and explain difference in views of these various employers.

Analysis of firms internal and external environments : The SWOT analysis, also known as a Situation Analysis, is an analysis of the firms internal and external environments.

Good primary key in table from real estate database : Which of the following would make a good primary key in a table from a real estate database?

Agreement is obtained on the message strategy : What are the four steps in video production after an agreement is obtained on the message strategy?

How does establishing goals help clients to develop hope : In some cases, clients face significant barriers of physical disability or illness, histories of trauma, occupational disadvantages, or addictions.

How to mitigate the effect of the stereotype : Return to at least one colleague and propose a strategy that might help mitigate the effect of the stereotype your colleague identified.

Describe the current practices around the identification : Identify and describe the current practices around the identification of leadership skills required and the strategies adopted to develop

User Account

All Pages