CSIT115/CSIT815 - Data Management & Security Laboratory - IT Assignment Help

Download Solution Order New Solution
Assignment Task

 


Task 1 
1-An objective of this task is to describe a sample database domain represented by a given  conceptual schema. 
Analyse the following conceptual schema. 

Analyse the following conceptual schema.

 

2-Write a natural language specification of a database domain (like for example,  the specification written by your lecturer in the tasks 2) such that it contains all  information included in a conceptual schema given above.

Task 2 

  • An objective of this task is to create a conceptual schema of a given sample database  domain. 
  • The owners of real estate properties offer for sale two types of properties: standing alone  houses and empty blocks of land. Both types of real estate properties are described by a  unique full address that consists of city, street, house number or lot number. The standing  alone houses are additionally described by the total number of bedrooms. The blocks of  land are described by the total area. 
  • The real estate properties are owned by the owners. An owner is described by the first  name, last name and phone number. The owners are uniquely identified by a mobile  phone number. The owners determine the "asked prices" of the properties offered for  sale. 
  • The potential buyers express their interests in buying the properties offered for sale. The  buyers may express their interests in one or more real estate properties offered for sale.  The buyers are described by the first name, last name and mobile phone number. The  buyers are uniquely identified by a mobile phone number. Additionally, the buyers  provide information about minimal and maximal price they are willing to pay for each  one of the real estate properties they are interested in. 
  • The real estate agency employs the real estate agents that communicate with the owners  and buyers. A real estate agent is assigned to a number of owners and buyers. A real  estate agent is described by a unique employee number, unique mobile phone number,  first name, and last name.  
  • Your task is to create a conceptual schema of the sample database domain given above  and to draw such schema in a notation of UML simplified classes of objects explained to  you during the lecture classes in CSIT115. No other notation will be accepted ! 
  • To create a conceptual schema, use a methodology explained to you in a presentation 04  Conceptual Modeling. First, read through the specification listed above and find all  classes of objects. Next, read through the specification again and find all attributes. Next,  read through the specification again and find all associations, link attributes, and  association classes. Next, read through the specification again and find identifiers and  qualifications. Finally, read through the specification and find generalizations. Entire  process described above must be included in the outcomes from the implementation of  this task. 
  • To create the fragments of conceptual schema obtained after each iteration use a diagram  drawing tool UMLet.  

 


This CSIT115/CSIT815 - IT Assignment has been solved by our IT 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.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.