Existing database for their residential property sales

Assignment Help Operation Management
Reference no: EM132231507

1. 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.

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

3. 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.

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

Reference no: EM132231507

Questions Cloud

How can large corporate information systems : How can large corporate information systems such as CRM, ERP, and SCM have value?
Write expressions of sql query-relational algebra : Given following relational schema, I want to write expressions of SQL query/Relational algebra to answer the following.
The factors that should be modified by us based suppliers : To stop the outsourcing by original equipment manufacturer (OEMs) of US ,what are the factors that should be modified by US based suppliers?
Creating and replace a new disk copy from the backups : What is the mean time to a disk failure involving a data loss, if it takes 5 hours to creating and replace a new disk copy from the backups
Existing database for their residential property sales : The real estate company has existing database for their residential property sales and agents. It has tables for agents property details and sales transactions
Write complete javadoc style comments : Write complete JavaDoc style comments for all methods and for the class. Include your name at the top of the assignment as a block comment
How all five steps of the planning process could be used : The scenario presented was created to provide an interesting topic for discussion. However, it is very important that you do not get caught up in the story.
Is one method more fair than any of the others : Identify the basic payment methods used for the MCO to pay the provider (physician, hospital, etc.). Is one method more fair than any of the others? Why?
Develop an agenda for the meeting : Operations Manager at Grow Management Consultants and are required to develop an agenda and then chair a meeting on the company's upcoming leadership conference

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd