Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 2.35PAE
Figure 2-27 represents a situation of students who attend and work in schools and who also belong to certain clubs that are located in different schools. Study this diagram carefully to try to discern what business rules are represented.
Figure 2-27 E-R diagram for Problem and Exercise 2-35
- You will notice that cardinalities are not included on the Works For relationship. State a business rule for this relationship, and then represent this rule with the cardinalities that match your rule.
- State a business rule that would make the Located In relationship redundant (i.e., where the school in which a club is located can be surmised or derived in some way from other relationships).
- Suppose a student could work for only a school the student attends but might not work. Would the Works For relationship still be necessary, or could you represent whether a student works for the school she attends in some other way (if so, how)?
- Based on the rules of the ERD in Figure 2-27, is it possible for a student to belong to a club located in a school that the student does not attend? Explain.
- Is it possible to determine which schools do not have any of their students belonging to any club in that school? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
b. Draw an Entity Relationship diagram from each of the following descriptions. Include the attributes, primary keys (underlines) and the relationships in the diagram (like relationship in Access).
i. Each of the department has many employees assigned to it, but each employee works for only one department.
if. A customer can rent many videotapes from the video store. Each of the videotapes can be rented to many customers.
Please draw the ER diagram. Explain how you know which one is entity, attribute, and all constraints. Explain each step of the diagram.
Analyze the given entity relationship diagram and answer the following questions.
What is the degree of “has” relationship?
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...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
What are the design issues for character string types?
Concepts Of Programming Languages
Look at the following description of a problem domain:
Starting Out with Java: From Control Structures through Data Structures (3rd Edition)
A byte is made up of eight a. CPUs b. addresses c. variables d. bits
Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
Convert each of the following binary representations to its equivalent base ten form: a. 101010 b. 100001 c. 10...
Computer Science: An Overview (12th Edition)
How does a computers main memory differ from its auxiliary memory?
Java: An Introduction to Problem Solving and Programming (7th Edition)
In Problems 1 through 10, find a function y=f(x) satisfying the given differential equation and the prescribed ...
Differential Equations: Computing and Modeling (5th Edition), Edwards, Penney & Calvis
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
- Design the Entity Relationship Diagram (ERD) showing entities, attributes, primary key and relationship cardinality for the following scenario. Any employee works for only a department and under supervision of a manager (where manager is also an employee). Employee's address, city code & city name also has been recorded. Every employee may work for multiple project, but an employee may be on vacation and not assigned to any projects. Working hour may be different for an employee for different projects. Projects are broken into tasks; A task is created for one project and assigned to one department. Requisitions are made for projects; Each requisition could ask for any number of items; Items could be: equipment item or materials item and are coded in a similar way; Each requisition is for one project and is made to one supplier. The important data fields are employee_id, employee_name ,employee_address, employee_email, department_id, department_name, location, city_code, city_name,…arrow_forwardDraw an entity-relationship diagram for the following situation:Many students play many different sports. One person, called the head coach, assumes the role of coaching all these sports. Each of the entities has a number and a name. (Make any assumptions necessary to complete a reasonable diagram. List your assumptions.)arrow_forwardDraw an Entity Relationship Diagram for ther following information.arrow_forward
- You are given an E-R diagram with two entities Orders and Customers. What does the lone between the Customers entity and the Place relationship represent?arrow_forwardDraw an Entity Relationship Diagram for all of those below. Draw an ER diagram to represent information about students. A student is identified by his/her student number. Student’s name (first and last), permanent address, phone number, gender and date of birth are also stored. An airplane has a registration number, type, number of economy class seats, number of business class seats and the year of production. Some students live in student halls. Each hall has a name (unique) and an address. Each student has a number (unique) and a name. Assume that there are students living in every hall. Each text book has a unique ISBN (International Standard Book Number), and contains several chapters. Each chapter has a chapter number (unique within a book), the number of pages and the number of references. A chapter covers a single topic, but the same topic may be covered in various books. Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for…arrow_forwardaccording to this Class diagram, i need you to draw Entity–relationship diagram Note : Please this diagram contains a 3 step 1-Conceptual ER 2-Logical ER 3-Physical ER Thank you :)arrow_forward
- Prepare an E-R diagram for a real estate firm that lists property for sale. Identify all entities (supertype/subtype), attributes (optional/required), unique identifiers, relationships and relationships cardinality and optionality. Resolve any M-M relationship you find. • The firm has several sales offices in several states. Each sales office has Office_Number and a Location. • Employees are assigned to work in different sales offices. Each employee has an ID and Name. • An employee must be assigned to only one sales office. For each sales office, there is always one employee assigned to manage that office. For each manager we record the start date of the management job. • The firm lists properties for sale. Each property has an ID, description and Location. Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed. • Each unit of property has one or more owners. owners have ID and Name. An owner may own…arrow_forwardDraw a use case diagram based on the case study given below.Your diagram should contain at least 3actors, 8 use cases, and 2 include and 2 extend relationships. Shopping Made Easy System A customer uses Shopping Made Easy System for online shopping. System requires the customer to sign up and sign in to be able to interact with the system. Customer registration is verified by the administration. A customer may use the portal as a guest without signing up but is only able to view catalogues in case of a guest. A customer can manage his/her account which involves signup/sign in and profile management. A customer can browse through catalogues to view different products; customer can also search for a specific catalogue by name or code number. Customer can view the products and can log out without buying. Another main feature of the system is Shopping cart management. Customer can add or remove items in cart. Customer can check which items have…arrow_forwardDesign a system to track advance payments made to employees. Use uml diagrams and design patterns in this system. The design steps will be as follows. Step 1 - Prepare an analysis document on the given topic. Step 2 - Create a Use case diagram for your requirement that contains at least 3 actor, 10 use case and use all relationship type Step 3 - Create an activity diagram for requirement Step 4 - Create a class diagram for all requirement that contains at least 10 class, necessary relations and types. Add the important attributes of the classes to the model. Step 5 - Use three design patterns, at least one creation, one structural, and one behavioral pattern, integrated into your classroom design. Step 6 - Code one of the design patterns you use with java. Note: The design should be homogenate. Excessive usage of any property type, object type, or function type is not suitable. For example, for creating 10 relations between classes, the number of relation types for aggregation,…arrow_forward
- Consider the following entity relationship diagram. Booking Employee Room Building • Booking ID • Employee ID • Building ID • Room ID • First Name • Room ID P • Name Description • Employee ID • Name Last Name • Date • Campus Zone • Email Address • Capacity • Start Time • Map Coordinates Phone • Bookable • End Time For each statement below, use the drop-down box to indicate whether it is true (answer 1) or false (answer2), according to the design decisions encoded in the ERD. Every booking is associated with exactly one employee. ✓ Every employee is associated with at most one booking. ✓ A building may contain no rooms that are recorded in the database. Each room may have many bookings. 1. True ✓ A room must have at least one booking. 2. False ✓ A booking can be associated with many employees. An employee may have no phone number recorded. ✓ A room must have its capacity recorded. ✓ A building is uniquely identified by its map coordinates.arrow_forwardCreate an ER DIAGRAM that shows relationship between eachother and post the picture please . An Inventory entity can be associated with zero or many Beer entities. A Beer entity can be associated with one and only one Inventory entity. An Inventory entity can be associated with zero or one Brewery entity. A Brewery entity can be associated with zero or many Inventory entities. An Employee entity can be associated with one and only one Brewery entity. A Brewery entity can be associated with zero or many Employee entities. An Employee entity can be associated with zero or many Order entities. An Order entity can be associated with one and only one Employee entity. These business rules assume that a brewery company has an inventory of beers, which are brewed by one or more breweries and supplied by one or more suppliers. The breweries employ one or more employees and can receive orders for their beers.arrow_forwardConsider the following ER diagram given to you what are the possible relations you will be creating inRelational model.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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY