Answered step by step
Verified Expert Solution
Link Copied!

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

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 relationships

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

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke

1st Edition

0130086509, 978-0130086501

More Books

Students also viewed these Databases questions

Question

Ergonomics looks at the physiological and physical demands of work.

Answered: 1 week ago

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago