preview

Outline Of A Business Rules

Decent Essays

PART A 1. Business rules: 1. ABS has donation centers in all major cities and each capital city throughout Australia. 2. Details of each donor must be recorded by the ABS staff It is the responsibility of each ABS staff to record all the details of donors 3. Each ABS staff member will have unique id, first name, last name. This represents that particular person is an ABS staff member 4. Each donor will have unique id, first name, last name, gender, date of birth, address, phone number. This states that, the person who is going to donate blood should submit his/her whole details. 5. Each donor must specify his/her medical conditions. Medical conditions means whether he/she is perfectly alright or suffering from any disease. 6. Each donor …show more content…

12. ABS staff must decide which donation must be taken. This is to make sure that donor is healthy and not effected by any disease. 13. Staff member must record the details of donor and details of the patient. This is to check that donor’s group is matching to patient’s group or not. 14. Staff member must state which staff member taking the donation and ABS donation centre. 15. ABS staff needs to know the blood group of the donor, age , date and time of the donation. 2. 3. 4. 5. a) b) PART B Creating an RDM Identifying the Attributes and creating RDM for each table For ABS_STAFF Table ABS_STAFF (staff_id, staff_name, staff_title, staff_gender, address_id, centre_id) Primary key (staff_id) Foreign key address_id references ADDRESS table Foreign key centre_id references ABS_CENTRE table For ABS_CENTRE Table ABS_CENTRE (centre_id, centre_name, no_of_staff, address_id) Primary key (centre_id) Foreign key address_id references ADDRESS table For ADDRESS Table ADDRESS (address_id, street_num, street_name, phone_num, state_name, capital, pin_code) Primary key (address_id) For ABS_QUALIFICATION Table ABS_QUALIFICATION (qual_id, qual_name, qual_type) Primary key (qual_id) For STAFF_QUALIFICATION Table STAFF_QUALIFICATION (staff_qual_id, qual_id, staff_id) Primary key (staff_qual_id) Foreign key qual_id

Get Access