Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Microsoft Visual Basic 2017 For Windows Web And Database Applications

Authors: Corinne Hoisington

1st Edition

1337102113, 978-1337102117

More Books

Students also viewed these Databases questions

Question

For the matrix evaluate |A|, adj(A),

Answered: 1 week ago