Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
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…
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.
Chapter 2 Solutions
Modern Database Management (12th Edition)
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Prob. 2.2RQCh. 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 - Prob. 2.12RQCh. 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 - For each of the descriptions below, perform the...Ch. 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 - The entity type STUDENT has the following...Ch. 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 - Prob. 2.35PAECh. 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.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
- Create an Entity-Relationship Model for the Queen Anne Curiosity Shop The first assignment for the class project is to create an entity-relationship model of the Queen Anne Curiosity Shop database. This assignment requires you to apply the knowledge gained from study of chapter 4 of the textbook. You will create the entity-relationship model using the ERDPlus database modeling tool. The Queen Anne Curiosity Shop database contains the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, EmailAddress) EMPLOYEE (EmployeeID, LastName, FirstName, Phone, EmailAddress) VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, EmailAddress) ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total) SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice) Note that the above table descriptions follow the textbook convention:…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
- Design: An (ER) and (relational Diagram) by showing as I am an owner of a car rental company website describing the following domain: I am the owner of the website, and I see the registered customers records I have through different car types and car rental Every rental operation has a start or end by day or KM Every car has a different price depending on its year production and model We have three rental types( Per Kilometers, monthly, daily) in different prices even though it was the same car Any one can enter his 'id' which includes ( Name, age, gender, address, city, Civil id), and this 'id' is the primary ket to all entities He would proceed to register for renting a car per his choice Then he will send the registrations form that I will analyze and contact him Every customer can rent only one car This choice has one car rental type based on the available listed cars in the registration The owner of that website has the "id" records and the registration database running its…arrow_forwardP2arrow_forwardTask 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows: Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price. Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall. Each supplier has a supplier name and address. A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product. A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…arrow_forward
- DataBase 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_forwardDatabase Foundations: Design a database to produce the following reports. Do not use any surrogate keys in your design. For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired. For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many different guides. For each client, list the client number, client last name, client first name, address, city, state, postal code, and telephone numberarrow_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
- Design the back-end database for an online bookstore called “Books for You” (BFY); draw the entity-relationship diagram for the following order processing system. Order Processing System: BFY maintains a website to get customer orders. Customer can visit BFY website either directly or through other websites having partnership with BFY. All the customers are required to create an account before placing an order. Customers of BFY can be classified into individual customers and business customers. Privileges for business customers differ from that of individual customers. For example, business customers are given 30 or more days credit apart from some trade discount. Business customers mostly pay through checks and credit cards after receipt of the books whereas the individual customers have to make payment through a credit card when they place an order. BFY keeps a track of all the payments that it has to receive from credit card companies and banks. A customer can buy any book of…arrow_forwardIf you sell a house more than once, it is treated as different "property" for each sale. Draw an entity-relationship diagram and write a database design outline. Q2. Law Office: You are trying to automate the records for your uncle's law firm. Multiple attorneys work for the firm, and for each of them you want to store their first name, last name, date hired, hourly billing rate, and date promoted to partner (blank if the attorney is not a partner). Each attorney has multiple cases, which is identified by a unique "docket number". Each case has a name and description, is worked on by only one attorney, and involves a single client. For each client, you want to store a first name, last name, middle name, phone number, address, city, state, and zip code (assume you do not have a zip-code table). Finally, you want to keep track of the billable hours spent on each case. For a single case, this comprises information that looks like Hours Billed Date 2/24/2005 Description Prepare brief…arrow_forwardIn the database, what is the difference between attributes and entity. This can be clarified by a form in which everything is shown. For example, this is an arrow to what it refers to, and this is a circle to what it indicates. Thank youarrow_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