Reference no: EM131016390
The Assignment Specification
In this assignment-1, you are to implement the data modelling for a database that is based on the following application scenario.
The application scenario
The Best Home real estate company needs to implement a database to manage properties. The real estate has delegated this task to an IT service company. As an officer of the IT service company, you are delegated to be the designer and developer of the database. To accomplish this task, you will divide the design and development tasks into two assignments. In this assignment (assignment-1), you will do the data modelling. In assignment-2, you will design and implement the database and relevant SQL queries. Consequently, a successful data modelling of this assignment is also important for assignment-2.
The application scenario of The Best Home real estate is as follows.
1. The Best Home manages two types of property, property for rent and property for sale. A property could be available at the moment, rented or sold.
2. The people who need to be managed by the database include the property managers of The Best Home, the property owners, the customers (buyers and tenants) and the solicitors.
3. A property manager can manage sale properties and/or rental properties. A property manager can supervise other property managers.
4. A customer can make an application for a rental property or give an offer to a sale property.
5. A solicitor may involve in a property sale.
6. A property manager, a property owner, a customer or a solicitor could have a phone, a mobile and/or email contact.
The above application scenario was not presented in very detail for the entities or relations because one of your tasks for this assignment is to analyse and model the data in real estates. You may need to do some research about the data in real estate management and model the data with necessary attributes under some assumptions.
The assignment specification
You are to develop an ER model for the data management of The Best Home. You will need to provide the ER model to cover the data and transactions of The Best Home.
Your tasks are:
1. Identification and justification of entities. You need to identify all the necessary entities including super/sub type entities and justify your assumptions on those entities for the given application scenario.
2. Identification and justification of relationships. You need to identify all the necessary relationships and their cardinalities and justify your assumptions on those relationships/cardinalities for the given application scenario.
3. An ER diagram. You need to use the standard notations (as given in the textbook) to present the ER diagram, clearly representing entities and relationships, cardinalities and primary and foreign keys and using super types and sub types. The M:N relationship between entities is not allowed for the diagram. Thus you will need to translate an M:N relationship into multiple 1:M relationships with the aid of associative entities.
Note: use of a formal modelling tool such as Microsoft Visio is not required for the ER modelling. You can use any drawing tools to create the ER diagram and put it into the document.
|
Summarize the nature of the program
: Summarize the nature of the program. Explain how the agency implemented the program. Identify what need the program was intended to affect
|
|
Financial analysis-including ratio analysis
: Financial analysis-including ratio analysis to explain financial health/strength of the firms - Description of the business and analysis of its strategic position in the industry.
|
|
What a material weakness is in terms of sox compliance
: Describe the factors that made Trinity successful by illustrating the flow processes of the organization both in a narrative and process flowchart.
|
|
What is the interest cost for 2012 with respect to davenport
: Calculate pension expense for 2012 with respect to Davenport, assuming plan assets attributable to her of $150,000 and a rate of return (actual and expected) of 10%.
|
|
Develop an er model for the data management
: Develop an ER model for the data management of The Best Home. You will need to provide the ER model to cover the data and transactions of The Best Home.
|
|
What is the total interest expense over the life of the bond
: Prepare the adjusting journal entry on December 31, 2016, to accrue interest expense.
|
|
What is involved with acting as a fiduciary
: What basis of accounting is used to report governmental activities in government-wide financial statements? Can another basis be used? Please explain.
|
|
Identify three to five key skills or qualifications
: Reflect on your ideal position and list your career goals. Identify three to five key skills or qualifications that make you a strong candidate for this career. Discuss any remaining fears you may have about the resume writing process and or job-rela..
|
|
Identify the posterior distribution of given data
: Cancer deaths: Suppose for a set of counties i ∈ {1,..., n} we have information on the population size. Identify the posterior distribution of θ given data (Y1,.X1),...., (Yn, Xn) and a gamma(a, b) prior distribution.
|