INFO6001: Logical Database Design- Database Management- Report Writing Assignment

Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Added on: 0000-00-00 00:00:00Order Code: Question Task Id: 0

MAS7282
Report Writing Assignment:

Task:

In this assignment, steps in the logical database design are conducted (as described below) as well revising  the  equirement analysis and conceptual design of assignment 1, and a report is written.

This assignment has 3 parts as specified below.

1. Revise requirements (data requirements, transaction requirements & business rules), EER diagram and Data Dictionary submitted for your Assignment 1 based on feedback provided.

2. Map the EER model to the relational model. Document the relational schema in DBDL (Sample format is given below)
ISBN (id, number, itemNo)
Primary Key id
Alternate Key number
Foreign Key itemNo references Book(itemNo)
ON UPDATE CASCADE, ON DELETE CASCADE

3. Normalize the schema to Boyce-Codd Normal Form (if any relation is not already in
BCNF). The final normalised schema must be documented in DBDL.

The final report should include the following

1. Requirement Specification (including data requirements, transaction requirements and business rules)
2. EER Diagram and Data Dictionary
3. Normalized Relational Schema in DBDL. Ensure that normalization steps are shown if any.

Uploaded By : jack
Posted on : March 29th, 2018
Downloads : 0

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services