Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 2.41PAE
Program Plan Intro
To create a diagram with the given attributes and entities.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Alert dont submit AI generated answer.
Q2. ER Model Develop an ERD for the following case:
A school of technology has hired you to create a database to assist in scheduling classes. After
several interviews with the users, you have come up with the following data requirements and
business rules. Based on them, create an ER Model for the school's database.
BUILDING has many rooms. Each room is located in a building. The attributes for BUILDING
are BuildingNo. BuildingName and Location. ROOM is always identified in association with
BUILDING (BuildingNo). The attributes for ROOM include RoomNo and Capacity. There are
two types of room. A room can be either LAB or CLASSROOM. If it is a lab, it has an
additional attribute called LabHours. If it is a classroom, it has an additional attribute called
ZoomEnabled?.
COURSE has identifier CourselD and has attributes CourseDescriptions and Credits. A course
may (or may not) have more than one section. Each section is always identified in association
with COURSE (CourseID). SECTION has…
Look at the 4 entities below and assume that customer_id is the key common to all tables.
• Customer: An entity that describes a customer. An instance occurs for unique customers only
using name, date of birth, and login name as customer_id primary key.
• Online: An entity that describes a customer purchasing activity online. An instance occurs
when the customer completes the transaction. Customers can purchase more than once.
• Visits: An entity that describes a customer purchase in a physical store. An instance occurs if a
customer makes or purchase or checks-in using an app. Customers can visit more than once
per day.
• Satisfaction: An entity that represents data from a recent customer satisfaction survey. An
instance occurs when a customer takes the survey. A customer is tracked by login name and
can only take the survey one time.
Use the information to match the following relationships. Answers can be reused more than once.
The relationship between Customer and
Online
The…
Chapter 2 Solutions
Modern Database Management
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Give an example, Other than those described in...Ch. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - Prob. 2.24PAECh. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - Prob. 2.29PAECh. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Figure 2-27 represents a situation of students who...Ch. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.46PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
Knowledge Booster
Similar questions
- Please draw an Entity-Relationship diagram for the given below MOVIE database. The data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies.arrow_forwardThe set of 7 attributes is { desc, drought, price, sci, size, store, zones } The attributes are for plants for sale at different stores The dependencies are: {sci, store, size} -> {price} {sci} -> {desc, drought, zones} "desc" is the description of the plant "drought" is whether the plant can survive with less water "price" is the price of the plant "sci" is the scientific name of the plant "store" is the name of a store that sells the plant "zones" indicates which climate zones the plant will grow in What is the key for the complete set of attributes? a. price O b. sci, store and size c. desc, drought and zones d. sciarrow_forwardInstructions: Create a dimensional model for a particular business process involving gym membership. A customer can sign up for a membership of say one, three, six or twelve months. I want to make it easy to query to identify current members, members who expired in the last month, members who renewed in the last month, those who are pending expiry etc. If I have a basic model with a fact table representing a gym membership say start_date_key end_date_key membership_attribute_key customer_atrribute_key fee with associated dimension table for date, membership attributes such as length, customer attributes and so forth. On a particular day, the active members are those with a start date before the day and an end date after that day. Those who will expire next month are those where the end date is in a particular date range.arrow_forward
- Explain why an index is only helpful if an attribute's values cover a suitable range. This is the only scenario when an index is relevant.arrow_forwardDesign the database, following an ER model. 1. Patients: Patients are tracked by a unique patient ID. Personal information includes first name, last name, phone number, Date of Birth, and sex. The combination of the Patient's first and last name must be unique. Patient's sex is a mandatory field. Patient can be registered at any clinic. 2. Cancer: Type of cancer is tracked by a unique ID. Cancer is categorized as either Oral, Lung, Breast, Liver, Blood, Bone, Pancreatic, Cervical, or Prostrate. Stage of cancer can be Stage I, Stage II, or Stage III Stage of cancer detection. Treatment given: Chemotherapy only, Surgery with chemotherapy, Surgery only or Radiation therapy. Patient_id is an FK which references the ID of the Patient. Clinic_id is an FK which references the ID of the Clinic that patient register. Patient information must be stored at one clinic. Patient Date of detection of Cancer. 3. Clinic: Clinics are…arrow_forwardAn E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.arrow_forward
- In an ERD, entities do not have columns. Instead which of the following is used to describe the entity's characteristics? Group of answer choices attributes degrees instances relationshipsarrow_forwardDataBase case study: read this case study and finilize what should be the enitties that is mentioned in the case study and then make a ERD daigram of this data. Delhi Mart is a super Store located at Mahavir Enclave, New Delhi, India. Delhi Mart has many types of products that are related to specific Category. Delhi Mart are avail many different customers to sell their products daily. Every Category is managed by a particular manager. Customer order their selected product in terms of qty and avail selected discount on the product. Delhi Mart also have staff that manage different departments in the mall. Every Customer is concern with a particular staff to resolve their queries. Every Manager is responsible to maintain the stock if the stock will out they contact their selected supplier for buying products.arrow_forwardThe entity relationship diagram below models the components of a database belonging to the South African Film Writers' Association. The database allows SAFWA to keep track of movies filmed in South Africa, developed by domestic and international studios. The MS Access database diagram below shows the tables created for a travel agent company called TravelSpace. They implemented their database to keep track of their customer's bookings for the different trips they have available. The company offers multiple tours which can be booked by many different customers. Given the diagram below, answer the following questions by providing SQL statements. CUSTOMER BOOKING CUST NO CUST FNAME BOOKNG NO TOUR BOOKING EMP ID CUST NO BOOK STATUS CODE 7 TOUR ID 7 80OENG NO TOUR DATE TOUR CUST LNAme CUST ADORESS CUST DOB CUST EMAIL OUT SEAT NO IN SEAT NO CUST, PHONE 1 TOURO TOUR NAME TOUR DESCRIPTON EVENTJD HOTEL_D TOUR PRICE ADULT FUGHT NO BOOK, TOTAL, COST BOOKNG DATE TOUR PRICE CHILD TOUR, PRICE CON…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education