Draw an E-R diagram for each of the following situations (if you believe that you need...

Draw an E-R diagram for each of the following situations (if you believe that you need to make additional assumptions, clearly state them for each situation):

1. A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of CHEMIST include Employee_ID (identifier), Name, and Phone- No. Attributes of PROJECT include ProjecUD (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 assigned, and a given project need not be assigned either a chemist or an equipment item.

2. 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.

3. A hospital has a large number of registered physicians. Attributes of PHYSICIAN include Physician_ID (the identifier) and Specialty. Patients are admitted to the hospital by physicians. Attributes of PATIENT include Patient_ID (the identifier) and Patient_Name. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (Treatment_Detail). Components of treatment_Detail include Date, Time, and Result.

Solutions

Expert Solution

SOLUTION ;

1. ER DIAGRAM FOR CHEMIST,PROJECT,LAB,EQUIPMENT

SOLUTION 2

ER DIAGRAM FOR COLLEGE,COURSE,SECTIONS

SOLUTION 3

ER DIAGRAM FOR HOSPITAL,PATENT,PHYSICIAN

venereology answered 1 year ago

Next > < Previous

Related Solutions

For this step, you should draw an E-R Diagram for this dataset. To this goal, you...

For this step, you should draw an E-R Diagram for this dataset. To this goal, you should conduct the following steps: 1. Identify the entities and composite entities 2. Identify the entities’ attributes and primary key 3. Identify the relationships among the entities and between entities and composite entities 4. Specify the relationships' integrities

. For each of the following two situations, draw a diagram of the exchange rate market...

. For each of the following two situations, draw a diagram of the exchange rate market for U.S. dollars showing clearly the demand and supply of U.S. dollars in exchange for Japanese yen. Identify the initial equilibrium. Next illustrate on the diagrams the impact of each of the following events. Then draw a conclusion on the resulting impact on the exchange rate. (All axes, curves, and points should be clearly labeled to receive full credit) An increased preference for American...

Identify the degree and cardinalities of the relationship. - Draw the corresponding E-R diagram. Don’t forget the degree and cardinalities of each relationship.

For each of the following descriptions: - Identify the degree and cardinalities of the relationship. - Draw the corresponding E-R diagram. Don’t forget the degree and cardinalities of each relationship.1 . A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is written by one or multiple authors. Each author is identified by an author number and has a name and date of birth. Each author has either one...

1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to...

1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to identify primary keys, relationship cardinalities, etc. State any assumptions you make. 1b. Convert your E-R diagram to the relational schema. Identify the primary keys of ever relation. Consider the following application: An electronics vendor operates both a Web site and a chain of many physical stores. Examples include Best Buy and Circuit City. To ﬁnd out more about this application, think about any experiences...

Create an E/R diagram for the following business situation and convert the diagram into a set...

Create an E/R diagram for the following business situation and convert the diagram into a set of related tables: A health insurance company sells a number of insurance policies. Employer companies can buy any number of policies including zero and up to 4. A policy must be bought by at least one employer. Employees working for the employers can select at most one insurance policy. A policy can be selected by any number of employees including zero. Employees can add...

Given the following binary relations R on two sets, for each relation: Draw the arrow diagram...

Given the following binary relations R on two sets, for each relation: Draw the arrow diagram of R. Is R a function, and why? If R is a function, determine if it is injective or surjective. Is the function bijective? Justify your answers. R = {(a, 3), (c, 1)} on domain {a, b, c} and codomain {1, 2, 3} R = {(1, a), (3, c), (2, b)} on domain {1, 2, 3} and codomain {a, b, c} R = {(a,...

Please complete E-R Diagrams for the following situations. State any assumptions that you make. . A...

Please complete E-R Diagrams for the following situations. State any assumptions that you make. . A company employees a number of CONSULTANTS. Each CONSULTANT is assigned to one PROJECT or many projects for a duration of time. Each CONSULTANT is issued a laptop COMPUTER at the start of employment. The CONSULTANT has a different billing rate for each PROJECT. The COMPANY would like to track the number of hours that each CONSULTANT used the laptop

For each of the following statements, draw a diagram that illustrates the likely effect on the...

For each of the following statements, draw a diagram that illustrates the likely effect on the market for Toyota cars. Indicate in each case the impact on equilibrium price and equilibrium quantity.. A Mechanic Engineer warns that new Toyota cars overheats during long journeys. b. The price of rubber which is used to produce tyres reduces. c. A fall in the price of Nissan cars. d. A rise in bus tariffs . e. A successful advertising of...

Identify the type of specialized investment that each of the following situations require: 1. You need...

Identify the type of specialized investment that each of the following situations require: 1. You need to hire an employee to operate a machine that only your company uses. 2. Your input supplier is far away from your facility. 3. You need your supplier to provide you with an input that they do not usually produce and that only you can use in the production process

Construct an E-R diagram for a hospital with a set of patients and a set of...

Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. Use your best judgement to identify the attributes for each of those entities.

Subjects