Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please don't use word for the Entity Relation diagram. Also attributes are not required. Try to use ERDPLUS for the diagram. Using ER Assistant or
Please don't use word for the Entity Relation diagram. Also attributes are not required. Try to use ERDPLUS for the diagram.
Using ER Assistant or ERDPlus, complete the enterprise model for the following database. TECHS work on many PROJECT. Each PROJECT can be worked on by many TECHS. TECHS can only work on on PROJECT AT A TIME. TECHS use many different pieces of DIAGNOSTIC EQUIPMENT. Each piece of DIAGNOSTIC EQUIPMENT is used by many TECHS but only one at a time. TECHS work in shifts at various STATIONS. They choose a vacant STATION at the start of their SHIFT. TECHS use their ID Badge to sign into a STATION. Each piece of DIAGNOSTIC EQUIPMENT is assigned a specific place on a RACK. Each RACK hold many pieces of DIAGNOSTIC EQUIPMENT. A Senior TECH supervises a shift of TECHS. Senior TECHS may or may not work on more difficult PROJECTS. NOTE: there is a ternary relationship in this mix ... show it N:M N:M N:M PART 2 (25 Points) Using ER Assistant or ERDPlus, complete the enterprise model for each of the following relationships. The college recruitment office employs many recruiters. Each recruiter is assigned to many potential students, but each student is assigned to only one recruiter; however, any recruiter can advise any student at any given time is the student calls in to the recruiting center. These calls are all captured. A student attends a specific high school. Recruiters make visit to the various high schools at different times during the school year and each recruiter will visit each high school in the area once per year. These visits are scheduled through the high school by the recruiters. RESOLVE any N:M relationshipsStep 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