Database System for a Blood Bank Organization

Database System for a Blood Bank Organization

  1. In this file, you will find a list of database project ideas. You must choose one of them to design and implement.
  2. This project worth 10 marks, will be distributed as in the following:
    1. Design the database, following an ER model
    2. Normalize the tables (each table should be in 3NF at least)
    3. Use MySQL or any other database to create the normalized tables and

                    populate your tables with at least 5 rows.

  1. Execute the sample requested queries.

 

Containing the following:

  1. ER Diagram.
  2. All schemas before and after normalization.
  3. All SQL statements of:
    • creating tables
    • inserting data in tables

 

  1. Screenshots from MySQL (or any other software you use) of all the tables after population and queries results.
  2. You are advised to make your work clear and well-presented, marks may be reduced for poor presentation. This includes filling your information on the cover page.
  3. You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.

 

 

Do you need an Original High Quality Academic Custom Essay?