Databases Management System-Design an Entity-Relationship Diagram For The Database of Blood Bank Organization.

This project is about designing a database system for a Blood Bank Organization. In this system, donors can donate blood many numbers of times. The donated bloods are stored at clinics at different locations. Each clinic is administered by a specific employee.

The data requirements are characterized as follows:

Don't use plagiarized sources. Get Your Custom Essay on
Databases Management System-Design an Entity-Relationship Diagram For The Database of Blood Bank Organization.
Just from $13/Page
Order Essay

 

 

  1. Donors:
  2. Donors are tracked by a unique donor ID.
  3. Personal information includes first name, last name, phone number, Date of Birth, and Gender.
  4. Donor’s Gender is not a mandatory field.
  5. Donors must be at least 17 years of age.
  6. Donors can donate at any clinic any number of times.
  7. Blood:
  8. Blood is tracked by a unique ID.
  9. BloodType is how the blood is categorized: (A+/A-, B+/B-, AB+/AB-, O+/O-, N/A).
  10. N/A refers to blood that has not been processed yet.
  11. Status refers to the state of the blood: (pure, N/A, impure).
  12. N/A refers to blood that has not been processed yet.
  13. Donor_id is a FK which references the ID of the Donor.
  14. Blood specimens must have a donor.
  15. Clinic_id is a FK which references the ID of the Clinic that stores the blood.
  16. Blood specimens must be stored at one clinic.
  17. DonateDate is the date the blood sample was received.

 

  1. Clinic:
  2. Clinics are tracked by unique clinic ID.
  3. Each clinic has a name and location.
  4. The combination of the clinic’s name and location must be unique.
  5. Employees:
  6. Employees are tracked by unique Employee ID.
  7. Clinic_id is a FK which references the Clinic ID which they work at.
  8. Employees must work at a single Clinic.
  9. Personal information includes Fname, Lname and sex.
  10. The combination of an employee’s first and last name must be unique.

Note: You can make any additional reasonable assumptions for any missing details for this system.

Project Additional instructions:

The Project is a group activity. Group Size = Min 2 and Max 3. Each group member must submit the project individually with all group member names mentioned in the cover page.

2.5 Marks

Learning Outcome(s):

LO 5

Develop a data model for a business application.

 

Question One

Design an Entity-Relationship diagram for the database of Blood Bank Organization.

 

2.5 Marks

Learning Outcome(s):

LO 4

Design a database for a business application

 

Question Two

Convert your ERD into relational schemas and then apply normalization rules (1NF, 2NF, 3NF, BCNF, and 4NF) against these relational schemas.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *