Prepare an entity relationship diagram (ERD) for your service

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Part-2 of Summative assessment Task-2:

Answer for all tasks of Part-2 should be put together in a single document including all necessary diagrams and figures. You also need to submit the original file for ER diagram with format of the design software.

You need to implement your design (i.e. creating all tables, loading all data, creating queries and all SQL operations) in Deakin Oracle DBMS for summative assessment task-2.

Tasks:

rh

1. Conceptual Design

A.

Answer the following tasks for your ER diagram required for your service. Identify the business rules for your service.

[15 Marks]

B.

Prepare an entity relationship diagram (ERD) for your service

[50 Marks]

C.

Provide a description for all entities, attributes and relationships used in your ERD.

[10 Marks]

Requirements for your ER diagram (ERD):

•

Mention all required entities and attributes.

You should have different types of entities including strong entities, weak entities, different types of relationships (strong, weak, M:N relationship) in your ERD. Include at least 6 entities (tables) to fulfil the requirements. You can have more entities if required.

• Mention all connectivity and cardinalities for relationships.

· Use professional database design and modeling software (e.g., MS Office Visio, LucidChart) to draw the ER diagram. Crow's Foot notation is preferable.

•

You must copy the ER diagram in your answer document.

2. Logical design:

A. Map all different types of entities and relationships, provide definitions of entities and relationships. [30 Marks] B. Provide a data dictionary for all of your tables which should have table name, attribute name, content (description of attribute), data type, format, value range, mandatory/optional attributes, primary/foreign key and foreign key referenced table. [15 Marks]

Hints: A sample data dictionary has been presented in Week-5 Lecture slide (28)

3. Normalization [20 Marks]

Explain partial and transitive dependencies. Prepare a dependency diagram which has partial and transitive dependencies (similar to the following figure) using an example table definition from your design (Task-2 Logical design above), If required you can add additional attributes for the table in the dependency diagram. Normalize the table from your initial dependency diagram into more tables which should be in third normal form (3NF), show the dependency diagram for each table of 3NF. Briefly explain your normalization process. (An example

dependency diagram is given below from the text book, chapter-6, please see Hints for more details.)

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of