Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please draw an EER diagram based on the business rules below. Your EER diagram must be complete, meaning all necessary information must be presented. You

Please draw an EER diagram based on the business rules below. Your EER diagram must be complete, meaning all necessary information must be presented. You must use the standard notations which we have used in the class. Underline the identifier for each entity. Make appropriate assumptions, if necessary, and clearly state them. The appropriateness of your assumption will be evaluated.
The ABC research center has multiple research labs which conduct a wide range of research projects.
Attributes of a research lab are LAB_ID (identifier) and location. Attributes of a project are Project_ID (identifier) and description. Each lab works on at least one research project. However, there is no research project in which multiple labs collaborate.
Many persons work at the ABC Research Center. A person could only be either a researcher or a technician. A person must be at least one of these categories. All person entities in the database have data provided their SSN, name and Phone number.
ach researcher must additionally provide Rank and Certificate as attributes. Each technician must additionally provide license number and restriction as attributes.
A researcher may be assigned to one project, many or no projects. A project must have at least one researcher assigned to it. The ABC Researcher Center wants to track each employee-project assignment's start and end dates.
A technician performs maintenance on a device. Attributes of the Device are Device_ID, Device_Name, and Description.
Most devices have many technicians qualified for maintenance, but some devices could be without qualified technicians. A technician can perform maintenance on many devices as the need arises and a device when maintained, needs at least one technician working on it. If a technician performs maintenance on a device, you must record the maintenance date and time.
A researcher can borrow some devices to conduct research for a specific project. Some projects may not need any devices, and others may require multiple devices. The database needs to keep track of the date and time a researcher uses a device for a particular project PLEASE SHOW THE EER DIAGRAM

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

More Books

Students also viewed these Databases questions

Question

What is the best conclusion for Xbar Chart? UCL A X B C B A LCL

Answered: 1 week ago

Question

how would you have done things differently?

Answered: 1 week ago

Question

What were the reasons for your conversion or resistance?

Answered: 1 week ago

Question

How was their resistance overcome?

Answered: 1 week ago