A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equip- ment on each project. Attributes of CHEMIST include Em- ployee_ID (identifier), Name, and Phone_No. Attributes of PROJECT include Project_ID (identifier) and Start_Date. Attributes of EQUIPMENT include Serial_No and Cost. The organization wishes to record Assign_Date-that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A chemist must be assigned to at least one project and one equipment item. A given equipment item need not be as- signed, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.

A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equip- ment on each project. Attributes of CHEMIST include Em- ployee_ID (identifier), Name, and Phone_No. Attributes of PROJECT include Project_ID (identifier) and Start_Date. Attributes of EQUIPMENT include Serial_No and Cost. The organization wishes to record Assign_Date-that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A chemist must be assigned to at least one project and one equipment item. A given equipment item need not be as- signed, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?
Draw an E-R diagram for each of the descriptions below. Q -An architectural design firm has a number of design projects underway at any point in time. Each of these projects is identified by a unique project identification code. Additional data stored for each project includes a description, a target completion date, and a dollar budget amount. Design associates staff these projects. These associates include architects, engineers, and computer CAD (Computer-Aided Design) specialists. Each associate is identified by a unique code. Other information about associates includes their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically has at least one bronze associates reporting to her), and the silver associate reports to a gold associate in the same fashion. Each project staffed by at least one associate staff. It is also common to find any particular associate…
Consider the following entity relationship diagram. Booking Employee Room Building • Booking ID • Employee ID • Building ID • Room ID • First Name • Room ID P • Name Description • Employee ID • Name Last Name • Date • Campus Zone • Email Address • Capacity • Start Time • Map Coordinates Phone • Bookable • End Time For each statement below, use the drop-down box to indicate whether it is true (answer 1) or false (answer2), according to the design decisions encoded in the ERD. Every booking is associated with exactly one employee. ✓ Every employee is associated with at most one booking. ✓ A building may contain no rooms that are recorded in the database. Each room may have many bookings. 1. True ✓ A room must have at least one booking. 2. False ✓ A booking can be associated with many employees. An employee may have no phone number recorded. ✓ A room must have its capacity recorded. ✓ A building is uniquely identified by its map coordinates.
Which among the following statements is false about verification and validation of use case diagram? O a. All relationships should be shown on use case diagram as per the use case description. O b. All diagram specific rules must be enforced. O c. There should be one and only one description for each use case. O d. The sequence of use case description need not match the sequence in the activity diagram.
Question 3 Draw a detailed activity Diagram in draw.io and screenshot it for me. ( **Please take note is a detailed activity diagram) Scenario The exam unit uses the system after the subject registration period has closed. The system will display a list of subjects that have registered students. Using this list, the exam unit will plan out examination week. Examination week lasts 6 days, from Monday to Saturday. For each day, the exam unit will assign a subject to that day. Each day can have a total of 6 examination hours with subjects having 2- hour or 3-hour examinations. For example, if the subjects are 2-hour examinations, then 3 of them can be scheduled for the day and if the subjects are 3-hour examinations, then only 2 of them can be scheduled for the day. There can also be a mixture of 2-hour and 3-hour examinations. If the exam unit schedules too many examination hours for that day then the day resets and the exam unit needs to reschedule again. This process stops when…
Question=1)DRAW : Matrix diagram of this entities project will be about a student attendance. Entities: student, course, instructor, attendance, enrollment, department, class. Relationships: Student is enrolled in course, Course has instructor, Department has many courses, Entities: 1. Student - Attributes: Student_ID (Primary Key), Name, Age, Email, Phone _Number 2. Course - Attributes: Course_ID (Primary Key), Course_Name, Department_ID (Foreign Key) 3. Instructor - Attributes: Instructor_ID (Primary Key), Name, Department_ID (Foreign Key) 4. Attendance - Attributes: Attendance _ID (Primary Key), Student_ID (Foreign Key), Course_ID (Foreign Key), Date, Status 5. Enrollment - Attributes: Enrollment_ID (Primary Key), Student_ID (Foreign Key), Course_ID (Foreign Key), Enrollment Date 6. Department - Attributes: Department_ID (Primary Key), Department_Name 7. Class - Attributes: Class_ID (Primary Key), Class_Name, Department_ID (Foreign Key) Draw Matrix diagram of this scaniorio
Task Description: consider the following relations for a university: Student (sid: integer, sname: string, GPA: real, dateOfBirth: date) Department (did: integer, dname: string, capacity: integer) Course (cid: integer, cname: string, credit: integer) Enroll (studentID: integer, courselD: integer, departmentID: Integer, enrollmentDate: date) studentlD, courselD, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively.
Q2: Draw an E-R diagram Representing the relationship between Employee with Attribute EmpID, Name, Address And Project with Attributes proj-id and proj-Name. Each employee may be assigned one or more projects, or may not be assigned any project on the other hand one or more projects, may be assigned to an employee.
Write relationship and cardinality constraints which is in list. You need to make any assumptions I need querry
In which type of diagram fork and join terms are used?
Q1: The following Component Diagram has some errors circle the error and redraw the correct diagram: Student Registeration Database Examination Graduation Admin
Assignment: Problem #7 from Chapter 4 of the textbook. The case study is United Helpers. With the use of Microsoft Visio, draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, optionalities, connectivities and cardinalities. In addition, be sure to include a heading on your ERD with a brief descriptive title, your name, and a date. It is suggest that you write out business rules but the rules do not need to be submitted. 7. How would you (graphically) identify each of the following ERM components in a Crow’s Foot notation? an entity the cardinality (0,N) a weak relationship a strong relationship