Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started