Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 4, Problem 9P
Explanation of Solution
Entity ER Diagram:
The following figure illustrates the ER Diagram for given business rules in Crow’s Foot notation:
Explanation:
The above Professional Electronics and Repairs (PEAR) ERD contains entities such as “CUSTOMER”, “REPAIR”, “DEVICE”, “PERFORM”, “SERVICE”, “PART” and “USES”.
- The relationship between the “CUSTOMER” and “REPAIR” entities is 1: M...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
SportTech Events.
SportTech Events SportTech Events puts on athletic events for local high school athletes. The company needs a database designed to keep track of the sponsor for the event and where the event is located. Each event needs a description, date, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor’s contact information, such as the name, phone number, and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event. Each location will need an ID, a contact person, and a phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create a Conceptual Entity Relationship Diagram from the information described above.
ER Design Exercise
as a database you need to ensure that each excercise log has a unique ID number, date, excercise category, excercise subcategory, time spent, calories burnt . each customer has unique cust_number and their first name, last name, address, program number, program tile and payment must be recorder. every program has a program number(PNum) that uniquely identifies the program. the program title, startDate, FinishDate, price must also be recorder. each coach has unique Id number. their first name, last name, date of birth, address, contactNo, username and password must be recorder. A coach can work on only one program. A program can have one or more coaches associate with it. one customer can enroll for one program at a time. normalize the above database in 3NF. State for every step in normalization which functional dependency cause it. identify different type of anomalies which can be found in a database. how can we overcome them ?
Chapter 4 Solutions
Database Systems: Design, Implementation, & Management
Ch. 4 - Prob. 1RQCh. 4 - What is a strong (or identifying) relationship,...Ch. 4 - Prob. 4RQCh. 4 - Suppose you are working within the framework of...Ch. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Discuss the difference between a composite key and...Ch. 4 - What two courses of action are available to a...Ch. 4 - Prob. 11RQCh. 4 - Discuss two ways in which the 1:M relationship...
Ch. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Briefly, but precisely, explain the difference...Ch. 4 - What are multivalued attributes, and how can they...Ch. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - What two attributes must be contained in the...Ch. 4 - Describe precisely the composition of the...Ch. 4 - Prob. 21RQCh. 4 - Prob. 1PCh. 4 - Create a complete ERD in Crows Foot notation that...Ch. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9PCh. 4 - Prob. 10PCh. 4 - Prob. 11C
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
- Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBNarrow_forwardwrite sql queries A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (e.g. animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner…arrow_forwardwrite sql queries A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (e.g. animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner…arrow_forward
- Database Foundations: Design a database to produce the following reports. Do not use any surrogate keys in your design. For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired. For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many different guides. For each client, list the client number, client last name, client first name, address, city, state, postal code, and telephone numberarrow_forwardThe Plaza is an apartment rental company that would like to create an online management system to keep track of apartment complex units, tenants, maintenance requests, and rental payment information. Since you are taking a database class, you are asked to assist the company in designing a database based on the following specifications. Each apartment unit has a unique number.Each unit's street number,street name, city, state zip code, number of bedrooms, monthly rent, and occupancy status are recorded. Each tenant must lease at least one apartment unit for a period of time. It is important to document the lease start date and end date. The Plaza tracks each tenant's name, SSN, home mailing address, and phone number. Each tenant is assigned a unique identifier number. Each tenant should pay the monthly rental fee by the first day of each month.Any rent due not paid by the 4th day of the monthly rental period is subject to a $50.00 late fee charge with an additional $10.00 for…arrow_forwardHi please help me with this database question thankyou so mucharrow_forward
- You have been hired as an intern at the local community center. The center has a number of sports programs for youth. You have been asked to create a database to keep track of the programs and the youths who participate in these sports activities. The Community Center database must support the following requirements:i. For an activity, store its number and name, for example, 051, Track. Each activity has a cost associated with it.ii. For a participant, store his or her number, first name, and last name as well as the name, home telephone number, and cell telephone number of the parent or guardian primarily responsible for the participants.iii. One participant can enroll in many activities, and one activity can include many participants. One parent/guardian can have many participants.Based on these requirements:1. Identify and list the entities and attributes of those entities. 2. Identify and list the functional dependencies. 3. Without creating a set of dependency diagrams, write the…arrow_forwardComputer Sciences Department frequent fliers have been complaining to Dane County Airport officials about the poor organization at the airport. As a result, the officials decided that all information related to the airport should be organized using a DBMS, and you have been hired to design the database. Your first task is to organize the information about all the airplanes stationed and maintained at the airport. The relevant information is as follows:• Every airplane has a registration number, and each airplane is of a specific model.• The airport accommodates a number of airplane models, and each model is identified by a model number (e.g., DC-lO) and has a capacity and a weight.• A number of technicians work at the airport. You need to store the name, SSN, address, phone number, and salary of each technician.• Each technician is an expert on one or more plane model(s), and his or her expertise may overlap with that of other technicians. This information about technicians must also…arrow_forwardThe database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.arrow_forward
- You have just been hired on as a Database Developer, and your employer has provided you with the option to make use of either a trigger or a procedure in the construction of your database. Please provide an explanation of what triggers are and when it would be most suitable to use them.arrow_forwardSQL Help This veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse should focus on recording information related to each pet visit to the hospital.For each of the visit, it is essential to record the various information represented in the previous tables about the pet, owner and treatment.It is also essential to record data about the date of the visit, including the day, month and year. Finally, the visit fee should be recorded. Note that there is no flat fee for each treatment as the treatment cost can vary depending on the pet type.Based on all these information, draw a star schema for this specific part of data warehouse focusing on recording data related to each visit.arrow_forwardQ2 Create a Database with at least 4 tables, 3 queries, 2 forms, and 1 report. Each table should have at least 10 records. for library designarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning