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 solution
Students have asked these similar questions
create an ERD for given scenario
In the current pandemic era, many organizations have been established to collect the donation and provide aid to Covid patients. Let's consider the below scenario related to the same organization:
An organization Fighting Covid is established to get donations from the donors for providing various food, medicine, study-related aid to required people. This organization is expanding widely and needs a proper database model to store its donors, donations, and expenses. A donor may make many donations and a donation is used in many helping works e.g. providing medicine to a particular hospital.
While donating, a donor may mention the area in which the donation should be used which can be multiple e.g. a donor wants 50% to be used in medical help and 50% to be used to provide food to needy people.
The Many to Many relationship is between donation and help area as an area (e.g. food) will have many donations and a donation will have none or many areas…
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…
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate for one case study.1. Two-Bit Drilling Company holds information about employees and their insurance dependents. Every employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be connected with one and only one employee. Some employees will not have dependents, while others will have many dependents.
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
- Explainarrow_forwardSuppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.arrow_forwardConsider the following scenario and draw an E-R diagram for Mozar. Mozar has decided to store information about musicians who perform on its albums (as well as other company data) in a database. Each album that is recorded on the Mozar label has a title, a copyright date, a format (e.g., CD or MC), and an album identifier. Each album has a number of songs on it, but no song may appear on more than one album.Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course. Each musician that records at Mozar has a SerialNo, a name, an address, and a phone number. Each address is made up of a street, a city and a postcode. Each musician may play several instruments, and a given instrument may be played by several musicians. Each instrument that is used in songs recorded at Mozar has an instrumentID, name (e.g., guitar, piano, flute) and a musical key (e.g., C, B-flat, E-flat). Each song is performed by one or more musicians, and a musician…arrow_forward
- 1. Which of the studied data structures in this course would be the most appropriate choice for the following tasks? And Why? To be submitted through Turnitin. Maximum allowed similarity is 15%. a. A training institute needs to maintain a database of 2000 identification numbers of trainees who received an ICDL certification. The goal is to find rapidly whether or not a given ID is in the database. Ordering information among the identification numbers is not important; speed of response is very important; efficient use of memory is also important, but not as important as speed of response. b. A large fixed content of data needs to be maintained. It is sorted and the admin needs to search for and retrieve existing items, but no new/existing items will be inserted/deleted. You may assume that the data can fit inside the memory of the computer. c. A transposition table is a cache of previously seen positions in a game tree generated by a computer game playing program. If a position recurs…arrow_forwardA 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.arrow_forwardThe readers and writers dilemma may be posed in a number of different ways, depending on the order in which different categories of activities might be initiated. Speculate on three potential permutations of the issue, each of which may favor one set of procedures over another. Describe in detail the behavior of each variant when a reader or writer is ready to access the database and after a procedure has finished.arrow_forward
- Let the Clinical Information Systems Security have the following functions: create_record, delete_record, read_record, append_to_record, add_to_acl, and move_from_record_to_record. Given these, show that the Clinical Information System model's principles implement the Clark-Wilson enforcement and certification rules. How do we prove the system implements the Clark-Wilson model? Given the principles (access, creation, deletion, etc.) of the clinical system that has the same components (IVPs, TPs, etc.), we need to justify that each of the CRs and ERs is implemented.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_forwardAs a large service organization, King Abdullh University Hospital depends on a large number of persons for its continued success. There are four groups of persons on whom the hospital is most dependent: employees, physicians, patients, and volunteers. Of course some common attributes are shared by all of these persons: Person_ID (identifier), Name, Address, Ciy/State/Zip, Birth_Date, and Phone. Each of the four groups of persons has at least one unique attribute of its own. Employees have a Date_Hired, Volunteers have a Skill, Physicians have a Specialty and a Pager# (pager number), and Patients have a Contact_Date (date of first contact with the hospital). Some other persons in the hospital community do not belong to one of these four groups (their numbers are relatively small). However, a particular person may belong to two (or more) of these groups at a given time (for example, Patient and Volunteer). Each patient has one (and one only) physician responsible for that patient. A…arrow_forward
- Read 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_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_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_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