Question: I need the answer as soon as possible Q10 The following is the work process of a bank. Bank Kijang is an investment bank that

I need the answer as soon as possible I need the answer as soon as possible Q10 The following is

Q10 The following is the work process of a bank. Bank Kijang is an investment bank that invests heavily in the construction and transportation sectors. It has multiple branches across Malaysia and wishes to build a new staff management system in preparation for their expansion to other Asia-Pacific countries. Each of the bank's branch has a unique branch number and a branch name. A branch has many staff, and a staff works at only one branch. Each staff has a unique staff number which was assigned to them upon joining the bank. The bank records the staff's name, address and phone number. The address consists of the house number, street, postcode and country. Some staff have multiple phone numbers, and a phone number belongs to only one staff A staff performs more than one task, and each task can be performed by many staff. Information about the task code, task category and task details, are kept for each task. A staff is either a permanent staff or a contract staff. Contract staff are hired for a specific service duration. Their service duration and pay rate are recorded by the bank. The bank also records the basic salary and allowance of all permanent staff. Each staff can support many dependents (close family members), and each dependent is supported by only one staff. Each dependent is assigned a dependent number, and the bank records the dependent's name, date of birth and relationship to staff Illustrate an entity relationship diagram (ERD), complete with all the necessary entities, relationships, attributes, primary and foreign keys, cardinalities, and other relevant elements. (28 marks) Q10 The following is the work process of a bank. Bank Kijang is an investment bank that invests heavily in the construction and transportation sectors. It has multiple branches across Malaysia and wishes to build a new staff management system in preparation for their expansion to other Asia-Pacific countries. Each of the bank's branch has a unique branch number and a branch name. A branch has many staff, and a staff works at only one branch. Each staff has a unique staff number which was assigned to them upon joining the bank. The bank records the staff's name, address and phone number. The address consists of the house number, street, postcode and country. Some staff have multiple phone numbers, and a phone number belongs to only one staff A staff performs more than one task, and each task can be performed by many staff. Information about the task code, task category and task details, are kept for each task. A staff is either a permanent staff or a contract staff. Contract staff are hired for a specific service duration. Their service duration and pay rate are recorded by the bank. The bank also records the basic salary and allowance of all permanent staff. Each staff can support many dependents (close family members), and each dependent is supported by only one staff. Each dependent is assigned a dependent number, and the bank records the dependent's name, date of birth and relationship to staff Illustrate an entity relationship diagram (ERD), complete with all the necessary entities, relationships, attributes, primary and foreign keys, cardinalities, and other relevant elements. (28 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!