Create an ERD for the case below: The animal shelter would like to track animals in the shelter They also want to keep track of who has adopted their animals. For all animals, they want to track: name, approximate age, health, vaccinations, spayed or neutered, whether good with children, person giving up For cats, they want to know if it's long-haired or short-haired. For dogs, they want to know the breed and the size: small, medium, or large. For animal adopters, they want to track address, phone number, email, dog/cat preference, and number of children in the household For non-adopters who would like to receive the newsletter, they track name, address, email, and phone number. They want to track which cage an animal is in. They want to send only dog information to people who like dogs and cat information to people who like cats.

Create an ERD for the case below: The animal shelter would like to track animals in the shelter They also want to keep track of who has adopted their animals. For all animals, they want to track: name, approximate age, health, vaccinations, spayed or neutered, whether good with children, person giving up For cats, they want to know if it's long-haired or short-haired. For dogs, they want to know the breed and the size: small, medium, or large. For animal adopters, they want to track address, phone number, email, dog/cat preference, and number of children in the household For non-adopters who would like to receive the newsletter, they track name, address, email, and phone number. They want to track which cage an animal is in. They want to send only dog information to people who like dogs and cat information to people who like cats.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Given the following case you are to answer the two questions on the following pages. Bob’s Supply (BS) needs to keep track of the parts they have in their inventory. He wants to know the description of each part, the color of each part, how many of each item is in stock [QOH], and how much each part costs him. BS also needs to keep track of who supplies each part, the supplier’s name, contact person, and telephone number. We know that each part in inventory has only one supplier, but some suppliers supply multiple parts to BS. Bob wants each part and each supplier to have assigned an identifying number. 1. Identify the tables needed to design the database and the fields [attributes] needed for each table and the role or function that some attrIbutes take on. 2. Create the database design for this case below using an Entity-Relationship Diagram.
Please solve this one I need help: Auto Workshop is a vehicle service centre located in the city ofMuscat, which provides vehicle maintenance/repair services.The charges of vehicle maintenance/repair are based on the type of theservice.Details of charges are as follow:Basic Tuning: 50 OMRSoftware Re-installation: 60 OMRParts Replacement: 100 OMRBody Paint: 120 OMRThe workshop offers 10% discounts to the customers who have membershipof the service centre.You are required to draw a flow chart diagram and write a C++ computerprogram that takes customer’s name, car plate number, membershipstatus(Y/N) and the required service (mentioned above). The programoutputs the input data and maintenance charges based on the serviceprovided by the service centre with discount, if applies.
Consider a student club or organization in which you are a member (or any other type of group or even a team). What are the entities of this club/team/etc.? List and define each entity.
Identify main keys, foreign keys, characteristics, and cardinalities given the following businessrules. Consider the following relationship strengths (weak/strong):There are several schools inside a university. Each school has a number of departments, each of which belongs to only one school. Each department should be assigned one or more professors, with each professor teaching no more than two courses. For all academics, the university wants to keep track of the following information: professor number and full name. All courses are divided into two groups: Technology and Fashion
please choose the most correct anwser.
Question 1: Case Description INU Printing Press, a part of a university undertakes printing jobs from different departments of the University. The press can take printing related orders from other organizations or individuals also, but this is a rare practice. Orders once placed cannot be canceled. Any financial transactions of the various departments with the printing press are done through the University Office only. The University Office maintains the accounts of the press and the various departments of the University. The press acquires its inventory from outside suppliers. This is done by accepting the quotations from various suppliers and placing orders respectively. They maintain information of vendors / suppliers for the raw materials. A supplier can supply more than one item and an item can be supplied by more than one supplier. The supplier may supply the item in parts. Stock for a particular item can be acquired more than once in a year. The suppliers send two copies of…
The core of a library information system includes the following tables. Books(bid,author,title,publisher,year)Members(mid,name,surname,street,city,phone)Borrow(bid,mid,period,date) Task 1: Select the SQL statement that prints the names and surnames of members that borrowed in this year at least one book published in 2020. a.select name,surname from Members m, Borrow r where m.mid=r.mid and r.date>="1/1/2022" and r.bid in (select bid from Books b where b.year=2020) b.select name,surname from Books b, Borrow r, Members m where m.mid=r.mid and r.date>="1/1/2022" and b.year=2020 c.select name, surname from Members m, Borrow r where m.mid=r.mid and r.date>="1/1/2022" and exists (select bid from Books b where b.year=2020) Task 2: Select the SQL statement that prints authors and titles of books from the publishers "Books" and "Literature" that have been published in 2022. a. select author, title from Books b, Borrow r where year=2022 and publisher="Books" or…
Use the ER Diagram shown on Figure 1 to answer question 9: 9. According to the ER diagram on Figure 1, which of the following is true? A) For each employee, we will keep track of either the employee name or the unique employee ID. B) For each department, we will keep track of either the unique department ID or the department location. C) Each employee reports to exactly one department. A department may have many employees reporting to it, but it does not have to have any. D) None of the above. Answer: EmpID EmpName EMPLOYEE Reports To Figure 1 DeptID DeptLocation DEPARTMENT
SQL Database In each step, represent your answer using the shorthand representation and a diagram. Adventure Tours is considering offering outdoor adventure classes to prepare people to participate in hiking, biking, and paddling adventures. Only one class is taught on any given day. Participants can enroll in one or more classes. Classes are taught by the guides that Adventure Tours employs. Participants do not know who the instructor for a particular class will be until the day of the class. a) For each participant, list his or her number, last name, first name, address, city, state, postal code, telephone number, and date of birth. b) For each adventure class, list the class number, class description, maximum number of people in the class, and class fee. c)For each participant, list his or her number, last name, first name, and the class number, class description, and date of the class for each class in which the participant is enrolled. d)For each class, list the class date,…
Question 13 sum .Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Give employee Id, name, and date hired of the managers who have the highest experience (years employed) order by employee name. If there is more than one employee with the highest experience, show all. Q1.2 : Give all manager names and date hired for managers whose work experience is higher than the work experience of their employees. List results in managers' name order. Q1.3: List Material ID and Product Id in which the Material has the highest quantity required for this material. List results in order of Material ID. Q1.4: For products that have used materials, show the product ID, product description, material ID, and quantity required of materials whose quantity required is higher than the average quantity required for that material. Sort the results by product ID and then by material ID
Does this ERD make any sense? Does it have 1NF, 2NF and 3NF? Business Rules Teacher:Teacher can teach one or more classes.Teacher checks attendances and each attendedance record belongs to a teacher of that class.Teacher may or may not contact parents of student. Parent:Parent can enroll at least one student.parent may or may not be contacted by teacher.parent can contact any teacher in the school. Student:Students must take at least classesEach student can only have one primary contact parent.An attendance keeps track of students. School:School assignes classes.Classes are assigned by a school Class:A class must be taken by at least one student.More than one classes can be taught by a teacher.Classes are assigned by a school. Attendance:Attendances are checked by a teacher to keep record of students.Student take attendances.attendance keeps track of each student.