Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

40 ports A laboratory would like to information about employees seis projects, and eppet. Since you are taking a duwdu. you anked to the laboratory

image text in transcribed
40 ports A laboratory would like to information about employees seis projects, and eppet. Since you are taking a duwdu. you anked to the laboratory in de prinde den the following specification . chemployees que me phone, date hint and salary players are further clawfied and technician Forintios we keep track of the rea and toma de Iedere webp track of their certifications For each pact, we need to record its start date and date cost and location. In addition, ach can be identified by its name Each of equipment a unique realmber and a cost The boy has several scene who work on one or more presente also may we certain kinds of pupent on each post. The laboratory wishes to read the weighed date that is the date when equipmentiem wiped to a particular scientist working on a specified project. Ascientist must be wired to test eptand at least one equipment item. Avenement does not need to be nel and a greed does not need to be assigned to either a scientist in equipment to Design an ER/EER-diagram for the database by identifying the entity sets, relationship sets, and their multiplicity, and the primary key for each entity set and weak entity sct, if any) and each relations set. Note that Chen's ER/EER Diagram notation (adopted in the required textbook and lecture notes) should be used to draw the diagram. Then, answer the following question QI. Which of the following statements is true? center a,b,cord) a "Projects is an entity set and has six attributes b. Projects is a relationship set and has six attributes c. "Equipment is a relationship stand has two attributes d. "Equipment is an entity set and has two attributes Q2. Is there a multi-valued attribute(s) in the ER diagram? enter"yes" or "0") If so, list its name. Oherwise, enter NA for the wet Multi-valued attributes Q3 List the number of binary relationship in the E-R diagram (enter an integer such as 0,1,2,3,...) 04. The candidate key of the entity set Employees is a simple attribute, which is ID (enter" or "false" Q5. Is there a generalization and specialization relationship? (enter"yes" or "If so, list its super entity type, and sub.entity types in sequence Otherwise, list NIA for both answers, Super entity type Sub-city type

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

Database Administrator Limited Edition

Authors: Martif Way

1st Edition

B0CGG89N8Z

More Books

Students also viewed these Databases questions