Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 3.33PAE
Program Plan Intro
Draw an ERR model for the given scenario.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Develop an EER model for the following situation using the traditional EER notation, the
Visio notation, or the subtypes inside supertypes notation, as specified by your instructor:
An international school of technology has hired you to create a database management system to
assist in scheduling classes. After several interviews with the president, you have come up with
the following list of entities, attributes, and initial business rules:
• Room is identified by Building ID and Room No and also has a Capacity. A room can be
either a lab or a classroom. If it is a classroom, it has an additional attribute called Board
Type.
• Media is identified by MType ID and has attributes of Media Type and Type Description.
Note: Here we are tracking type of media (such as a VCR, projector, etc.), not the
individual piece of equipment. Tracking of equipment is outside the scope of this project.
• Computer is identified by CType ID and has attributes Computer Type, Type Description,…
Please written by computer source
Part I - Modeling You are building a database for a comic book store customer management system. Given the database specification below, your job is to turn the specification into an ER diagram. Your notation must be consistent with the notation used in our lecture notes. You can use all constructs and notations discussed in our lecture notes and nothing else (i.e.. oven notations used in the textbooks but not in our lectures cannot be used). Your ER diagram should capture all the information and constraints in the specification but, at the same time, be minimal. It means that redundant entities, relationships, attributes and constraints should be avoided. You may use any drawing tool of your choice (for example, Dia, diagrams.net, Lucidchart, etc.) to draw your ER diagram. Hand drawings will not be accepted. Database Specification The database keeps information about comic books, customers, orders, inventory and reviews. First, the database should…
Develop an EER model for the following situation using EER notation, as specified by your instructor.
An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules:
• Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type.
• Media is identified by MType ID and has attributes of Media Type and Type Description. Note: here we are tracking type of media (such as a DVD, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside of the scope of this project.
• Computer is identified by CType ID and has attributes of Computer Type and Type Description, Disk Capacity, and Processor Speed. Please note: as with Media Type, we are tracking…
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
Similar questions
- Using a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardThe ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.arrow_forwardWrite the proper sequence of activities for the design of a video rental database. (The initial ERD was shown in Figure 9.9.) The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the videos to the customers. After you finish writing the design activity sequence, complete the ERD to ensure that the database design can be successfully implemented. (Make sure that the design is normalized properly and that it can support the required transactions.)arrow_forward
- Draw ER (or EER) diagram: A conceptual database design for a chain of furniture stores is needed. The following is a summary of the database requirements: a) The chain has many different stores in various cities and states. Each STORE has unique StoreNumber, plus an Address(made up of Street, City, State, ZipCode), and a StoreManager (who is an employee). Each store is organized into a number of departments. b) Each DEPARTMENT contains certain types of furniture (such as ‘dining’, ‘living room’, ‘bedroom’, ‘office’, etc.), and has a DeptName that is unique within each store; it also has a DeptManager (who is an employee), and a number of SalesPersons (who are employees). c) The company employs many employees. Each EMPLOYEE has a unique SSN, plus a Name (made up of FirstName, Minit, LastName), a job (e.g. ‘store manager’, ‘dept manager’, ‘sales associate’, ‘sales person’, etc.), plus DateOfBirth, Sex, Salary, and CommissionRate. Each employee works for a particular store. Design an ER…arrow_forwardThe ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Complete the table to define all of the entities and relationships. First one is done for you. Consider one of the relations as a composite relationship. ENTITY INSTRUCTOR RELATIONSHIP Teaches CONNECTIVITY 1:M ENTITY CLASSarrow_forwardSwing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…arrow_forward
- Q4: Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights. Your design should include a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints. Please note that an E-R diagram is not required.arrow_forwardINDICATE THE CHANGES(USING SHORTHAND REPRESENTATION) YOU WOULD NEED TO MAKE TO THE ORIGINAL KIMTAY PET SUPPLIES DATABASE DESIGN TO SUPPORT THE FOLLOWING REQUIREMENTS. A CUSTOMER IS NOT NESSESARILY REPRESENTED BY A SINGLE SALES REP, BUT THEY CAN BE REPRESENTED BY SEVERAL SALES REPS. WHEN A CUSTOMER PLACES AN ORDER THE SALES REP WHO GETS THE COMMISSION ON THE INVOICE MUST BE IN THE COLLECTION OF SALES REPS WHO REPRESENT THE CUSTOMERarrow_forwardSubject - Fundamentals to Database Question 4 An entity-relationship diagram (ERD) is a specialized graphic that illustrates the relationships between entities in a database. ERD often use symbols to represent three different types of information. Draw the ERD for the following scenario: (a) Each lecturer is identified by a uniqie number, name and phone. A lecturer teaches several courses and for each course there us a unique code and title. There might be several be several lecturers in a course. (b) A university where a student may take many courses employs lecturer. Each lecturer teach one or more course but no course is taught by more than one lecturer. Each student has to complete two or three assignments for each course. (c) A car rent company wishes to create a database about its activities. The company has a number of vehicles. Each vehicle is of certain model. A customer can rent only one vehicle at a time. Every vehicle must be checked by an employee to make sure it is in…arrow_forward
- Also Draw Schema Diagramarrow_forwardDesign a database for an airline. The database must keep track of customers and theirreservations, flights and their status, seat assignments on individual flights, and the scheduleand routing of future flights. Your design should include an E-R diagram, a set of relationalschemas, and a list of constraints, including primary-key and foreign-key constraints.arrow_forwardCreate a database schema design based on the following (simplified) requirements of the COMPANY Database: 1. The company is organized into DEPARTMENTs. Each department has a name, number and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. 2. Each department controls a number of PROJECTs. Each project has a name, a unique number, and a brief description. 3. We store each EMPLOYEE's social security number, address, salary, gender, and birthdate. a) Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department. b) We keep track of the number of hours per week that an employee currently works on each project. c) We also keep track of the direct supervisor of each employee. 4. Each employee may have a number of DEPENDENTs. a) For each dependent, we keep track of their name, gender, birthdate, and relationship to the employee. We…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
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
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
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
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning