You are required to develop a database application for managing blood donations. The following are the...

Transcribed Image Text:

You are required to develop a database application for managing blood donations. The following are the requirements of the database application. Read the requirements and submit the conceptual and logical designs as the Phase 1 of the project. Phase 2 is implementation of the Phase 1 outcomes as a software application. A blood donation management system is an important tool used by hospitals, clinics, and blood banks to keep track of inventory levels, donor records, recipient records and other relevant information. This system would require administrators to efficiently manage collecting, storing, and distributing blood products. The compatibility chart for blood types is as follows: ● ● . . ● . ● ● High-Level Requirements RECIPIENT BLOOD TYPES Your system would implement the following: Store recipient and donor information with sufficient details such as name, address, contact number, email, etc. > Weigh at least 114 lbs . AB+O AB- A+ . B- Be free of major diseases o Page 2: 0+ . 0- Describe constraints, including business related, e.g., One person can donate no more than two times a year; and technical constraints, such as primary keys, foreign keys, check constraints, and not null constraints, for the tables and attributes, etc. O Page 3: Eligibility for donation is necessary as per the following rules: Should be at least 17 years old O .00000000 o Page 4: . 0+ Maintain information of blood types with sufficient details as outlined in the figure above Your system should store sufficient data for the following requirements: O keep track of donors' and recipient medical history; o schedule blood collection drives every three months; . . ● Phase 1: • Draw a conceptual EER and a logical Relational schema diagram of your design. Due: Sunday, October 29, 2023. DONOR BLOOD TYPES ▪ Group number 00 000 O monitor expiration dates of stored blood; o keep track of any incidents that may occur due to failure of the process; and O produce reports on usage trends. 00 OO Use draw.io, Visio or ERDPlus or any other tool to draw the conceptual diagram. Hand-drawn diagram will not be accepted. O Pagel: A cover page which contains B+ A- A+ AB- AB+ ● O O Submit one pdf file called P1-Group-xx.pdf (where xx is your group number), which contains the following four pages: 0000 O Project title, phase number, and date. Group members IDs and names ▪ Your logical diagram (Relational Schema) Your conceptual diagram (EER Model) State clearly any assumptions that you added to the above requirements. List clearly the semantic requirements that cannot be captured in your EER model. State the contribution of each group member. You are required to develop a database application for managing blood donations. The following are the requirements of the database application. Read the requirements and submit the conceptual and logical designs as the Phase 1 of the project. Phase 2 is implementation of the Phase 1 outcomes as a software application. A blood donation management system is an important tool used by hospitals, clinics, and blood banks to keep track of inventory levels, donor records, recipient records and other relevant information. This system would require administrators to efficiently manage collecting, storing, and distributing blood products. The compatibility chart for blood types is as follows: ● ● . . ● . ● ● High-Level Requirements RECIPIENT BLOOD TYPES Your system would implement the following: Store recipient and donor information with sufficient details such as name, address, contact number, email, etc. > Weigh at least 114 lbs . AB+O AB- A+ . B- Be free of major diseases o Page 2: 0+ . 0- Describe constraints, including business related, e.g., One person can donate no more than two times a year; and technical constraints, such as primary keys, foreign keys, check constraints, and not null constraints, for the tables and attributes, etc. O Page 3: Eligibility for donation is necessary as per the following rules: Should be at least 17 years old O .00000000 o Page 4: . 0+ Maintain information of blood types with sufficient details as outlined in the figure above Your system should store sufficient data for the following requirements: O keep track of donors' and recipient medical history; o schedule blood collection drives every three months; . . ● Phase 1: • Draw a conceptual EER and a logical Relational schema diagram of your design. Due: Sunday, October 29, 2023. DONOR BLOOD TYPES ▪ Group number 00 000 O monitor expiration dates of stored blood; o keep track of any incidents that may occur due to failure of the process; and O produce reports on usage trends. 00 OO Use draw.io, Visio or ERDPlus or any other tool to draw the conceptual diagram. Hand-drawn diagram will not be accepted. O Pagel: A cover page which contains B+ A- A+ AB- AB+ ● O O Submit one pdf file called P1-Group-xx.pdf (where xx is your group number), which contains the following four pages: 0000 O Project title, phase number, and date. Group members IDs and names ▪ Your logical diagram (Relational Schema) Your conceptual diagram (EER Model) State clearly any assumptions that you added to the above requirements. List clearly the semantic requirements that cannot be captured in your EER model. State the contribution of each group member.

Answer rating: 100% (QA)

According to the given information Highlevel requirements are considered Objective To create a database application for the management of blood donati... View the full answer