Create an erd that meets the requirements of the abs

Assignment Help Business Management
Reference no: EM13338846

Create an ERD from a business problem.

The ABS Blood Bank

Australian Blood Services (ABS) is a new Non-Government Organisation (NGO) that has just been set up to collect blood and blood product donations from the public. ABS plans to have donation centres in each capital city and most major regional cities throughout Australia. You have been approached by ABS to design and create a database system to track these blood donations.

ABS needs to record the details of each donor. This needs to include the donors full name and address details, along with their contact details, gender, Medicare number and any other details that may be pertinent.

ABS also needs to know about the medical condition of each donor or prospective donor. This includes the details of any surgery, existing medical conditions and any medication that is being taken.

ABS also needs to know if the donor has been overseas in the last three months, which countries that they visited, how long they stayed in each county, whether they contracted any disease while in the country.

Based on the answers to these questions, the ABS staff will decide if it is safe to accept a blood donation from the prospective donor. This is a decision can be made only by an ABS staff member who is a qualified Registered Nurse.

Once the ABS staff member has decided to accept a blood donation from the donor, it is necessary to record the donor details, staff member taking the donation, ABS donation centre, and any other pertinent details in order to clearly identify each individual blood donation.

Tasks:

List all the business rules for the ABS.

Create an ERD that meets the requirements of the ABS. The ERD should show:

All entities with primary key and any foreign key attributes,

The relationships between entities,

The cardinality and optionality of each relationship.

Reference no: EM13338846

Questions Cloud

Find the surface charge charge density on plane : A +44 nC charge is placed on the z- axis at (0,0,5 cm). A grounded conducting plane fills the x-y plane where z=0. A) Find the surface charge charge density on the conducting plane at the origin.
Compute the magnetic flux through each turn : A 44.5 mA current is carried by a uniformly wound air-core solenoid with 435 turns, a 20.0 mm diameter, and 14.5 cm length. Compute the magnetic flux through each turn
How can p2p file-sharing networks make money : What social issues are raised by P2P file-sharing protocols and programs such as BitTorrent? Is the record industry justified in attempting to shut them down? Why or why not?
Find the elecric field intensity vector at the origin : A +10 nC charge is placed on the x-axis at x= -6cm. A +8 nC charge is placed 14cm away on the x-axis at x= +8 cm. A) find the potential at the origin
Create an erd that meets the requirements of the abs : Once the ABS staff member has decided to accept a blood donation from the donor, it is necessary to record the donor details, staff member taking the donation, ABS donation centre, and any other pertinent details in order to clearly identify each ..
By how much will its altitude decrease : A spacecraft is in circular Earth orbit at 6000 altitude. By how much will its altitude decrease if it moves to a new circular orbit where its orbital period is 5% lower
Calculate the weight of an object : If the planet has a radius of 6 ×103 km, calculate the weight of an object with m=30.0 kg sitting on the surface of the planet
Evaluate suitability of firms current business strategy : Evaluate the suitability of the firms current business strategy based on the outcomes of your analysis and identify and discuss strategy the firm implements by examining its strategy statement and/or its value chain activities.
Marketing has often been defined in terms of satisfying : Marketing has often been defined in terms of satisfying customers

Reviews

Write a Review

 

Business Management Questions & Answers

  Explain what this all inclusive web site on all labor laws

Explain what this all inclusive web site on all labor laws and procedures contains and then select one subject or area of information that you learned from this great web site

  Plans impacting organizational change

explain how you avoid failure, and repair or rebuild communication channels to facilitate change in a similar situation.

  One source of new product thoughts is competitors

One source of new product thoughts is competitors. Steven Fischer freshly joined Frankie as well as Alex Specialty Products as a brand manager

  Business management - analysis

Do you think communication within an office setting should be considered private and confidential and Please explain why or why not?

  Do you think this music should occur prior to the product

Do you think this music should occur prior to the product claims, after the product claims, or does it matter where it occurs during the commercial? Discuss your rationale.

  What they don''t know wont hurt them

Is it ethical for the doctor to allow the vet students to perform the autopsy and should the fact that the owner would never know if the autopsy was performed affect the doctor's decision?

  Describe the benefits of the project

Describe the benefits of the project which include tangible and intangible benefits. Completely justify a recommendation with a compelling proposal that aligns to the business goals.

  Explain the difference between extrinsic and intrinsic

Explain the difference between extrinsic and intrinsic motivation and Describe school and work experiences in which you have experienced each type of motivation.

  Business help - corporate governance

The emergence of an active board of directors in the last 5-10 years been a benefit or hindrance to proper corporate governance?

  Challenges of the process of change

Identify and describe a current situation, within your current or former organization, where the challenges of the process of change

  What is general concept of fresh start in bankruptcy

hat is general concept of fresh start in bankruptcy. Do RAs opposed to unionization have legitimate concerns. How could unionization change culture of Residence Life

  Explain how are sweatshops affecting the global economy

How common is sweatshops labor and how are sweatshops affecting the global economy. Based information using the resource and institution based view.

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!

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