ICTSAD501: Melbourne Realty - Model Data Objects - Develop a Data Model - Engineering Assignment Help

Assignment Task :

Assessment Task 1: Develop a data model

Scenario: Melbourne Realty 

You are working as an IT specialist for a real estate agency called Melbourne Realty. The company would like to develop a website to display rental properties and properties for sale to their customers. You are required to create an entity relationship diagram for the website development team using the business and data requirements below. 

1. The website should support property search, where a visitor can search the current properties available. 

2. The details of a property for sale are: street number, street name, suburb, postcode, city, state, sale price, type of property, number of bedrooms, number of bathrooms, number of garages, staff selling the property, staff mobile number, property inspection dates

3. The details of a property for rent are: street number, street name, postcode, city, state, rental  price per week, type of property, number of bedrooms, number of bathrooms, number of garages and the date from which the property is available for rent, property inspection dates.

4. The new website can provide email notification to customers when certain properties are available. The website matches customer's preferences with properties available. If there is a match, then an email alert is sent to the customer. 

5. A customer must sign up as a member of Melbourne Realty. The customer details required are: first name, last name, mobile number and email address.

6. The details of customer housing preferences are also recorded. These details are: Type of property (house, unit or apartment), rent or buy, maximum price, and postal codes that interest the customer.

7. The email alert contains the customer details: first name, last name, mobile number, email address, and the property details and the price of property (rental price or sale price).

 
Part A - Develop conceptual model and logical data model

1. Read the scenario and business data requirements provided by the assessor.

2. Arrange a time to discuss the with your assessor (the client)
• Ask probing questions to determine the business rules
• Determine the client’s expectations
• Determine the scope of the data model

3. Develop an Entity Relationship diagram (conceptual model) that reflects the information obtained from client, ensuring it:
• reflects a top-down approach
• identifies and outlines entity types
• includes attributes and primary key for each entity set
• identifies and outlines relationships between entities
 

This  Engineering Assignment has been solved by our  Engineering Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.