User Account

All Pages

Draw an entity relationship diagram

Assignment Help Database Management System
Reference no: EM132280087

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)

Please note that the above mentioned optional components,logical design and 3NF relations, will not be marked, however those tasks are expected to enrich your skills in the creation of database in future.

Case Study
CQParcels (CQPS) is well known for its parcel handling business in Australia. It collectsthe parcels from its customers and then transports and delivers them to the respective specified delivery addresses in Australia.

When anew customer(sender of the parcels)requestsfor parcel deliveries, CQPS collectsmany details that are related to them. Among the many information that is required to be collected at that time, the contact phone and email details of the customerare considered to be vital.

Whenever a customer requests a parcel delivery, the parcel-delivery information such as the delivery address and receiver details are collected. Subsequently, one of CQPS employees collects the parcel from the sender, verifies whether the address for delivery is mentioned on the parcel, and then creates an invoice for the charges related to its delivery.

For each parcel-delivery, CQPS also maintains the details of the employee involved, the date and time of collection/pick up and delivery. Though most of the parcels are delivered to the specified addressees, some of them occasionally are not deliverable due to incorrect/incomplete delivery address. Such parcels are returned to the senders.

When an undelivered parcelis not returned to the sender/customer within a month of collection, then the customer can lodge a compensation claim to CQPS. The compensation claims are verified and settled by CQPS based on their records.

Assignment Requirements

In this assignment,you need to create an Entity Relationship (ER) diagram relevant to the above case study and optionallyperform logical design to produce appropriate3NF Relations.

The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.

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

2 Assumptions and Business rules
Provide 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 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)

Verified Expert

This assignment is to create an ER diagram for the given case study of a parcel delivery company. The solution also the business rules which are assumpted as per the specification given in the case study. The logical design of the 3NF relation (although its optional) have been designed .

Reference no: EM132280087

Questions Cloud

Should the marijuana justice act of 2019 be adopted : Considering what you read about federalism in Chapter 3, and the above article, what do you think? Should the Marijuana Justice Act of 2019 be adopted? Why or w
How to apply risk planning for the organizations project : Explain how to apply risk planning for the organizations project.
Was the supreme court correct in making this decision : How do you think that this Supreme Court decision will affect political campaigns?
What extent does it have on the political lean of the court : What extent does it have on the political lean of the Court, and therefore, on United States law (specifically civil rights and civil liberties)?
Draw an entity relationship diagram : Draw an Entity Relationship (ER) diagram - develop a conceptual data model diagram - erform logical design (optional) - Perform logical design(optional)
Process have to be considered flexible : Project Management: what additional project planning criteria should a process have to be considered flexible?
Describe the policy health issue with example : Write a 750-1,000-word policy brief that summarizes the issue, explains the effect on the population, and proposes a solution to the issue.
Write a paper on a topic related to american government : You are the Special Assistant to the President of the United States (POTUS). He has asked you to write a briefing paper on a topic related to American Governmen
Identify elements of an organizational culture : In this assignment, you will write a short (1-2 page), opinion paper. The paper is informal in that it is based on your own experiences and opinions.

Reviews

len2280087

4/11/2019 1:48:35 AM

Word doesn't matter because task is important . Draw an Entity Relationship (ER) diagram . Perform logical design (optional) . Create 3NF Relations (optional) It is dependent on case study and then check all of three assignment requirement and concentrate on notes

len2280087

4/11/2019 1:48:10 AM

Marking Criteria:   Item Maximum Marks 1 Identified entities (including super type and sub type entities), associative entities, weak entities (if any) and named appropriately 6 2 Provided appropriate attributes 6 3 Provided identifiers/identifying attributes 3 4 Drawn correct relationships between entities and named them appropriately 5 5 Used proper symbols for ? entities including super type and sub type; associative entities; weak entities if any ? relationships ? identifying attributes ? min and max cardinalities for the relationships 6 6 Provided appropriate justification for assumptions and business rules 4   Penalty due to plagiarism/copying     Late Penalty: Less 5% of available marks per calendar day     Total 30

len2280087

4/11/2019 1:47:56 AM

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 receive zero marks. • You must state in your assignment (at the end under the heading Acknowledgements is a good place) all materials and sources you used.Before submitting your assignment, review the marking criteria that are available in the assignment specification. Ensure that all the criteria are addressed in your submission. • 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 university policies.

len2280087

4/11/2019 1:46:19 AM

The attributes of the possible entities have not been mentioned clearly. Hence, you need to assume at least two relevant attributes for each of the entities that you will identify for your ER diagram. The delivery charge for a parcel need not be assumed as calculated value (i.e., it can be assumed to be a stored attribute). You must make an electronic submission for this assignment using the appropriate assignment submission link in the unit web site. You should submit a Microsoft Word documentcontaining: • A copy of your ERD. • A list of business rules and assumptions including theirjustifications. • 3NF Relations – optional Yourdocumentshouldcontainappropriateidentifyinginformation(yourstudentnumber,name,unit number, etc.) and should contain appropriate headings for eachsection.

Write a Review

Database Management System Questions & Answers

  Create the rdm with appropriate attributes

Details about each payment relating to a service, amount of payment and date need to be recorded - Create the RDM with appropriate attributes, primary and foreign keys, based on all the entities.

  Assume that the database system in your organization has

write a 200- to 300-word short-answer response for the followingsuppose that the database system within your

  Transform the 3nf lists into a set of database tables

Normalise the list using the Normal Forms technique. You should explain any changes you are making at each step of the Normal Forms process.

  Dsign document 1write a four to sixnbsp page design

this assignment consists of two sections a design document and a revised project plan. you must submit both sections

  What is it about the given open source databases

What is it about these open source databases that results in these security breaches? What might be an even better longer term solution?

  Explain new objects based on extending other objects

One of the new classes must be based on a reference extending an existing class from package task02 directly(similar to how Customer extends Person in the sample code).Do not repeat that package task02 class in the task03 package.

  Creating erd containing order and customer entity

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

  Create the preliminary database tables

Use a Microsoft Access database to create the preliminary database tables, columns with data types, primary keys, and relationships

  Explain the risks and rewards of such of a move

Your firm wants to move from a relational database model to the REA data model. Explain to your senior management the risks and rewards of such of a move. Be sure to provide specific examples to support your response.

  Describe the importance of using sub queries in a database

Describe the importance of using sub queries in a database system

  Design entity-relationship model of the problem

You are required to design using an E-R diagram an entity-relationship model of the problem, convert the model into a relational model, and assess the normal form of each schema.

  Create data warehouse for electronics store chain

Create a data warehouse for electronics store chain. Chain has 20 stores in 5 cities. Each store has different sections comprising computers, DVDs, TVs, audio, home appliances etc.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd