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
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
- Read the following scenario then solve the questions:The keepers in an animal park look after the feeding of the animals. Each animal is located in a differentarea of the park. Each area has its own keeper who reports to the head keeper.The head-keeper maintains a record of the sorts of food that each animal species or type in the park shouldbe fed, and in what quantities. There is no distinction made between different animals of the same species.The keepers access the information so they know what to feed each animal type. Each animal type may begiven more than one type of food, and each type of food may be fed to a number of animal types. Eachday the keepers will take out the food needed for the animals in their care and record this on theinformation system. These food types can be perishable or non-perishable according to their shelf life. Forexample, fresh fruit and vegetables would be perishable where tinned produce or cereals would beconsidered to be non-perishable.The office…arrow_forwardRead the following scenario then solve the questions:The keepers in an animal park look after the feeding of the animals. Each animal is located in a differentarea of the park. Each area has its own keeper who reports to the head keeper.The head-keeper maintains a record of the sorts of food that each animal species or type in the park shouldbe fed, and in what quantities. There is no distinction made between different animals of the same species.The keepers access the information so they know what to feed each animal type. Each animal type may begiven more than one type of food, and each type of food may be fed to a number of animal types. Eachday the keepers will take out the food needed for the animals in their care and record this on theinformation system. These food types can be perishable or non-perishable according to their shelf life. Forexample, fresh fruit and vegetables would be perishable where tinned produce or cereals would beconsidered to be non-perishable.The office…arrow_forwardRead the following scenario then solve the questions:The keepers in an animal park look after the feeding of the animals. Each animal is located in a differentarea of the park. Each area has its own keeper who reports to the head keeper.The head-keeper maintains a record of the sorts of food that each animal species or type in the park shouldbe fed, and in what quantities. There is no distinction made between different animals of the same species.The keepers access the information so they know what to feed each animal type. Each animal type may begiven more than one type of food, and each type of food may be fed to a number of animal types. Eachday the keepers will take out the food needed for the animals in their care and record this on theinformation system. These food types can be perishable or non-perishable according to their shelf life. Forexample, fresh fruit and vegetables would be perishable where tinned produce or cereals would beconsidered to be non-perishable.The office…arrow_forward
- The Department of Academic Advising at the College of Computing and Informatics (CCI) would desire to have a database system to keep track of students details such as study plans, college’s academic advisors, and counselling services. Read the following paragraph to answer the given question. In the proposed E-Counselling System (ECS), any academic advisor can advise from 20 to 25 students registered under his/her name. However, any student has only one academic advisor. In addition, any student can submit up to three complaints. Every submitted complaint by the student is assigned to one staff member to handle it until being resolved. Moreover, every staff member in the Department of Academic Advising can handle not more than 5 complaints. The academic advisor should conduct two meetings in each semester to all students assigned to him/her. However, the student should join at least one of the two meetings, otherwise, further actions will be taken. To organize an advising meeting,…arrow_forwardRead the following scenario and answer the questions given bellow.• A car rental company has its offices in three major cites of the area. Acostumer once registered with the company, can avail its services from anynearby office. Every office keeps record of the vehicles, their drivers andrenting details. Salaries of administrative staff are controlled at a single sitewhile the drivers are paid (according to the services they provide) from their local office. Rates for famous tourism spots are fixed (with a slight difference for different vehicles), while other spots are charged according to the mileage covered. 1. Identify the entities involved in the database designed for thecompany.2. Draw GCS for the system.3. Give details of any of the relations replicated on more than one sitesarrow_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_forward
- Suppose that you are given the following information for the articles publications: • Each article is published in a Journal only. Article may have their own identification number, name, and any other relevant information. Articles cannot be duplicated and will be only accepted in a Journal. Journal will have their identification number, name, any other relevant information. • Authors may publish one or more articles at a time, but each article must be distinctive and published in the appropriate journal. If necessary, the author may be required to present their work at a specific conference. The details of the conference must also be recorded. A reviewer will examine an article before it is published. Each reviewer is only allowed to review two articles from the same journal. Sketch an Enhanced Entity Relationship Diagram (Chen's Model) based on the scenario above. Include all the relevant entities and you are also encouraged to add any other relevant entities to specify the…arrow_forwardDo not use any Al to do this question. Please show the diagram at the end. Question Lekker Living is a new backpackers that recently opened close to Stellenbosch. They have a limited number of staff (including a receptionist, a cook, and a housekeeper) since they have limited rooms available. If foreign travelers are looking for a place to stay a few nights while exploring the wonderful wine farms and hiking trails in Stellenbosch, they need to check availability on the website. If there is space, they must call reception to book a room. Orice they arrive, they check in at the front desk. In the evenings, they have the option to enjoy an assortment of dishes, prepared by a cook. Guests can also request for the room to be cleaned by a housekeeper in the mornings, while they are out and about exploring. Once their stay is over, they can check out with the receptionist. If a guest can no longer make their stay, they have the option to cancel their booking 24 hours before. Draw the use…arrow_forward1. 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_forward
- In a PhD program, students join a particular specialization offered by a department. Aspecialization with same title (e.g., DBMS) may be offered by one/more depts independently. Teachers are appointed to a specific department and given a room and telephone. Each department should have a teacher who serves as its head. Courses are offered under various specializations. A teacher may teach many courses and a course may be taught by many. A student studies a course under a teacher during some semester (e.g., semester 1 of 2019), and is awarded a grade. At eacher’s research interest may lie in one/more specializations. Courses have one/more/zerop prerequisites Construct an E-R diagram for the above specification. Document all assumptions. Please don't copy answer form internet..i will give negative feedbackarrow_forwardCreate 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.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
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