Bundle: Database Systems Design, Implementation, & Management, Loose-leaf Version, 13th + MindTapV2.0, 1 term Printed Access Card
13th Edition
ISBN: 9780357475188
Author: Coronel, Carlos, Morris, Steven
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 7P
Explanation of Solution
Crow’s Foot ER diagram for FlyRight Aircraft Maintenance division of the FlyRight Company:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, the disjoint constraint (d) is used as a category symbol. Here the “Employee” supertype entity has optional subtypes. The primary of “Employee” entity is “Emp_No”...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Instructions: Create a dimensional model for a particular business process involving
gym membership. A customer can sign up for a membership of say one, three, six or
twelve months. I want to make it easy to query to identify current members, members
who expired in the last month, members who renewed in the last month, those who are
pending expiry etc.
If I have a basic model with a fact table representing a gym membership say
start_date_key
end_date_key
membership_attribute_key
customer_atrribute_key
fee
with associated dimension table for date, membership attributes such as length,
customer attributes and so forth. On a particular day, the active members are those with
a start date before the day and an end date after that day. Those who will expire next
month are those where the end date is in a particular date range.
create an ER table
Want in detail
Chapter 5 Solutions
Bundle: Database Systems Design, Implementation, & Management, Loose-leaf Version, 13th + MindTapV2.0, 1 term Printed Access Card
Ch. 5 - Prob. 1RQCh. 5 - What kinds of data would you store in an entity...Ch. 5 - Prob. 3RQCh. 5 - What is a subtype discriminator? Give an example...Ch. 5 - Prob. 5RQCh. 5 - What is a disjoint subtype? Give an example.Ch. 5 - What is the difference between partial...Ch. 5 - Prob. 8RQCh. 5 - According to the data model, is it required that...Ch. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - When implementing a 1:1 relationship, where should...Ch. 5 - What is time-variant data, and how would you deal...Ch. 5 - Prob. 17RQCh. 5 - Prob. 1PCh. 5 - Prob. 2PCh. 5 - Prob. 3PCh. 5 - Prob. 4PCh. 5 - Prob. 5PCh. 5 - Prob. 6PCh. 5 - Prob. 7PCh. 5 - Prob. 8CCh. 5 - Prob. 9CCh. 5 - Prob. 10C
Knowledge Booster
Similar questions
- A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?arrow_forwardThe entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than one activity. Draw an ERD for this situation. What attribute or attributes did you designate as the identifier for the STUDENT entity? Why?arrow_forwardA manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, and relationships between the entities. Assumptions: • A supplier can exist without providing components. • A component does not have to be associated with a supplier. • A component does not have to be associated with a product. Not all components are used in products. • A product cannot exist without components.arrow_forward
- Please 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_forwardExercise 3 Manufacturer A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Assumptions A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components. List of Entities and the Attributes List of Relationship and Cardinalities Draw the Conceptual Model Draw the Logical Model with…arrow_forwardDraw an Entity Relationship Diagram (ERD) based on the flat files that have been supplied. Your ERD must incorporate all the entities and attributes supplied, as well as establishing the relationships between the entitiesarrow_forward
- Acme Airlines ERD Create an Entity Relationship Diagram in Vertabelo from the business rules shown below. Make sure each entity has all attributes and relationships as well as any appropriate annotations. Please print your ERD to PDF and submit to the Assignment 5 link. Please check your file before submitting to make sure it is viewable. The Acme Airline Company has a fleet of small planes that can be chartered by customers to fly either passengers or cargo across the country: a CUSTOMER may book zero or more CHARTERS and each CHARTER must be booked by one CUSTOMER an AIRCRAFT may be used for zero or more CHARTERS and each CHARTER must use a single AIRCRAFT a CHARTER will have one or more EMPLOYEES on the flight and each EMPLOYEE may fly on zero or more CHARTERS Since the relationship between CHARTER and EMPLOYEE is many-to-many, use a composite entity called CREW to break it up. A CHARTER will have one or more CREW members and each EMPLOYEE can be on zero or more CREWS for a CUSTOMER…arrow_forwardIn an ERD, entities do not have columns. Instead which of the following is used to describe the entity's characteristics? Group of answer choices attributes degrees instances relationshipsarrow_forwardGarden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Create a sample list of owners and properties. Your list will be similar in structure to that in Figure 1-34 g, but it will concern owners and properties rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing address, as well as property name, type, and address. B. Describe modification problems that are likely to occur if Garden Glory attempts to maintain the list in a spreadsheet. C. Split the list into tables such that each has only one theme. Create appropriate…arrow_forward
- STORE Store Nbr Store Name Store Address Is Managed by Mgr Role Start Time Mgr Role End Time EMPLOYEE Emp ID Emp Last Name Emp First Name Review the figure above and select the statement that is false: Store Nbr is the primary key of STORE A store always has a manager associated with it The model can be used to capture data of managers who, over time, worked for the same store multiple times Each store can, over time, be managed by multiple employees. O The relationship between STORE and EMPLOYEE may have attributes associated with itarrow_forwardCreate the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT, that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, and so on.)arrow_forwardThe ability to combine two or more tables through common data attributes to form a new table with only the unique data attributes is called _______________.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 Learning
Database 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
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
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: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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning