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.23PAE
A cellular operator needs a
Can a customer have an unlimited number of plans?- Can a customer exist without a plan?
- Is it possible to create a plan without knowing who the customer is?
- Does the operator want to limit the types of handsets that can be linked to a specific plan type?
- Is it possible to maintain data regarding a handset without connecting it to a plan?
- Can a handset be associated with multiple plans?
- Assume a handset type exists that can utilize multiple operating systems. Could this situation be accommodated within the model included in Figure 2-24?
- Is the company able to track a manufacturer without maintaining information about its handsets?
- Can the same
operating system be used on multiple handset types? - There are two relationships between Customer and Plan. Explain how they differ.
- Characterize the degree and the cardinalities of the relationship that connects Customer to itself. Explain its meaning.
- Is it possible to link a handset to a specific customer in a plan with multiple customers?
- Can the company track a handset without identifying its operating system?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A cellular operator needs a database to keep track of its
customers, their subscription plans, and the
handsets (mobile phones) that they are using. The E-
R diagram in Figure 2-24 illustrates the key entities
of interest to the operator and the relationships
between them. Based on the figure, answer the
following questions and explain the rationale for
your response. For each question, identify the
element(s) in the E-R diagram that you used to
determine your answer. a. Can a customer have an
unlimited number of plans?
b. Assume a handset type exists that can utilize
multiple operating systems. Could this situation
be accommodated within the model included in
Figure 2-24?
c. Is the company able to track a manufacturer
without maintaining information about its
handsets?
d. Can the same operating system be used on
multiple handset types?
e. There are two relationships between Customer
and Plan. Explain how they differ.
Create an ERD Diagram with all the relationships based of this:
The city of California has just established its criminal justice/police department. You and your team have been assigned the task of creating a database system for the department. The database should be able to store and manage information about the department's workers, their roles, medical records, and incidents that occurred under the department's jurisdiction. This includes information about the investigator(s), the offender(s), the evidence, and the judicial proceedings, such as the trial details, the presiding judge, and the lawyers. The database should also be able to support the recording of punishments, such as sentencing time, fines, and warnings.
Design a representation of the data in terms of entities , attributes and relationships between entities . Construct an E - R diagram to depict this representation . Show the cardinalities and all necessary information . Draw the solution on a piece of paper . Add your name and Upload you file here . You are asked to design a database for a sales company which needs to keep track of its sales orders in addition to employees ' information . 1- The company has salespersons . For each Salesperson , we need to know his ssn , name , date of start at work , address and phone number.2- A sales person plays the role of an agent for customers.3- A customer has only one agent , but the same salesperson can be an agent for several customers . Customers are identified by their emails . The company also stores a customers ' name , address , phone number and birthdate . 4- Customers place orders . Each customer can place many orders . 5- Orders are identified by their serial number , issuance date…
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
A nozzle at A discharges water with an initial velocity of 36 ft/s at an angle with the horizontal. Determine ...
Vector Mechanics For Engineers
Why is the study of database technology important?
Database Concepts (8th Edition)
17–1C A high-speed aircraft is cruising in still air. How does the temperature of air at the nose of the aircra...
Thermodynamics: An Engineering Approach
What is the importance of modeling in engineering? How are the mathematical models for engineering processes pr...
HEAT+MASS TRANSFER:FUND.+APPL.
How does a computers main memory differ from its auxiliary memory?
Java: An Introduction to Problem Solving and Programming (8th Edition)
What is an uninitialized variable?
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
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
- Draw a clear and complete ER diagramarrow_forwardDesign ER diagram to model the online bookstore’s database, in which there are four entities, namely books, authors, publishers, and customers entities. Every book has an author and a publisher. Customers can order books. Information about payment, shipping, and stock of goods does not need to be included in the model.arrow_forwardDraw an entity relationship diagram ERD using unified modelling language UML nation according to the below business rules. your design should be logical level-including primary and foreign key fields and remember to remove any many-to-many relationships. 1. all entities should have surrogate primary keys. 2.A customer can place many orders over and over time and each order is placed by exactly one customer. 3.The name and surname of a customer must be stored in the database 4.The date and status of an order must be stored in the database 5.Each order cab obtain many items and each item can be part of many different orders 6.The name description and unit price of every item must be stored in the database 7.When an item is added to an order, the quality ordered and the unit price of thr item must be stored 8.Each item in the database belongs to a catagory and a catagory has many items that belong to it 9.The name of each of the categories must be stored in the databasearrow_forward
- Draw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.arrow_forwardDATABASE SYSTEM DRAWING E/R DIAGRAM AND RELATIONAL SCHEMA.Draw the ERD with appropriate mapping cardinalities for mail order database in which employees, each identified by unique employee number, first name last name and ZIP code. Employee are categorized as manager, clerk ad delivery staff. Each customer of the company is identified by a unique employee number, first and last name and ZIP code. Each part sold by the company is identified by unique part number, part name, price and quantity stock. Each order placed by a customer is taken by a clerk and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded. The delivery boy places the order of specified customers. There is a provision of replacing one or many fault parts to the customer but before that it must be verified by the manager.arrow_forwardCreate an ER diagram based on the picture thank uarrow_forward
- Design ER Diagram for a hotel reservation database, your ER Diagram should include the following: * Hotel * Hotel Branch * Room * Customer * Employee * Supplier: supplies beds, bed sheets, pillows, ... etc * Customers can reserve rooms Think of attributes and relationships that you need to have in your ER Diagram. • Your ER diagram should include entities, attributes, relationship and cardinality constraints.arrow_forwardDesign 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 an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints. Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. Consider the following set of requirements for a UNIVERSITY database that isused to keep track of students’ transcripts. The university keeps track of each student’s name, student number, Social Security number, current address and phone number, permanent address and phone number, birth date, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications…arrow_forwardWhat are the rules for choosing how to recognize and create connections between entities in the ER-Model?arrow_forward
- What is the purpose of entity-relationship diagrams? What sort of symbol is used to depict a connection, and how does it work? What exactly does the phrase "associative entity" imply and what does it mean? Give an example.arrow_forwardDraw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the following business rule for a hotel group: a. Each hotel is located in a city. Some cities may have more than one hotel, but a specific hotel can only be located in one city. The name of the hotel and the name of the city must be stored in the databasearrow_forwardFor the database design, design an Entity-Relationship (ER) diagram for the database that will support the KMS. Include key entities and relationships.pls read the content in the images below. will like the solution if i'm satisfied.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY