Question: draw realtion notation diagram for the below Based on the given requirements, the following relational notation for the ERD diagram can be developed: Devices table:

draw realtion notation diagram for the below
draw realtion notation diagram for the below Based on the given requirements,
the following relational notation for the ERD diagram can be developed: Devices

Based on the given requirements, the following relational notation for the ERD diagram can be developed: Devices table: - device_id (primary key) - location - device_type - min_cash_amount (for ABMs only) Maintenance_Routines table: - routine_id (primary key) - device_id (foreign key) - employee_id (foreign key) - start_date - end_date - description - status Employees table: - employee_id (primary key) - supervisor_id (foreign key, allows nulls) - trn - first_name - middle_initial - last_name - dob Employees table: - employee_id (primary key) - supervisor_id (foreign key, allows nulls) - trn - first_name - middle_initial - last_name - dob - age - mobile_number Supervisors table: - supervisor_id (primary key) - start_date - end_date - employee_id (foreign key) Note: The "Supervisors" table is used to create a many-to-many relationship between employees and their supervisors. An employee can have multiple supervisors during their employment and a supervisor can supervise multiple employees at different times. The "start_date" and "end_date" columns are used to keep track of the time period during which an employee was assigned to a specific supervisor. Based on the given requirements, the following relational notation for the ERD diagram can be developed: Devices table: - device_id (primary key) - location - device_type - min_cash_amount (for ABMs only) Maintenance_Routines table: - routine_id (primary key) - device_id (foreign key) - employee_id (foreign key) - start_date - end_date - description - status Employees table: - employee_id (primary key) - supervisor_id (foreign key, allows nulls) - trn - first_name - middle_initial - last_name - dob Employees table: - employee_id (primary key) - supervisor_id (foreign key, allows nulls) - trn - first_name - middle_initial - last_name - dob - age - mobile_number Supervisors table: - supervisor_id (primary key) - start_date - end_date - employee_id (foreign key) Note: The "Supervisors" table is used to create a many-to-many relationship between employees and their supervisors. An employee can have multiple supervisors during their employment and a supervisor can supervise multiple employees at different times. The "start_date" and "end_date" columns are used to keep track of the time period during which an employee was assigned to a specific supervisor

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 Databases Questions!