Perform logical design, Develop a conceptual data model

Perform logical design

Reference no: EM132488900

Objectives

• To develop a conceptual data model diagram
• To perform logical design (optional)

Assignment Specification

In this assignment, youneed to perform the followingtasks for the given case study:
• Draw an Entity Relationship (ER) diagram
• Perform logical design(optional)
• Create3NF Relations(optional)

Case Study - CQ Air conditioning services

Assignment Requirements

In this assignment,you need to create an Entity Relationship (ER) diagram relevant to the above case study and optionally perform logical design to produce appropriate3NF Relations.
1 Draw an appropriate ER diagram
Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.
Your ERDmust
• show all necessary entities, attributes andrelationships
• show identifiers/identifying attributes as necessary
• show multi-valued attributes, ifany
• show participation andcardinality
• show associative entities, ifappropriate
• show weak entities, if any
• use the notation described in the settext
• use consistent and appropriate naming for entities and attributes as specified in the unit text book

Data dictionary
Provide the details of attributes for all the entities.You can use a suitable tabular format to provide these details. The details must include the following properties of attributes wherever appropriate:

• name
• size/length
• minimum andmaximum value and/or permitted value
• required/not required for a new instance
• brief notes that are relevant

Assumptions and Business rules
Provide assumptions and business rules relevant to your ERD.

Create Logical Design (Optional):
If you would like to perform this optional component of this assignment, you can map your Entity Relationship diagram (ERD) into relations and make sure that all the relations are in 3NF. Provide all the relationsin the following format:
Customer (CustomerId,CustomerName,Street,Suburb,State,PostCode,Email)

Invoice (InvoiceNumber,InvoiceDate, Total, CustomerId)

foreignkey(CustomerId)referencesCustomer(CustomerId)

Attachment:- ER diagram - conceptual data model diagram.rar

Reference no: EM132488900

Questions Cloud

Define advantages of using either an iaas or paas approach : The advantages and disadvantages of using either an IaaS or PaaS approach for the OSDS and The possible architecture(s) that could be used to deploy the OSDS.

Determine what is present value to be received at end : What is the present value of $31,600 due 15 periods from now, discounted at 6%? (Round answer to 2 decimal places, e.g. 25.25.)

What is the issue rule application and conclusion : What is the issue? rule? application and conclusion? which rule would be applicable to state what is right and what is wrong?

What is the scope of the topic and your research : Scope and value: What is the scope of the topic and your research? What value does it bring to your life? To your professional life?

Perform logical design : Develop a conceptual data model diagram and perform logical design - create an Entity Relationship (ER) diagram relevant to the above case study

What amount should lincoln company pay for the investment : What amount should Lincoln Company pay for this investment to earn an 11% return? (Round answer to 2 decimal places, e.g. 25.25.)

What were the cash proceeds received from the issuance : What were the cash proceeds received from the issuance of the note? Bentley Company issues a 10%, 6-year mortgage note on January 1, 2015

How many years must romeo wait to receive : How many years must Romeo wait to receive $85,000? (Hint: Use Table 3.) Romeo Cruz has been offered the opportunity of investing $49,086 now.

Discrimination under the the americans with disabilities act : Outline the prima facie case for discrimination under the the Americans with Disabilities Act (ADA), paralleled by section 504 of the Vocational Rehabilitations

User Account

All Pages