Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

New Horizon Bank would like to build a database to maintain their non-branch banking devices like ABMs, Point-of-Sale (POS) machines and Kiosks. For each type

New Horizon Bank would like to build a database to maintain their non-branch banking devices like ABMs, Point-of-Sale (POS) machines and Kiosks. For each type of device they would like to store a device ID, location and a device type. Especially for ABMs they would like to track the minimum cash amount that is allowed at the ABM. The company has a maintenance unit that is responsible for maintaining the devices. A maintenance routine is created for each device when an employee services it. New Horizon needs to know the date of the routine along with the description of what was done and the status of the routine. The status of the routine can be pending, in-progress and closed. It is possible for a routine to be carried out by two or three employees. The date the routine was assigned to the employee is also important as the company would like to have this information to calculate turn around time for a routine. An employee should have a TRN, name which is broken down into first name, middle initial and last name), dob, age which is calculated from dob, along with all mobile numbers for the employee. Each time an employee conducts a routine, the process is checked and signed off by a senior employee who may or may not be that employee's immediate supervisor. An employee however, can be assigned to a supervisor that is also an employee. The bank would like to know all the supervisors an employee had during their employment including the date they were assigned to that supervisor.

Develop the relational notation for your ERD diagram.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What does the start( ) method defined by Thread do?

Answered: 1 week ago

Question

Recognize the four core purposes service environments fulfill.

Answered: 1 week ago

Question

Know the three main dimensions of the service environment.

Answered: 1 week ago