Database Systems: Design, Implementation, & Management
11th Edition
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
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
The FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRC's aircraft. Produce a data model segment that reflects the following business rules:
All mechanics are FRC employees. Not all employees are mechanics.
Some mechanics are specialized in engine (EN) maintenance. Others are specialized in airframe (AF) maintenance or avionics (AV) maintenance. (Avionics are the electronic components of an aircraft that are used in communication and navigation.) All mechanics take periodic refresher courses to stay current in their areas of expertise. FRC tracks all courses taken by each mechanic—date, course type, certification (Y/N), and performance.
FRC keeps an employment history of all mechanics. The history includes the date hired, date promoted, and date terminated. Given those requirements, create the Crow's Foot ERD segment.
To upload and submit your assignment, click the Choose File button below to find and select your saved…
The FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRC’s aircraft. Produce a data model segment that reflects the following business rules:
• All mechanics are FRC employees. Not all employees are mechanics.
• Some mechanics are specialized in engine (EN) maintenance. Others are specialized in airframe (AF) maintenance or avionics (AV) maintenance. (Avionics are the electronic components of an aircraft that are used in communication and navigation.) All mechanics take periodic refresher courses to stay current in their areas of expertise. FRC tracks all courses taken by each mechanic—date, course type, certification (Y/N), and performance.
• FRC keeps an employment history of all mechanics. The history includes the date hired, date promoted, and date terminated. Given those requirements, create the Crow’s Foot ERD segment.
Exercise 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…
Chapter 5 Solutions
Database Systems: Design, Implementation, & Management
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 the difference between partial...Ch. 5 - Prob. 7RQCh. 5 - According to the data model, is it required that...Ch. 5 - Prob. 9RQCh. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - When implementing a 1:1 relationship, where should...Ch. 5 - What is time-variant data, and how would you deal...Ch. 5 - Prob. 16RQCh. 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
- Draw the Enhanced Entity–Relationship (EER) model and the relational schema for the case study below: This case study describes a company called HomeCinema, which rents out videos to its members. The first branch of HomeCinema was established in 1982 in Jeddah but the company has now grown and has many branches throughout the country. As HomeCinema has grown, so has the difficulties in managing the increasing amount of data used and generated by the company. To ensure the continued success of the company, the Director of HomeCinema has urgently requested that a database application be built to help solve the increasing problems of data management. The data held on a branch of HomeCinema is the branch address made up of street, city, state, and zip code, and the telephone numbers (maximum of 3 lines). Each branch is given a branch number, which is unique throughout the company. Each branch of HomeCinema has staff, which includes a Manager, one or more Supervisors, and a number of other…arrow_forwardGiven these business rules, create the Entity Relationship Diagram, include relationships and cardinalities. A bookstore is modeling its data. On one part, we have the READERS. Readers have a registration ID, name composed by first name and last name, mailing address and list of topics of interest (cooking, fiction, etc). The books available for readers will be stored with title, year of publication, isbn code and a list of topics that the book is tagged for. Authors are also to be stored with an authorID, name composed by first name, middle name and last name, mailing address and date of birth. One book can have multiple authors, but must have at least one. One author can write multiple books, one book or even be registered as an author without authoring any books. A customer can own multiple books and only starts being a costumer after buying her/his first book. I need help understanding how this works and how I put it togetherarrow_forwardCreate an ER Model for the following requirements: A car has a make, model and year. A registration has a county and date. A person has an address and an age. A car may be owned by a person. A car may be registered to an owner. Explain your reasoning behind 1 choice you made between in the ER diagram in question 1. For example, why choose entity vs relationship, or weak entity vs ternary relationship, or use/disuse of an aggregation, or similar choices.arrow_forward
- Develop a simple data model for a student database that includes student data, student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete entity relationship diagram that shows how these tables are related to one another.arrow_forwardDraw an Entity relationship diagram (ER) for a university according to the following rules: ‐ For each student the university needs to keep track of: first name, last name, student id, address, phone no and their major. ‐ The student id is identical for each ‐ Each course has a number, name and credit. The course number is unique for each course. ‐ Each department has a name, code and The code is unique for each department. ‐ Each course may has one or more sections where each section is belong to only one ‐ A department offers one or many 7-‐ Some courses have perquisite courses. 8-‐ Each student could register in one or more courses. In your diagram you need to show the following: 1-‐ The primary key for each entity. 2-‐ The cardinality and participation between entities.arrow_forwardDevelop ERD (Entity Relationship Diagram) for one of the following two scenarios. NOTE: No further details were provided by the professor. The diagram can be drawn by hand also if preferred. Option1: A customer who goes to a grocery shop generates one invoice each time s/he goes to the grocery. Customer data to capture includes ID, FirstName, LastName, City, State, CreditLimit. An invoice should capture the data on InvoiceID, SaleDate, SalesPerson, and Amount. Provide a conceptual ERD for this transaction scenario. Option 2: One sports team consists of many players, and one player can belong to one sports team at a time. Sports team data should have TeamID, TeamName, CoachName, memberNumbers, City, State, owner, TeamValue. Each player can be represented with PID, Name, Address, PhoneNo, Position, weight, height, Value, and Scores. Provide a conceptual ERD to develop a database.arrow_forward
- Applying your knowledge in Enhanced Entity Relationship modeling, Develop an EER model for the following situation: A person may be employed by one or more organizations and each organization may be the employer of one or more persons. An organization can be internal organizational unit or an external organization. For persons and organizations, we want to know their ID, name, address and phone number. For persons we want to know their birthdate, and for organizations, we want to know their budget number. For each 6 employment, we want to know the employment date, termination date and bonus. Employment of a person by an organization may result in the person holding many positions over time. For each position, we know its title, and each time someone holds that position, we need to know the start date and termination date and salary. An organization is responsible for each position. It is possible for a person to be employed by one organization and hold a position for which another…arrow_forwardThere are M:1 relationship between Property entity and Owner entity. There are 1:M relationship between Property entity and Services entity. There are 1:M relationship between Address entity and Property entity. There are M:1 relationship between Service entity and Employee entity. Find minimum and maximum cardinality of the following relationsarrow_forwardFor the given business rule, is the explanation for relationship and cardinality correct between PROFESSOR and COURSE below: Business Rule: A university is divided into many schools. Each school has many departments, where each department belongs to one and only one school. Each department should have one or more professors assigned to it, where each professor cannot teach more than two courses. The university wants to record the following data for all professors: professor number and full name. All courses are classified into two categories: Fashion and Technology. Relationship: PROFESSOR “teaches” COURSE Relationship type: 1:M Explanation: Business rules state, “Each course belongs to one and only one professor. Each professor includes one or more courses”. The PROFESSOR entity is on the “one” side of the relationship and the COURSE entity is on the “one or more” side of the relationship. Relationship participation: Mandatory on the “one” side of the…arrow_forward
- Perform given tasks on Case study Q-Find entity Attribute and primary key, also draw Entity diagram? Case study: In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher has name NIC and qualification. A department is known by its name e.g. CSIT, and have a HOD name , Num of students and Floor No. A course is identified by its Code. Course also has name and level of degree. A student must enroll (roll no and Semester as relationship attribute) in any one department. A department can have many students. The teacher is assigned class (time and day as attribute) in more than one department. A department has many teachers. A student can study up-to 5 courses by a teacher in given classroom number.arrow_forwardConsider an automobile dealership with three locations. Data fields exist for stock number, vehicle identification number, make, model, year, color, and invoice cost. Identify the possible candidate keys, the likely primary key, a probable foreign key, and potential secondary keys. In particular, your paper should address the following: The list of the key entities for that system along with the possible attributes Clear identification for the primary/foreign keys for each table The complete ER model based on your identified entities Make sure to list all of your assumptions to explain the relationships among the entities in your ER modelarrow_forwardpls help me : Draw an ER diagram databse management for hospital according to the following requirements:Department - stores information about hospital departments, including department ID and department name. Staff - stores information about doctors and nurses, including staff ID, staff name, and department ID (foreign key referencing Department entity). Patient - stores information about patients, including patient ID, patient name, gender, date of birth, and address. Visit - stores information about each patient visit, including visit ID, patient ID (foreign key referencing Patient entity), medical record ID, clinic ID, doctor ID (foreign key referencing Staff entity), assistant nurse ID (foreign key referencing Staff entity), and visit date. Medical Record - stores information about each medical record, including medical record ID and visit ID (foreign key referencing Visit entity). Test - stores information about each test ordered by the doctor, including test ID, test name, and…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- 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
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