Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 2, Problem 16P
(a)
Explanation of Solution
The business rules for the MegaCo Corporation’s divisions are as follows:
- Each department has many employees but each employee works for only one department.
- Each department is managed by one employee and each employee can manage only one department at a time.
Crow’s Foot ERD:
(b)
Explanation of Solution
The business rules can be written as follows.
- A customer can download many e-books from Books Online and each of the books can be downloaded by many customers.
Crow’s Foot ERD:
(c)
Explanation of Solution
The business rule is an airline can be assigned to fly many flights but each flight is flown by only one airliner.
Crow’s Foot ERD:
(d)
Explanation of Solution
The business rule for “KwikTite” Corporation is as follows.
- Each factory is located in a region and each region can be a home for many factories.
- Each factory employs many employees but each employee is employed by only one factory.
Crow’s Foot ERD:
(e)
Explanation of Solution
The business rule is an employee may have earned many degrees and each degree may have been earned by many employees.
Crow’s Foot ERD:
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Question : Draw the EER diagram that describes the following scenario: ( PLEASE EXPLAIN STEP BY STEP AND IN DETAIL)
We want to design a database for keeping track of information about votes taken is the PAKISTAN PROVISIONS in the current administration. They include the PARLIAMENT and the SENATE. A MINISTER in the PAKISTAN is either a Parliament Member or a Senator depending on to which body they are elected to. The database needs to keep track of each PAKISTAN CITY’s Name (e.g., ‘Lahore’, ‘Karachi’, ‘Multan’) and include the Region of the country to which the city belongs (whose domain is {‘Punjab’, ‘Sind’, ‘KPK’, ‘Baluchistan’}) and its population in the 170 million. Each MINISTER is described by his or her Name, plus the District represented, the Start_date when the parliament was first elected, and the political Party to which he or she belongs (whose domain is {‘PPP’, ‘PTI’, ‘PML(N)’, ‘PML(Q)’, ‘ANP’, ‘MQM’, ‘Independent’, ‘Other’}). A city can have a number of parliament…
Create a Crow’s Foot ERD for each of the following descriptions. (Note: The word many merely means “more than one” in the database modeling environment.)a. Each of the MegaCo Corporation’s divisions is composed of many departments. Each of those departments has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of those managers can manage only one department at a time.
Draw ER (or EER) diagram: A conceptual database design for a chain of furniture stores is needed. The following is a summary of the database requirements:
a) The chain has many different stores in various cities and states. Each STORE has unique StoreNumber, plus an Address(made up of Street, City, State, ZipCode), and a StoreManager (who is an employee). Each store is organized into a number of departments.
b) Each DEPARTMENT contains certain types of furniture (such as ‘dining’, ‘living room’, ‘bedroom’, ‘office’, etc.), and has a DeptName that is unique within each store; it also has a DeptManager (who is an employee), and a number of SalesPersons (who are employees).
c) The company employs many employees. Each EMPLOYEE has a unique SSN, plus a Name (made up of FirstName, Minit, LastName), a job (e.g. ‘store manager’, ‘dept manager’, ‘sales associate’, ‘sales person’, etc.), plus DateOfBirth, Sex, Salary, and CommissionRate. Each employee works for a particular store.
Design an ER…
Chapter 2 Solutions
Database Systems: Design, Implementation, & Management
Ch. 2 - Prob. 1RQCh. 2 - What is a business rule, and what is its purpose...Ch. 2 - How do you translate business rules into data...Ch. 2 - Prob. 4RQCh. 2 - Explain how the entity relationship (ER) model...Ch. 2 - Prob. 6RQCh. 2 - Prob. 7RQCh. 2 - Prob. 8RQCh. 2 - Prob. 9RQCh. 2 - Prob. 10RQ
Ch. 2 - What is a relationship, and what three types of...Ch. 2 - Give an example of each of the three types of...Ch. 2 - What is a table, and what role does it play in the...Ch. 2 - Prob. 14RQCh. 2 - Prob. 15RQCh. 2 - Prob. 16RQCh. 2 - Prob. 17RQCh. 2 - Prob. 18RQCh. 2 - Prob. 19RQCh. 2 - Prob. 21RQCh. 2 - Prob. 22RQCh. 2 - Prob. 1PCh. 2 - Prob. 2PCh. 2 - Prob. 3PCh. 2 - Prob. 4PCh. 2 - Prob. 5PCh. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Prob. 7PCh. 2 - Prob. 8PCh. 2 - Typically, a hospital patient receives medications...Ch. 2 - Prob. 10PCh. 2 - Prob. 11PCh. 2 - Prob. 12PCh. 2 - Prob. 13PCh. 2 - Prob. 14PCh. 2 - Prob. 15PCh. 2 - Prob. 16PCh. 2 - Prob. 17P
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
- Create a Crow's Foot ERD for each of the following descriptions. (Note that the word many merely means more than one in the database modeling environment.)a. Each of the MegaCo Corporation's divisions is composed of many departments. Each department has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of those managers can manage only one department at a time.b. During some period of time, a customer can download many ebooks from BooksOnline. Each of the ebooks can be downloaded by many customers during that period of time.c. An airliner can be assigned to fly many flights, but each flight is flown by only one airliner.d. 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_forwardDraw an E-R diagram for the description below. Suppose that you are asked to model a database including all pharmaceutical companies, their drugs, and all pharmacies. Each pharmaceutical company is identified by its name and has a phone number. For each drug, the trade name (e.g., Acetaminophen) and formula must be recorded. Each drug is sold by only one pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company stops production, we do not need to keep track of its products any longer. Each pharmacy has an identifier name, address, and phone number. Each pharmacy sells several drugs. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.arrow_forwardHere is the database design for the personnel data: employee(id, name, address) employeeMap(id, confidentialId) empSalary(confidentialId, salary) The role 'Clerk' would be granted SELECT, UPDATE, DELETE to employee table and granted SELECT to empSalary table. While the clerk can see salary information for any statistical analysis (e.g. average salary computation), he has no idea which employee the salary is for. The role 'Administrator' is granted rights on all three tables; using the confidentialId in the employeeMap table, she has access to salary data for individual employees too. A SQL query that the administrator can use to access all employee fields is: select e.id, e.name, e.address, es.salary from employee e inner join employeeMap m on e.id = m.id inner join empSalary s on m.confidentialId = s.confidentialId; Can you draw a database schema?arrow_forward
- Suppose 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_forwardPlease draw an Entity-Relationship diagram for the given below MOVIE database. The data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies.arrow_forwardSubject: Database Topic: EERD Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation) -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. You are required to design a database for a car championship. The requirements are as follows: In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race. Every race would…arrow_forward
- WRITE THE CODE OF MYSQL IN PYTHON Create database and tables as given below by using Python. (a) Market database (b) Vendor: vendor_id integer, vendor_name varchar, license_start date, license_end date (c) Item: item_id integer, item_name varchar, item_type varchar, previous_price float, last_sold_date date (d) Auction: auction_id integer, vendor_id integer, item_id integer, price float Choose primary and foreign keys depending on the relations in Market database design.arrow_forwardDesign an E-R Diagram for the following scenario. A relational database is to be designed for a medium sized Company dealing with industrial applications of computers. The Company delivers various computer products to its customers. Some products serve generic purpose, therefore, they are sold to various customers The Company has number of employees in each department; each is specialized in one particular area (i.e. consultant, programmer, support, system analyst, developer) but each area contains many employees. For product delivery, projects are carried out in an inter-disciplinary way. The Company starts one new project for each requested product. When a project is undertaken, a team is formed by grouping employees from different departments that can share different groups An employee is also assigned as the project manager of the team who is entirely and exclusively responsible for the control of the project. An employee can manage more than one team. Teams and projects are only…arrow_forwardB. Art Museum Database Draw an EER diagram to keep track of information for an art museum. Assume that the following requirements were collected: (10 marks) The museum has a collection of art objects. Each art object has a unique ID, a year (when it was created, if known), a title, and a description. Art objects must be categorized based on their type. There are three main types: painting, sculpture, plus another type called other to accommodate objects that do not fall into one of the two main types. A painting has a paint type (oil, watercolor, etc.), material on which it is drawn on (paper, canvas, wood, etc.), and style (modern, abstract, etc.). A sculpture has a material from which it was created (wood, stone, etc.), height, weight, and style. An art object in the other category has a type (print, photo, etc.) And style. The museum keeps track of artist information, if known: name, date born (if known), date died (if not living), country of origin, epoch, main style, and…arrow_forward
- Subject: Database Topic: EERD Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation) -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. A car dealership wishes to maintain data about the customers who purchase a car. Each customer may purchase one or more vehicles and each vehicle can be purchased by many different customers over time (for example, a customer maypurchase a new vehicle, trade that vehicle in and someone else can purchase the vehicle traded in.) Data that the dealership wishes to keep regarding customers includes customer identification number, name, address, homephone, work phone, cell phone and e-mail address. Information about vehicle includes vehicle identification number, make, model, year, transmission type, engine size and color. Vehicles can be a member of one of the following categories: cars, trucks, minivans or SUVS. A vehicle can be amember of only one category at a…arrow_forwardDraw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.arrow_forwarddraw Entity Relationship Diagram (ERD) for scenairo: “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager. Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date. Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking. The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a payment, the mother needs the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase 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
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher: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: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
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning