Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 2.46PAE
Program Plan Intro
An ER diagram for the given situation with the given requirements based on Lapowsky (2016).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Consider the following College and perform the task that follows.Ocean Sound College, a liberal arts college located on the West Coast, provides dormitory housing for approximately half of its students. Students who choose not to live on campus, or who do not get assigned dormitory space, must find housing in the surrounding community. Currently, the housing office uses a cumbersome system of multiple binders to keep track of housing opportunities for students, faculty, and staff of the college. Housing listings are for college-owned housing, housing owned by private parties including landlords and individuals looking for roommates. The current system is difficult to maintain and keep up-to-date. The new college president approved a request to fund the development of a system to provide easier access and maintenance of listings. You are the systems analyst assigned from the college IT department to conduct the initial investigation into the feasibility of such a system. The preliminary…
Create a Crow's Foot ERD for the following description:
The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of KwikTite's factories. Each factory has many employees, but each employee is employed by only one factory.
A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company.
Draw an ER diagram that captures this information.
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...
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 the E-R diagram for the above, providing the degree and cardinalities Suppose a medical group XYZ wants to store information about physicians & patients. Each physician has only one specialty. Patient records are shared among the doctors. For each patient visit, information is stored about the visit type (regular office, after hours, house call, etc), a single diagnosis for that visit, and the charge. Assume that a patient may visit more than one of the doctors on a particular day. We assume, however, that a patient never visits the same doctor more than once in one day. Draw the E-R diagram for the above, providing the degree and cardinalitiesarrow_forwardA public sector hospital wants to automate its manual paper based operations to speed up the operations and facilitate its patients and staff members. For this purpose, they want to develop a database for their hospital management system to remove paper based records. Now, you are required to analyze the following scenario very carefully and draw entity relationship diagram (ERD) for the given system by identifying entities, attributes and relationship among these entities. A hospital consists of various specialized wards where each ward has its unique ID, name and capacity (total number of beds for patients in each ward). Multiple patients can be admitted in each ward on the recommendations of the doctor. Each doctor has a unique id, name, specialization and etc. Furthermore, a specialized team of doctors in each ward will take care of admitted patients and suggest treatment for the patients (such as medication, recommended tests, date of admission, and date of discharge). Each ward…arrow_forwardA firm of solicitors wishes to develop an expert system for use by its customers. Competing firms of solicitors only provide telephone or face-toface advice. The solicitors would be responsible for entering the knowledge data and for answering any queries beyond the scope of the new expert system. The firm broadly agrees with this approach but is concerned that its reputation could suffer if the expert system gives the wrong advice. As an independent consultant brought in to advise the firm of solicitors a) Describe how this expert system differ from conventional systems and discuss the various stages of knowledge acquisition in this expert systemusing practical examples. CR(10)b) Explain five methods of acquiring, analyzing and modeling knowledge in this system. EV(5)c) Identify and describe five important issues in knowledge acquisition forthis kind of a system.arrow_forward
- A derived attribute can be stored in a table or calculated on each occasion that it is required. An example of a derived attribute is your Grade Point Average which is calculated by adding together a score for each unit (e.g., HD=4, D=3, C=2, P=1, N=0) and dividing that by the number of units you have completed. Explain how the decision as to whether the Grade Point Average would be stored in a table or calculated would be made. You are administering a database in a large retail company that records sales at each of the company’s stores. Tuning the database to improve performance by adding indexes and optimising query execution is an important ongoing aspect of the physical database design. Which attributes in a database such as this (apart from the primary key) are likely to BENEFIT from being indexed? Which attributes would you generally avoid indexing, and why?arrow_forwardA well-structured database starts from an effective Entity Relationship Diagram (ERD). For this part of the question, you will need to sketch an ERD for the following gym scenario: A member must have a member ID, name and contact number, can be enrolled in one or more gym session. A gym session can be enrolled in by one or more members. Each gym session is identified by a session ID, and has a name, date and instructor details (Instructor ID). An instructor has an instructor ID, name and contact number, and must only be assigned to one gym session. A gym session can have one or more instructors assigned in it.” *show entities, relationship types and cardinalities. Crow’s foot model notations recommended.arrow_forwardRead carefully the following case:Imagine that you work as an internal auditor for a company that owns several pharmacies throughout the city. Based on your audit plan, the first cycle to audit will be revenue. The first thing you do is document the processes related to receiving and processing the various sources of income. On your initial visit, you were able to observe the following:Once customers have the items to purchase, they head to the register, where a clerk processes the sale. The pharmacy has three cash registers, but does not have an employee who specifically works as a cashier at each one. This provides flexibility in the operation because, of the three employees that the business has, one can collect at any of the cashiers when available. By not having to leave a single person as a cashier, the cashier can focus on providing more direct customer service, refilling merchandise on the shelves, and even assisting in receiving or dispatching merchandise from the store.At the…arrow_forward
- Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and certification renewal date should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.arrow_forwardGiven the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and certification renewal date should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents. Please give reasoning for any selection that you make. Providing only ERD is not enough.arrow_forwardGiven the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and certification renewal date should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.arrow_forward
- Please give a step-by-step answer. The ER Diagram must contain the ER-Diagram Symbols. Design an EER diagram for a Hospital Management System. The hospital wants to keep track of all their doctors, nurses, other staff, wards, patients and appointments. They have hired you to help them design the database for that purpose. You can design your EER as you wish, but it must satisfy the following constraints: a) there should be at least one disjoint-total specialization/generalization. b) There should be at least five regular/strong entities [excluding subclasses] c) There must be a weak entity d) There must be at least one M:N relationship. e) There must be at least one derived attribute.arrow_forwardIn Chapter 3 of Sharma et al. (2010), you will be introduced with a case study: "This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms: The system will manage the author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The author's information includes name, address, and e-mail. New books, authors and clients are entered into the system. When a client checks out a book, the system will register the date the book was loaned and calculate the days the book can be loaned. It will also calculate the date the book is due to be returned. If the borrower returns the book late, he must pay a fine based on the number of days overdue." (Sharma, et al., 77). Assume that the traditional file system is currently used in this library and a DBMS is to be developed. Discuss the advantages and challenges for the use of…arrow_forwardDraw an ER diagram that captures the following information: A book identified by (unique Id number, a title and one or more authors), A library identified by (unique name and adders), A borrower has a name and a unique ID code. The library service may own several copies of a given book. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date. *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 EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable 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