Database Systems: Design Implementation & Management
11th Edition
ISBN: 9781305850378
Author: Coronel
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 1P
Explanation of Solution
Crow’s Foot ER diagram for Two-Bit Drilling Company:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, “Employee”, “Dependent” and “Inspector” are the entities. The “Employee” is the supertype and “Inspector” is the one and only subtype of the “Employee” table...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.
Please help me
The State of New York certifies firefighters through- out the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique fire- fighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieu- tenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervi- sors are always higher-ranking certified firefighters. Construct a relational database for New York’s fire departments and firefighters.
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
- The scenario is for a small life insurance agency and their need to keep track of clients, agents, insurers, and quotations. 1) A Client is a customer, potential customer, or contact of the agency. We need to assign each client a number and save their last name, first name, birth date, gender, telephone number, email address, and the agent who brought the client into the agency. If a client is a “walk in” they are assigned to the first available agent. All clients must have one primary agent. 2) An agent is a licensed individual with the state. Each agent has a nationally unique license number, last name, first name, telephone number, and email address. An agent must be the primary agent for at least one client but may not be primary for more than 500 clients. An agent must also be part of at least one quotation and may share in an unlimited number of quotes. 3) The agency represents (does business with) many insurance companies (insurers). We will need to track each insurer with an…arrow_forwardA laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of CHEMIST include Employee ID (identifier), Name, and Phone No. Attributes of PROJECT include Project ID (identifier) and Start Date. Attributes of EQUIPMENT include Serial No and Cost. The organization wishes to record Assign Date—that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A chemist must be assigned to at least one project and one equipment item. A given equipment item need not be assigned, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.arrow_forwardThe following are the basic processes of Boarding School Outing System. Student may enter the outing request such as date, reason, check-out time (check-in time is auto-set at 6.00 PM) to request for outing. The outing request details are stored in 'Outing Request' record. Warden can view the outing request and he/she may approve or disapprove the request. The status of the request is updated in the Outing Request' record. Once the status is updated, a short message service (SMS) notification will be sent by the system to the student and parents. The hand-phone numbers are retrieved from the Student' record. Student will check-out and check-in via this system whenever he/she is about to leave from the school and reports back to the school. The data (date and time) is kept in the existing outing record. Note: **Definition of outing (in boarding school context): A day out from the hostel/school, normally during the weekend. Based on the scenario above: a) Draw a Context Diagram for…arrow_forward
- A rail transport company wishes to hold details of train services, stations and operators. Details include the following: Trains: A train has a unique id code, a collection of days it runs on (Monday, Sunday etc.), and the number of carriages it has. Each train must have at least one driver but can have many drivers that can drive it, and a driver may drive many trains. Each driver is identified by an employee number and a name. A train is designated as either an InterCity or District train though other types of train are possible. Each train must have an operator and not more than one operator. Each operator has a name and a phone number. The operator can operate many trains (or none at all!) Stations: A station has a name and the number of platforms it has. All stations are classified as either Main or District only. There are no other types of stations. Timetable: A train has a number of stops at a station during its journey. It never visits the same station twice on the same…arrow_forwardDraw the ER/EER model for the given scenario. Manufacturer have unique name, an address, and a phone number. Products have a product_id, a name and price. Products may be classified into electronics and grocery. Electronic products have description, type attributes. Groceries have fssai_number, date_of manufacture, date_of_expiry. Each product is made by one manufacturer, and different manufacturers may produce different products.. Customers are identified by their unique social security number. They have email addresses, and physical addresses. Several customers may live at the same (physical) address, but we assume that no two customers have the same email address. An order has a unique order number, and a date. An order is placed by one customer. For each order, there are one or more products ordered, and there is a quantity for each product on the orderarrow_forwardDraw an ERD for the following scenario: A department employs many employees, but each employee is employed by one department. Each employee has the following characteristics: emp_Num, emp_FName, empLName, empAdress. Each department has a code and a name. Some employees, known as “rovers,” are not assigned to any department. A division operates many departments, but each department is operated by one division. Each division has a code and a name. An employee may be assigned many projects, and a project may have many employees assigned to it. Each project has a code and a name. An assignment is characterized by a date and number of hours. A project must have at least one employee assigned to it. One of the employees manages each department, and each department is managed by only one employee. One of the employees runs each division, and each division is run by only one employee.arrow_forward
- ManufacturerA 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.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. Construct an ERD table to show how you would track this information.arrow_forwardUniversity AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... (a) identify input, process and output for above program.(b) write a pseudocode or draw a flowchart for above programarrow_forwardDraw an ERD for the following problem:Company organized into departments. Each department has unique, name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations. A department controls a number of projects. Projects have a unique name, number and a single location. Company’s employees name, ssno, address, salary, sex and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; the immediate Supervisor for the employee. Employee’s dependents are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).arrow_forward
- Create a Crow's Foot ERD for the following description: 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_forwardneed diagram only Draw an ER diagram for the following scenario: A designer has a store of designer dresses both for male and female. People can buy as well as take dresses on rent from the store. Each dress in the designer's store, is identified by unique ID. A dress in the store can be categorized into various categories Western, Indian, Indo-westem, etc. The designer maintains the name, phone number of people who have taken dresses on rent. The designer also maintains the name, phone number, and address of people who have bought dresses from the store. The designer also collects feedback from the people who have bought or taken dresses on rent from the store. Design the ER diagram by mentioning all the structural constraints. You may also include additional information in addition to the requirements listed.arrow_forwardTechnology College Muscat hired you as a programmer to automate their manual Student Registration System. The college requires you to develop a C++ program to manage their Students' personal and academic record. You are required to develop a C++ program using C++ structures, arrays, and user defined functions. The college stores each student's full name, a maximum of 30 character long, student's age, numeric student's ID number of 8 digits long, student's modules enrolled and student's module result. You are required to implement 3 different functions, a function to get/input all the data of a student from a user. A function to get/input student's modules and result against each module and to calculate average marks of each students, and a function to display all students' personal and academic data. You are required to demonstrate storing of 5 students and displaying their stored data with average marks. You are also required to calculate and display the overall result analysis for 5…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education