INFO6001 Database Management 1 - Assignment 2

Get Expert's Help on Assessment Writing

Assignment 2: Supertaste Pizza Project - Logical Database Design

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

This assignment has 3 parts as specified below.
1. Revise requirements and EER diagram in Assignment 1, based on:

  1. Either the EER Model submitted for your Assignment 1. Revise it based on feedback provided by your marker, or
  2. Or, complete the partial EER model given at the end of this file, to meet the system requirements.

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.

Get Your Customize Task on any subject starting 10$/Page

Expert's Answer

Your future, our responsibilty submit your task on time.

Order Now

 

Need Urgent Academic Assistance?

Get Professional Help at Low Prices!

*
*
*


*

 

 

Plagiarism Checker

Submit your documents and get Plagiarism report
Check Plagiarism

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

TOP
Order Notification

[variable_1] from [variable_2] has just ordered [variable_3] Assignment [amount] minutes ago.