1. Using Dia, draw the ER diagrams to represent the relationship type suggested by each of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Using Dia, draw the ER diagrams to represent the relationship type suggested by each of the following scenarios. You do not need to include any attributes in your ER diagrams, only the entity type and relationship types. 1. There are two entity types: nurses and patients. Each nurse treats many patients and each patient is treated by many nurses. Each patient must belong to the relationship, but nurses on vacation do not have to belong to the relationship. 2. There are two entity types: students and professors. Professors have a set of students that they advised regarding course selection. Each student is advised by exactly one professor, but professors will typically advise many students. Some professors do not advise students at all. 3. There two entity types: boats and people in the park. People in the park rent the boats from the park. Each person in the park can rent one boat at a time, and each boat is rented to only one person in the park. A boat may or may not be rented, and people in the park to not have to rent boats. 4. There are three entity types: cameras, lenses, and photographs. A photograph is taken with one camera that has attached a single lens. But a camera can take many photographs using many lenses. A lens can be used on many cameras to take many photographs. 2. Consider the following ER diagram (primary keys are underlined): Room Durm De varchar(30) numRooms numere(3) address varchar (54) Belong To Roo bunked maric (3) boolman shared Bathrose boolean Resides in A Student Sid numeric(6) ane varchar(25) phone varchar(12) with Create the relational database tables required to implement this ER diagram using SQL create table statements. Include primary key and foreign key constraints. 3. Consider the following ER diagram (primary keys are underlined): Customer name *Email address *phone 0 0.. 1..1 Date Purchase Owns 0..1 0. * Store *name address phone Credit Card 0..* *number bank creditlimit Use SQL create table statements to implement this ER diagram as a set of relational database tables. Include primary key and foreign key constraints. 4. Consider the following description of a system: A company makes shipping products: envelopes and boxes. The company's products each have a model number, a product name, a wholesale price, and a suggested retail price. Boxes are described by three dimensions (width, height, and depth) and whether they are corrugated or not. Envelopes are described by two dimensions (width and height) and whether they are padded or not. The company produces its products at five locations. Each location produces at least one of the products, and each product is produced by at least one of the locations. The locations are described by the address (street number, street, city, state, and zip code), main office number, and an identifying number. The company's employees are identified by an employee number, a first and last name, home address, phone number, gender, and birth date. An employee works at exactly one location, but each location has many employees working there. One employee is the location director. For the above description, answer the following questions (you are not to draw an ER diagram, simply write the required responses 1. What would be ER entity types that could be drawn from this description? 2. What would be ER association relationship types that could be drawn from this description? Specify all entity types that belong to each relationship type. 3. What would be ER generalization/specialization relationship types that could be drawn from this description, if any? Specify all entity types that belong to each relationship type. 4. For each of the association relationship types, specify the cardinality and participation constraints. 5. For each of the generalization/specialization relationship types, specify whether the relation is mandatory or optional and whether the specializations are disjoint or overlapping. 5. Using the Dia tool, draw the ER diagram that represents the data model from problem 4. Include for each entity type the attributes and the primary key. 6. Identify the relational database tables that would implement the ER diagram from problem 4. Specify the table attributes and the primary key and foreign key choices that Page 2 of 3 1. Using Dia, draw the ER diagrams to represent the relationship type suggested by each of the following scenarios. You do not need to include any attributes in your ER diagrams, only the entity type and relationship types. 1. There are two entity types: nurses and patients. Each nurse treats many patients and each patient is treated by many nurses. Each patient must belong to the relationship, but nurses on vacation do not have to belong to the relationship. 2. There are two entity types: students and professors. Professors have a set of students that they advised regarding course selection. Each student is advised by exactly one professor, but professors will typically advise many students. Some professors do not advise students at all. 3. There two entity types: boats and people in the park. People in the park rent the boats from the park. Each person in the park can rent one boat at a time, and each boat is rented to only one person in the park. A boat may or may not be rented, and people in the park to not have to rent boats. 4. There are three entity types: cameras, lenses, and photographs. A photograph is taken with one camera that has attached a single lens. But a camera can take many photographs using many lenses. A lens can be used on many cameras to take many photographs. 2. Consider the following ER diagram (primary keys are underlined): Room Durm De varchar(30) numRooms numere(3) address varchar (54) Belong To Roo bunked maric (3) boolman shared Bathrose boolean Resides in A Student Sid numeric(6) ane varchar(25) phone varchar(12) with Create the relational database tables required to implement this ER diagram using SQL create table statements. Include primary key and foreign key constraints. 3. Consider the following ER diagram (primary keys are underlined): Customer name *Email address *phone 0 0.. 1..1 Date Purchase Owns 0..1 0. * Store *name address phone Credit Card 0..* *number bank creditlimit Use SQL create table statements to implement this ER diagram as a set of relational database tables. Include primary key and foreign key constraints. 4. Consider the following description of a system: A company makes shipping products: envelopes and boxes. The company's products each have a model number, a product name, a wholesale price, and a suggested retail price. Boxes are described by three dimensions (width, height, and depth) and whether they are corrugated or not. Envelopes are described by two dimensions (width and height) and whether they are padded or not. The company produces its products at five locations. Each location produces at least one of the products, and each product is produced by at least one of the locations. The locations are described by the address (street number, street, city, state, and zip code), main office number, and an identifying number. The company's employees are identified by an employee number, a first and last name, home address, phone number, gender, and birth date. An employee works at exactly one location, but each location has many employees working there. One employee is the location director. For the above description, answer the following questions (you are not to draw an ER diagram, simply write the required responses 1. What would be ER entity types that could be drawn from this description? 2. What would be ER association relationship types that could be drawn from this description? Specify all entity types that belong to each relationship type. 3. What would be ER generalization/specialization relationship types that could be drawn from this description, if any? Specify all entity types that belong to each relationship type. 4. For each of the association relationship types, specify the cardinality and participation constraints. 5. For each of the generalization/specialization relationship types, specify whether the relation is mandatory or optional and whether the specializations are disjoint or overlapping. 5. Using the Dia tool, draw the ER diagram that represents the data model from problem 4. Include for each entity type the attributes and the primary key. 6. Identify the relational database tables that would implement the ER diagram from problem 4. Specify the table attributes and the primary key and foreign key choices that Page 2 of 3
Expert Answer:
Answer rating: 100% (QA)
It seems you have given a multipart question that involves EntityRelationship ER diagrams and their implementation into SQL table creation Due to the nature of handling such questions the entire proce... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
During 2024, Peaceful River Spa reported revenue of $50,000. Total expenses for the year were $32,000. Peaceful River Spa ended the year with total assets of $38,000, and it owed debts totaling...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Outline the accounting procedures involved in applying the operating method by a lessee.
-
Determine the output voltage Vo of the summing op-amp circuit shown. 24 36 12 12 24 24 1V
-
As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared...
-
What are the negative aspects of using a seismic transducer?
-
Exhibit contains the income statements and balance sheets of The Hershey Company, manufacturer of such well-known products as Hersheys chocolate bars, Reeses peanut butter cups, Almond Joy candy...
-
Fist Fight. Kyle punched Walt in the face in the parking lot of a local bar, breaking Walt's nose. Kyle was charged with aggravated assault. He claims self-defense; Kyle states that Walt was angry...
-
W&S Partners has just won the January 31, 2026, audit for Cloud 9. As a part of the risk assessment phase for the new audit, the audit team needs to gain an understanding of Cloud 9's structure and...
-
a. b. Calculate the pressure exerted by 50.0 g of HFC-134a in a 75 cm vessel at 327.0 C using (1) the perfect gas EOS, (2) the VDW EOS, and43) the three-term virial EOS. Assuming that the virial...
-
Citigroup has just issued a coupon bond that will pay $80 each year for the next 8 years. The bond's yield-to-maturity is 7.7%. What is the price of the bond? Question 2 Bank of America has a 6%,...
-
The duration of the fixed portion of a swap is 6 whereas the floating portion of the swap has a duration of 2. If interest rates rise by 10 bps, who gains and by how much?
-
A cuboid is 13cm long and 6cm high. 125 volume is 624cm^(3). Find (a) Its breadth (b) its total surface area.
-
Natasha has been talking with her bank about its interest rates. Her banker has told her that they offer higher rates if she puts her money in a certificate of deposit rather than a regular savings...
-
Two schemes: X & Y were offered to Eric. Scheme X demands an initial investment of $10K and a $3K yearly benefit. While Scheme Y asks for an initial investment of $12K and a $3.5K yearly benefit....
-
Illustration 7 A Ltd. Company issued 10,000 shares of 10 each. Payment on these shares i be made in the following manner: On application 4 (1st January, 2009) On allotment 4 (1st March, 2009) On...
-
How much more interest will be earned if $5000 is invested for 6 years at 7% compounded continuously, instead of at 7% compounded quarterly?
-
What is the average Read score for all students? What are the minimum and maximum Read scores? Based on the relations shown in Figure 6-12. The database tracks an adult literacy program. Tutors...
-
Give four reasons why many system designers believe that data modeling is important and arguably the most important part of the systems development process.
-
Match the following terms to the appropriate definitions: _________ View a. list of values _________ Referential b. description of a database _________ Integrity constraint c. view materialized as a...
-
The following is the distribution of the hourly number of trucks arriving at a company's warehouse: Find the mean of this distribution, and using it (rounded to one decimal place) as the parameter...
-
With reference to Exercise 10.42, verify that the mean of the observed distribution is 1.6 , corresponding to \(40 \%\) of the cars requiring repairs. Then look up the probabilities for \(n=5\) and...
-
Among 100 purification filters used in an experiment, 46 had a service life of less than 20 hours, 19 had a service life of 20 or more but less than 40 hours, 17 had a service life of 40 or more but...
Study smarter with the SolutionInn App