Your task is to analyse a scenario, and design, develop and test a database in MySQL using…

/in /by

Your task is to analyse a scenario, and design, develop and test a database in MySQL using

PhpMyAdmin. You are provided with the scenario and supporting documents. The intent of this

assignment is to give you experience in design and development. It is based on a fictitious

scenario.

It is your job to analyse the data requirements provided in the scenario and design and develop

a relational database to meet the client needs. You will also need to add data and create SQL

queries to provide results suitable for reporting. Your focus will be to:

• Produce a fully normalised database design, modelled in an EERD, showing business rules;

• Develop entities (tables) with correct attributes included;

• Demonstrate supertypes and their associated subtypes;

• Demonstrate normalised relations;

• Make relational joins to ensure this prototype works;

• Produce evidence of correct working via database queries and screenshots of result sets.

Attachments:

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.