Develop a conceptual data model diagram – Best Writing Service

Assessment item 1—Assignment 1 (COIT20247 T2 2019)Due date: Friday of Week 5 (11:45 pm AEST, August 16, 2019)Weighting: 30%Length: N/AObjectives To a data  To perform logical design (optional)Assignment SpecificationIn this assignment, you need to perform the following tasks for the given case study: Draw an Entity Relationship (ER)  Perform logical design (optional) Create 3NF Relations (optional)Case Study: CQUnited Property Management database systemCQUnited Property Management (CQUPM) is an Australian‐owned business located in a large city thatspecializes in management of rental property and relevant services. The management of CQUPM hasapproached you to build a relational database that will be used as the most critical backend softwarecomponent in their enterprise management system so that the relevant business data will be recordedappropriately and further information query will be processed efficiently. The proposed databasesystem requires efficiently to record and track all listed properties, customers, staff and relevant rentalactivities. Consider the following user requirements carefully and design a database conceptualschema (i.e. E‐R ) to support such an application.The major business of CQUPM is to manage the property rentals, where the property managers acceptentrusted rental management of the real estate from property owners. The property could be a houseor an apartment. Each property should be described and recorded with the information including theproperty type, address, the number of bedrooms, the number of bathrooms, the listed weekly rental,property photo, as well as the available date. When a customer wishes to rent a property, he/she isrequired to make an application, which will be processed by a property manager. If an application isapproved, the contract start date, end date, and weekly rental etc. must be recorded in the system.Usually, a property is managed by one property manager while a manager could take care of multiplelisted properties. A property manager also can supervise other managers. From time to time, theproperties under management may need some maintenance or minor repair jobs (for examplewindow glass broken and replacement, electrical fault, water pipe leaking etc.). The company hascontracted the maintenance tasks to the qualified external employee, who will undertake the repairjobs as requested. The external employee could be a licensed electrician, plumber or handyman. Thedetails of the repair job and complete date must be entered the system.The people that the system needs to record include the property managers of CQUPM, the owners ofthe property, the customers and the contracted external employees. Their names, addresses, andcontact phones are essential data in the database system. In addition, you should consider one or twoextra attribute(s) to describe the property manager and the external employee.The specification of above application scenario may be not presented explicitly with every detail onthe entities or relationships in the required E‐R model, because one of your tasks for this assignmentis to analyze the requirement of users, identify necessary entities and relationships, and build the E‐Rdata model for the case study. You may need to do some research on the data and possible model ingeneral property management with complete attributes or under some assumptions, which shouldmake sense for such an application scenario.Assignment RequirementsIn this assignment, you need to create an Entity Relationship (ER) diagram relevant to theabove case study and optionally perform logical design to produce appropriate 3NFRelations.The attributes for various entities have not been purposely described in the case study sothat the students are encouraged to further research and list the pertinent attributes inaddition to the required identifier for each and every entity in their ERD.1 Draw an appropriate ER diagramUse the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for theabove case study.Your ERD must• show all necessary entities, attributes and relationships• show identifiers/identifying attributes as necessary• show multi-valued attributes, if any• show participation and cardinality• show associative entities, if appropriate• show weak entities, if any• use the notation described in the set text• use consistent and appropriate naming for entities and attributes as specified in theunit text bookSome business rules or other aspects of the case study may not be clear to you when youread the case study. If this is the case, then you should either approach your lecturer ortutor for clarification, or you may simply make an assumption and then your ERDaccordingly. For example, the case study might not mention all relevant participationinformation (also called minimum cardinalities). If so, you may make an assumption aboutwhat the minimum cardinalities might reasonably be, and then show them in your ERDaccordingly. You should justify each assumption in terms of the business, for example:in the case study regarding the E-R model for customers placing an order it isassumed that each customer must have at least one order because it isassumed that the business does not record customer details until the customerplaces an order. To get yourself started, ask yourself, ‘If I were running this business,what things I need to keep a list of?’ Write those things down. For each thing, whatinformation would you need to record about it? How can it be identified? The answers to thesequestions will help you to your ERD.2 Assumptions and Business rulesProvide assumptions and business rules relevant to your ERD.3 Create Logical Design (Optional):If you would like to perform this optional component of this assignment, you can map yourEntity Relationship diagram (ERD) into relations and make sure that all the relations are in3NF. Provide all the relations in the following format (for example):Customer (CustomerId, CustomerName, Street, Suburb, State, PostCode, Email)Invoice (InvoiceNumber, InvoiceDate, Total, CustomerId)foreign key (CustomerId) references Customer(CustomerId)How and what to submit:You must make an electronic submission for this assignment using the appropriateassignment submission link in the unit web site.You should submit a Microsoft Word document containing:• A copy of your ERD.• A list of business rules and assumptions including their justifications.• 3NF Relations – optional.Your document should contain appropriate identifying information (your student number,name, unit number, etc.) and should contain appropriate headings for each section. Note:We recommend you to use Microsoft Visio to draw the E-R diagram and then copy & pasteit to the Word document.Important points• You must work individually on this assignment.• The model solution to this assignment will be released approximately TWO (2)weeks after the due date.• Assignments that are submitted after the release of the model solution will receivezero marks.• You must state in your assignment (at the end under the headingAcknowledgements is a good place) all materials and sources you used. This maybe as simple as ‘This assignment was completed using only the COIT20247 unitmaterials’ to mention that you have used only the items provided by the unitCOIT20247.• Before submitting your assignment, review the marking criteria that are availablein the assignment specification. Ensure that all the criteria are addressed in yoursubmission.• After submitting your assignment, please verify that your submission was successful,i.e. download your submitted files to ensure that they are correct.• Penalty related to late submission and plagiarism is handled as per the universitypolicies.Marking Criteria:Item Maximum Marks1Identified entities (including super type and subtype entities), associative entities, weak entities (ifany) and named appropriately62 Provided appropriate attributes 53 Provided identifiers/identifying attributes 34Drawn correct relationships between entities andnamed them appropriately 65Used proper symbols for entities including super type and sub type;associative entities; weak entities if any relationships identifying attributes min and max cardinalities for therelationships6.56Provided appropriate justification for assumptionsand business rules 3.5Penalty due to plagiarism/copyingLate Penalty: Less 5% of available marks percalendar dayTotal 30
Australian Expert Writers

Assignment status: Already Solved By Our Experts

(USA, AUS, UK & CA  PhD. Writers)