Draw an appropriate er diagram

Assignment Help Computer Engineering

Reference no: EM132218480

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 appropriate 3NF 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 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 the unit text book

Some business rules or other aspects of the case study may not be clear to you when you read the case study.

If this is the case, then you should either approach your lecturer or tutor for clarification, or you may simply make an assumption and then develop your ERD
accordingly.

For example, the case study might not mention all relevant participation information (also called minimum cardinalities).

If so, you may make an assumption about what the minimum cardinalities might reasonably be, and then show them in your ERD accordingly. 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 is assumed that each customer must have at least one order because it is assumed that the business does not record customer details until the customer places 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, what information would you need to record aboutit?

How can it be identified? The answers to these questions will help you to develop your ERD.

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 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)

Attachment:- Case study.rar

Reference no: EM132218480

Questions Cloud

Calculate balances in each of the payroll liability accounts : On January 31, 2017, Sunland Company had the following payroll liability accounts in its ledger: Canada Pension Plan payable $7,550 Life insurance payable.

Prepare journal entries on petra books : Prepare Journal entries on Petra's books to account for the investment in Sitra for 2016. Directly compute the translation gain or loss.

Define what a good compliance culture : Define what a good compliance culture is and illustrate its links to ethics and integrity within a firm regulated in a sector of your choice

Design a brute-force algorithm for this problem : Consider the problem of counting, in a given text, the number of substrings that start with an A and end with a B.

Draw an appropriate er diagram : COIT20247: Create an Entity Relationship (ER) diagram relevant to the above case study and optionally perform logical design to produce appropriate 3NF.

Calculate the cost of abnormal spoilage in september : Lokal Food Manufacturer produces the "Fresh" brand of pasteurised coconut milk from one of its manufacturing processes.

Find the total interest charges : A person amortizes a loan of $17000 for a car with a 5 years loan at the rate of 6.5% compounded monthly. Find the total interest charges. The interest is $.

What agi would jack report under the given circumstances : Suppose that Jack also reported income of $13,100 from a half share of profits from a partnership. Disregard any potential self-employment taxes on this income.

Calculate the data rate required for robot to remote : MITS5003: Prime Living is a real estate company based in Victoria and you work form them as a consultant network engineer.

User Account

All Pages