Draw an appropriate ER diagram

Assignment Help Database Management System

Reference no: EM133038877

Objectives

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

Case Study - CQ Specialty Centre

Assignment Specification

In this assignment, you need to perform the following tasks for the given case study:

Draw an Entity Relationship (ER) diagram
Perform logical design (optional)
Create 3NF Relations (optional)

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

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.

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 unit textbook
use consistent and appropriate naming for entities and attributes as specified in the unit textbook.

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: it is assumed that a surgeon might not have any lease so far, because it is assumed that the business records potential surgeons' details for future leases. 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 about it? How can it be identified? The answers to these questions will help you to develop your ERD.

2. 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 and maximum value and/or permitted value
required/not required for a new instance
brief notes that are relevant.

3. Assumptions and Business rules

Provide assumptions and business rules that are relevant to your ERD.

4. 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:
Customer (CustomerId, CustomerName, Street, Suburb, State, PostCode, Email)

Invoice (InvoiceNumber, InvoiceDate, Total, CustomerId)

foreign key (CustomerId) references Customer (CustomerId)

Attachment:- Perform logical design.rar

Reference no: EM133038877

Questions Cloud

Hypothetical description of the breach : Risk Scenario: A public company has a financial loss risk due to a recent network breach. Provide me with a hypothetical description of the breach, the type of

Different versions of single operating system : There are many operating systems that are used to run networks. Name at least three of them, but do not include different versions of a single operating system.

What the amount of bad debts expense for the year : If the estimate of uncollectible is made by taking 10% of gross accounts receivable, what the amount of bad debts expense for the year

Case-cash flows at east coast yachts : Because of the dramatic growth at East Coast Yachts, Larissa decided that the company should be reorganized as a corporation.

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

What the cost of the factory equipment purchased on December : The depreciation applicable to this equipment was 42,000. What the cost of the factory equipment purchased on December 30, 2010

Optimize operation processes and supply chains : Many firms use algorithms to help make management group's decisions and optimize operation processes and supply chains.

What is the effective interest rate : A major daily newspaper charges $410 (paid in advance) for an annual subscription, or $42 per month payable. What is the effective interest rate

Primary activities of the design phase of sdlc : Describe the primary activities of the design phase of the SDLC.

User Account

All Pages