Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 3.32PAE
Program Plan Intro
Draw the EERD for the RentQualityComputers(RCQ) based on the given information.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
ER-Diagram and EER-Diagram
Medinah Transport dealership sells Proton, Ford, Honda and Toyota. The dealership keeps the cars information such as vehicle number, list price, chassis number, made (eg. Honda, Toyota), model name (eg. Civic, Camry) and year. They also keep information about all sales they have made (for instance, invoice number, buyer’s name, data of purchase and amount paid for the car). In order to contact the buyers in the future, the dealership also keeps their telephone number and address. Some buyers bought more than one car. For statistical purposes, the buyer’s gender and age are also captured. Dealer also needs to know the staff who sold the cars to the buyers such as their staff ID, name, phone number, gender, date of birth, address and basic salary. The dealership has two types of staff - sales agent and admin. Sales agent will have sales quota, basic salary and sales commission from selling cars. While admin staff will receive basic salary and overtime (based on…
need diagram only
Draw an ER diagram for the following scenario:
A designer has a store of designer dresses both for male and female.
People can buy as well as take dresses on rent from the store.
Each dress in the designer's store, is identified by unique ID.
A dress in the store can be categorized into various categories Western, Indian, Indo-westem, etc.
The designer maintains the name, phone number of people who have taken dresses on rent.
The designer also maintains the name, phone number, and address of people who have bought dresses from the store.
The designer also collects feedback from the people who have bought or taken dresses on rent from the store.
Design the ER diagram by mentioning all the structural constraints. You may also include additional information in addition to the requirements listed.
Entity-Relationship Diagrams (ERD) Background Information:
Study the following statements to determine the relationship between the entities
• Each student has an academic advisor. An academic advisor can advise many students.
• Each academic advisor has a specific parking spot assigned.
• Each student can take up to five courses. and each course has up to 24 students.
• Several adjunct faculty members share an office.
Tasks: 1. Draw an ERD (it is just one diagram) showing the entities and the relationships among them. Include associative entities, if any. Also, remember to show cardinality (1:1, 1:M, M:N); you can use the cardinality notation or the crow’s foot notation. Remember that this is a graphical language, and you must follow the shapes of the elements in the diagram.
Chapter 3 Solutions
Modern Database Management
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Match the following terms and definitions:...Ch. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQCh. 3 - Give an example (other than those discussed in the...Ch. 3 - What is the attribute inheritance? Why is it...Ch. 3 - Give an example of each of the following: a...Ch. 3 - What types of business rules are normally captured...Ch. 3 - What is the purpose of a subtype discriminator?
Ch. 3 - Prob. 3.11RQCh. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - What do you purchase when you acquire a packaged...Ch. 3 - In Figure 3-5b, why must the minimum cardinality...Ch. 3 - When is a member of a supertype always a member of...Ch. 3 - Examine the hierarchy for the university EER...Ch. 3 - Add a subtype discriminator for each of the...Ch. 3 - For simplicity, subtype discriminators were left...Ch. 3 - Refer to the employee EER diagram in Figure 3-2....Ch. 3 - Refer to the EER diagram for patients in Figure...Ch. 3 - Figure 3-13 shows the development Of entity...Ch. 3 - Refer to Problem and Exercise 2-44 in Chapter 2...Ch. 3 - For a library, the entity type HOLDING has four...Ch. 3 - A bank has three types of accounts: checking,...Ch. 3 - Refer to your answer to Problem and Exercise 2-4...Ch. 3 - Refer to your answer to Problem and Exercise 3-24...Ch. 3 - Prob. 3.29PAECh. 3 - Draw an EER diagram for the following situation:...Ch. 3 - Develop an EER model for the following situation,...Ch. 3 - Prob. 3.32PAECh. 3 - Prob. 3.33PAECh. 3 - Prob. 3.34PAECh. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAECh. 3 - Prob. 3.37PAECh. 3 - Add the following to Figure 3-16: An EMPLOYMENT...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- OVERVIEW Body mass index (BMI) is a value derived from the mass (weight) and height of a person. The BMI is defined as the body mass divided by the square of the body height, and is expressed in units of kg/m2, resulting from mass in kilograms and height in meters. The BMI may be determined using a table or chart which displays BMI as a function of mass and height using contour lines or colors for different BMI categories, and which may use other units of measurement (converted to metric units for the calculation). The BMI is a convenient way for classifying persons in to 4 categories based the BMI value as shown the following table: BMI value Category Underweight Normal Overweight Less than 18.5 18.5 to less than 25 25 to less than 30 30 or higher Obese A national study in some country to analyze the BMI of the people in the country is considered. In this study, a set of cities is selected in the study and randomly specific number of persons are selected to check the BMI category of…arrow_forwardMake use-case diagram: The customer wants a system for bike racing registrations where Organizers of eventscan publish races, people who want to race can sign up and the system should also keeptrack of the old races to racers can "level up" and start in higher categories (cat).Racers who officially want to race need to sign up with the system with their name,credit card information. To be able to register for official races they need to buy alicence. The license is always valid for 1 year and has a specific ID and is for the racerscurrent level (cat). Racers are sorted into categories 5-1 where 5 is beginner and 1 isthe best category. Racers can only race in official events if they have the cat required,so they need to race against others their level.Organizers can create races. The interesting part is though that a race can consist ofdifferent stages. E.g. one stage is a road race, the other a criterium and the other atime trial (you can find what these are online). Each stage is on a…arrow_forwardA library has books, journals, and periodicals that it loans to its users. All library material has an accession number which is a unique identifier and a price. In addition, a book has a title, publisher, year of publication, edition, and authors. Journals have journal name, volume number, issue number and year of publication. Each article in a journal has a title and authors. A periodical has a name and date of publication. The library keeps one or more copies of each library item (book, journal, periodical). Copies of all library material can be loaned to users. Reference-only material is loaned for 2hrs and can’t be removed from the library. Other material can be loaned for 2 weeks. For every loan, the library records the user, the loan date and time, and the return date and time. For users, the library keeps their name, address, and cell phone number. If a user loses a loaned item they are made to purchase it, however, if the user delays with the loaned item they are finned…arrow_forward
- A library has books, journals, and periodicals that it loans to its users. All library material has an accession number which is a unique identifier and a price. In addition, a book has a title, publisher, year of publication, edition, and authors. Journals have journal name, volume number, issue number and year of publication. Each article in a journal has a title and authors. A periodical has a name and date of publication. The library keeps one or more copies of each library item (book, journal, periodical). Copies of all library material can be loaned to users. Reference-only material is loaned for 2hrs and can’t be removed from the library. Other material can be loaned for 2 weeks. For every loan, the library records the user, the loan date and time, and the return date and time. For users, the library keeps their name, address, and cell phone number. If a user loses a loaned item they are made to purchase it, however, if the user delays with the loaned item they are finned…arrow_forwardAnnotated Bibliography As a graduate student, one of the fundamental techniques to gather research for a paper is the use of an Annotated Bibliography. Furthermore, as a human-computer interaction researcher, finding relevant literature to support a study is also part of preparing an analytical research paper. For this assignment, you’ve been assigned a topic (see below). You’ve also been assigned to a specific group (see Groups in Blackboard). Each member of the group is to find five UNIQUE references. These references are to be scholarly papers, not wiki, blog, or Website entries. Do not include textbooks or trade publications either. The use of Google Scholar is STRONGLY recommended. IMPORTANT: To support your research journey, read the Levy & Ellis (2006) article on how to maximize your research opportunities in Information Systems Research. (5 to 6) entries. Your assigned topic is as follows: Context-Aware Computingarrow_forwardQ : Draw an ERD from the following business rules: Use proper notations for the type of attributes. A software system is to be developed for an educational institute. The software is intended to be used by faculty members, students and designated support staff. System administrator will also use system for system administration and management. Student’s data including names, registration number, cell numbers and address will be added and edited by Clerk. The data will be added at the time of student reporting at campus. Student can enroll into any course of their choice from the offered courses. They can also request for dropping a course. Approval of course dropping of a student will be granted or refused by academic coordinators.arrow_forward
- Review: Entity-Relationship (ER) "crow-feet symbol" О Опе-to-manпy: one sale person can Salesperson have many Serves Мапy-to-many customers Entity-Relationship (ER) Diagram for a Customer Places Customer Order Database urayram Tor a customer order database Includes Line Specifies Orders Product items Development of ER diagrams helps ensure that the logical structure of application programs is consistent with the data relationships in the Generates One-to-one relationship Invoice database. © 2013-2019 Cengage learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use. TBC: Instructions: Draw One integrated ER diagram on slide # 28 to show the relationships of the below tables Each 'student-profile' has many 'student- financials' 1. 2. Each 'student-profile' can take many 'student-courses' 3. Each…arrow_forwardDraw EER diagram based on these business rules Customers can only make a reservation for themself and their invited guests. A customer may not make a reservation for other people including such as reselling rooms. A customer cannot use Park Hyatt website to reserve room related to any commercial activity. A customer need to provide the ID card or passport. A customer must check-in after 4 p.m. A customer must check-out before 12 p.m. A customer may select room before do the reservation. A customer can do online payment by credit card or pay while during check-in. A staff must check the customer ID card or passport.arrow_forwardDATABASE MANAGEMENT Design an EER diagram for a database used to manage a racket sport association (for example, US Tennis Association). The following is a list of simplified requirements. Each member of the sport association has an id, a name, sex, age, an address, a phone number. A member can be a player, an umpire (i.e., referee), a coach, or an officer (i.e. a member can belong to one or more of the above categories). An umpire has a type (i.e., national, international, etc.). A coach has a certificate (i.e., level I, II, etc.). An officer has an office (i.e., a room number such as 101 or 212 in the main building). Each club has a name, an address, an owner, and a phone number. Except for some officers, every member belongs to one or more clubs (Hint: Make relationships between the subclasses of “member” and club). A player can be a professional or an amateur (but not both). A professional player has a rank (such as 1, 2, etc. within the association), and a coach (Note: Every…arrow_forward
- MOUNTAIN ADVENTURE: WHITE WATER AND CAMPING SUPPLIES (NETWORKED COMPUTER SYSTEM AND MANUAL PROCEDURES) MOUNTAIN ADVENTURE is a Montana-based wholesaler of rafting and camping equipment that serves outdoor sports camping retailers throughout the northwest. You have been hired by MOUNTAIN ADVENTURE to evaluate their processes, risks, and internal controls. The following paragraphs describe Outdoor Adventure’s revenue cycle procedures. Revenue Cycle SALES ORDER PROCESSING PROCEDURES. Customer orders are mailed or e-mailed to the sales department. When the order is received the sales clerk checks the customer’s creditworthiness from a computer terminal by running a validation application. The credit-check program determines if the customer’s account is up-to-date regarding payments and the customer has not exceeded his or her credit limit. Computer controls in the application prevent further processing of any transactions that fails the credit check. Under certain extenuating…arrow_forwardEach department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used. A course is assigned a unique course code and a module is identified by a unique module code. A module can be used in one course only, but can be studied by many students. In addition to the module code each module unique title, start date, end date, texts (books), and assessment scheme (i.e., coursework and exam marks percentages) are also stored. Each course is managed by a member of academic staff, and each module is coordinated by a member of academic staff also. The database should also store each course unique title, and duration (in years). A student can enroll in one course at a time. Once enrolled a student is assigned a unique matriculation number. To complete a course, each student must undertake and pass all the required modules in his/her course. This requires that the database store the…arrow_forwardExercise 3: school system Each subject is owned by a department and each department is managed by a teacher, called Head of Department (HOD). Each department has a name and a unique code number. Each subject has a name, unique number and credit value. All teachers have a unique ID. A HOD cannot manage more than one department at a time. Also, a HOD does not teach subjects. A subject cannot be taught by more than one teacher. Finally, the system needs to know each student's contact details, including, full ID, address, age and gender, as well as date of enrolment in the subject. name, studentarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning