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.

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter12: Systems Development: Investigation, Analysis, And Design

Section: Chapter Questions

Problem 12SAT: Data modeling is most often accomplished through the use of a(n) __________________. a....

See similar textbooks

Similar questions

I'm designing an ER diagram for a project and I have to represent an entity called User, with the attributes: Username, Password and Role. But the role contains (Supervisor and Farmer) My question is should role be a multivalue property (attribute) or should it be two separate entities? Either way, how would it be represented in the ER diagram? (if it was an attribute or two entities)
Question 2 Draw an activity Diagram in draw.io and screenshot it for me. Scenario Each subject has 1 lecture class and 4 tutorial classes. Each lecture class can have a maximum of 80 students only and each tutorial class can have a maximum of 20 students only. From the system, the faculty will generate a list of subjects that have registered students. Then the list of academicians for the faculty is displayed. For each academician, the faculty can assign either 1 lecture class or 3 tutorial classes. The faculty will keep assigning duty to the academicians until there are no more lecture or tutorial classes.
Please provide a drawn diagram either online tools or hand written for Question 2b to better understand!
create an Enhanced Entity-Relationship (EER) diagram based on the provided information. Based on the following description, try creating the diagram using a tool such as draw.io, Lucidchart, or any other ER diagram tool: Entities: Person: person_ID (PK), name, address, birth date, phone number Subtypes: Employee, Physician, Patient, Volunteer Visit: date (PK, partial identifier), comments Care Centre: care_centre_ID (PK), name, location Laboratory: lab_ID (PK), name, location Bed: bed_number (PK), room_number, care_centre_ID (FK) Item: item_number (PK), description, unit_cost Treatment: treatment_ID (PK), treatment_number, treatment_name, treatment_date, treatment_time, results Relationships: Works_In (Person - Care Centre): Person (1, M) ----< Works_In >---- (1, M) Care Centre Assigned_To (Employee - Care Centre): Employee (1, M) ----< Assigned_To >---- (1, M) Care Centre Assigned_To (Physician - Care Centre): Physician (1, M)…
Draw an ER diagram for the following scenario- • An instructor has an ID, a name, and a phone number. An instructor teaches a course • A course has a code, course name, credits, and an instructor. Each course uses a textbook. • A textbook has ISBN, name, publisher, editor, and authors. Your ER diagram should have entities, attributes, composite attribute, multivalued attribute, key attributes, binary relationships, and a total participation. Explain your rationale behind each design choice. Please draw the ER diagram on paper showing all seperate parts for each instructor, course and textbook. Showing each connection seperately and explaining which connection is which
. Below is a description of the business process of a hospital.After reading the business process below, provide an ERD showing the primary key, all attributes,relationships, and cardinalities as in the sample ERD. When developing ERD, you must use a diagramming tool. Using an ERD tool is a part of diagramdrawing, so hand-drawn ERD will not be accepted. While various free ERD drawing tools areavailable on the web, some tools may require you to pay depending on the tool and the plan you select.You may refer to this list https://clickup.com/blog/erd-tools/ and select a tool you want. However, thetools you may select are not limited to the list in the link.Once you have completed your diagram, print it as a PDF file and submit it to CougarVIEW dropbox.If you need multiple pages to include all your tables, print it in multiple pages.Description of business processIn hospital, there are many departments like Orthopedic, Pathology, Emergency, Dental,Gynecology, Anesthetics, I.C.U.,…
Your in-house company has been selected for development a gym system, with manybranches, your team has many carried on meeting with the gym owners to define the mainrequirements and what they expected, and the main output from the system, the mainideas that’re discussed with the owners as follows,1. There are 7-12 trainers in two shifts for each branch.2. Each trainee has a unique ID that he can use to train in any branch.3. The branches should be connected and the ID is incremental.4. There are 4 programmes the trainee can follow based on what he needs. Buildmuscles, lose fat, or Increase the strength, the programmers as follows,a. Pro Split: train each muscle one time in a week.b. Upper and Lower: one training for the upper body, and next day for lowerbody.c. Push – Pull – Legs: this program me divide the body into 3 pieces, one dayfor push like chest and triceps, the next day is pull like back and biceps, andthe third day is for legs.d. Full Body Work Out: that’s balance between…
Your in-house company has been selected for development a gym system, with manybranches, your team has many carried on meeting with the gym owners to define the mainrequirements and what they expected, and the main output from the system, the mainideas that’re discussed with the owners as follows,1. There are 7-12 trainers in two shifts for each branch.2. Each trainee has a unique ID that he can use to train in any branch.3. The branches should be connected and the ID is incremental.4. There are 4 programmes the trainee can follow based on what he needs. Buildmuscles, lose fat, or Increase the strength, the programmers as follows,a. Pro Split: train each muscle one time in a week.b. Upper and Lower: one training for the upper body, and next day for lowerbody.c. Push – Pull – Legs: this program me divide the body into 3 pieces, one dayfor push like chest and triceps, the next day is pull like back and biceps, andthe third day is for legs.d. Full Body Work Out: that’s balance between…
find a resource online about the inappropriate use of a particular type of diagram. For example, using a pie chart for items that you are looking to compare in volume instead of percent.
Create an ER/EER diagram for the following 1. Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, anending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.). Each project is managed by one professor (known as the project’s principalinvestigator). Each project is worked on by one or more professors (known as the project’s co-investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project’sresearch assistants). When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. Departments have a department number, a department name, and a main office. Departments have a professor (known…
Identify the Actors and the Use Cases from the customer requirements in Appendix-A . Briefly describe them and draw the use case diagram using an UML tool . Prepare Detailed Use Case Descriptions with UML Activity Diagrams for “Submit Homework” and one other Use Case you identify from Moodle (Student Information System) software that has actor of type “student”. For all diagramming use Gliffy (https://www.gliffy.com/) or another UML modeling tool you prefer. APPENDIX-A Online Hotel Reservation System RichOS hotels owner Mr. Tompkins wanted an online reservation system (HORSE) for his new hotel located in Antalya. The hotel has two types of rooms: regular and suit. In order to make a reservation or cancel any other, the clients (persons or travel agency) must logon the system. The clients should register to the system through their names, e-mail and telephone information. Clients will be able to query the availability of the rooms selecting a date interval and room type. The client will…
i need a own Scenario (not from internet) to create an ERD. which should have atleast three entities and must have many to many relationship. JUST need a scenario statement.