User Account

All Pages

List the first and last name of all donors

Assignment Help Database Management System
Reference no: EM132175225

Question: Project: Database System for a Blood Bank Organization

Consider a database system for a Blood Bank Organization. The data requirements are summarized as follows:

1. Donors:

1. Donors are tracked by a unique donor ID.

2. Personal information includes first name, last name, phone number, Date of Birth and sex.

3. The combination of the Donor's first and last name must be unique.

4. Donor's sex 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.

2. Blood:

1. Blood is tracked by a unique ID.

2. BloodType is how the blood is categorized: (A+/A-, B+/B-, AB+/AB-, O+/O-, N/A).

3. N/A refers to blood that has not been processed yet.

4. Status refers to the state of the blood: (pure, N/A, impure).

5. N/A refers to blood that has not been processed yet.

6. Donor_id is a FK which references the ID of the Donor.

7. Blood specimens must have a donor.

8. Clinic_id is a FK which references the ID of the Clinic that stores the blood.

9. Blood specimens must be stored at one clinic.

10. DonateDate is the date the blood sample was received.

3. Clinic:

1. Clinics are tracked by unique clinic ID.

2. Each clinic has a name and location.

3. The combination of the clinic's name and location must be unique.

4. Employees:

1. Employees are tracked by unique Employee ID.

2. Clinic_id is a FK which references the Clinic ID which they work at.

3. Employees must work at a single Clinic.

4. Personal information includes Fname, Lname and sex.

5. The combination of an employee's first and last name must be unique.

Requirement: • Design & ER Model

• Normalize the Tables (in 3NF at least)

• Create the Normalized Tables and Populate them with at least 5 Rows

• Write the sample requested Queries & Execute themSQL Queries:

1. List the first and last name of all donors whose blood type is O+.

2. List names and location of clinics that store a blood of type B+.

3. Find the names of donors whose age is above 30 years and have donated since 1/1/2000.

4. List the names of employees who are working in clinics which do not have a blood of type A-.

Instructions: 1. Project must be containing the following:

a. ER Diagram.

b. All schemas before and after normalization.

c. All SQL statements of:

• creating tables

• inserting data in tables

• queries.

2. Screenshots from MySQL (or any other software you use) of all the tables after population and queries results.

3. 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.

4. You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.

5. The work should be your own, copying from students or other resources will result in ZERO marks.

Reference no: EM132175225

Questions Cloud

Evidence that employees are truly engaged : What might you see in an organization that provides evidence that employees are truly engaged?
What might you see in an organization that provides : What might you see in an organization that provides evidence that employees are truly engaged?
What changes do one foresee in business strategy : What changes do one foresee in business strategy as technology evolves in such a manner that it becomes both a part of corporate culture and consumer life?
Calculate the financial impact of increasing order fill rate : Develop a strategic profit model of both the old system and the modified system that reflects the suggested adjustments.
List the first and last name of all donors : List the first and last name of all donors whose blood type is O+. Find the names of donors whose age is above 30 years and have donated since 1/1/2000.
Calculate her total income tax liability : Aliza Grajek is a self-employed nurse with 2014 gross income of $68,000. Calculate her total 2014 income tax liability, including federal and Fica taxes
What is each machines EAC : You are evaluating two different cookie-baking ovens. If your discount rate is 11 percent, what is each machine's EAC
Speculate on the technological limitations regarding data : Using the organization you selected,B explain the key way(s) in which your organization / agency uses business intelligence in order to gain a competitive.
Define different conflicts in the given issue : A PowerPoint Presentation based on four different conflicts you have encountered in doing a project. These conflicts can be work related or personal conflicts.

Reviews

Write a Review

Database Management System Questions & Answers

  Describe the various integrative functions and processes

Describe the various integrative functions and processes

  Creating database

Question 1: Start Access. Open the downloaded Access file named exploring_acap_grader_h1_College. Question 2: Import the exploring_acap_grader_h1_Transfer.xlsx Excel workbook into a table named Transfer Schools. While importing the data, choose St..

  Prioritize your threats based on their risk value

Define who would be included in the assessment of the database environment - Identify the assets that you are protecting and define the threats you are protecting yourself against.

  Create a complete e-r diagram in crows foot notation

Design a database using the following information. Using Microsoft Visio 2013, create a complete E-R Diagram in Crow's Foot notation (including entity names, attributes, primary keys and foreign keys) that can be implemented, and then implement it..

  What is the best plan with nested loop joins only

Assuming relations have the same size and uniform distributions, what is the best plan with Nested Loop joins only? Write it as an algebra expression.

  Describe the objectives of the database environment

Describe the objectives of the database environment and Describe the problems and constraints

  Draw an initial entity-relationship model

Normalise the Project Allocation form (Fig 1) to arrive at third normal form entities. Show all the steps of normalisation clearly.

  Write and run SQL statements - What is the max balance

Task - Write and run SQL statements to complete the following tasks - Find the customers whose balance is greater than $300 but less than $400

  Describe sql injection and explain how it occurs

Describe SQL injection and explain how it occurs.Describe countermeasures that can be taken to secure Java, .Net, and PHP programs/scripts from SQL injection.

  Create relational schema of database in 3nf

A Relational schema of your database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys, candidate keys, and which attributes are nullable, giving reasons. List any assumptions you need to make.

  Vulnerability assessment matrix

Create a table of analysis based on the attributes below. Use RAND as a resource for referring to your readings. Name the attributes in one column (behavioral sensitivity). In the second column, identify possible indicators (behavior to be aware o..

  Explain the behavioral challenges in achieving efficiency

Describe the behavioral challenges in achieving efficiency. Who supports them and why?,What are their weaknesses and strengths? How do they interact with their families, their own people, and others?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd