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
Concept explainers
Expert Solution & Answer
Chapter 5, Problem 6P
Explanation of Solution
Crow’s Foot ER diagrams for Tiny College IT Staffing Solution:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, the overlapping constraint (o) is used as a category symbol. Here the “Employee” supertype entity has optional subtype entity. The primary of “Employee” entity is “Emp_No”.
- The “Professor”, “Staff” and “Admin” are the subtype entities...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
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.
Draw 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 entities
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.
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
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
- 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_forwardCreate an Entity-Relationship Model for the Queen Anne Curiosity Shop The first assignment for the class project is to create an entity-relationship model of the Queen Anne Curiosity Shop database. This assignment requires you to apply the knowledge gained from study of chapter 4 of the textbook. You will create the entity-relationship model using the ERDPlus database modeling tool. The Queen Anne Curiosity Shop database contains the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, EmailAddress) EMPLOYEE (EmployeeID, LastName, FirstName, Phone, EmailAddress) VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, EmailAddress) ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total) SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice) Note that the above table descriptions follow the textbook convention:…arrow_forwardWant in detailarrow_forward
- An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.arrow_forwardA Cougars Real Estate Inc. (CRE) sells houses. People who want to sell their houses sign a contract with CRE and provide information on their house such as the current owner’s SSN, the owner’s name, the address of the house, the number of rooms, the number of baths, and the square feet of the house to a staff of CRE who is responsible for the management of house information. Then, the information is entered into the database by the staff of CRE. This information is kept in a database and a subset of this information is sent to the citywide multiple listing service used by all real estate agents. CRE works with two types of potential buyers. Some buyers have an interest in one specific house. In this case, advising specialists of CRE (advising specialists don’t manage the house information) print information from its database, which the advising specialists use to help show the house to the buyer. Other buyers seek CRE’s advice in finding a house that is wider than 2000 sq ft. In this…arrow_forwardA Cougars Real Estate Inc. (CRE) sells houses. People who want to sell their houses sign a contract with CRE and provide information on their house such as the current owner’s SSN, the owner’s name, the address of the house, the number of rooms, the number of baths, and the square feet of the house to a staff of CRE who is responsible for the management of house information. Then, the information is entered into the database by the staff of CRE. This information is kept in a database and a subset of this information is sent to the citywide multiple listing service used by all real estate agents. CRE works with two types of potential buyers. Some buyers have an interest in one specific house. In this case, advising specialists of CRE (advising specialists don’t manage the house information) print information from its database, which the advising specialists use to help show the house to the buyer. Other buyers seek CRE’s advice in finding a house that is wider than 2000 sq ft. In this…arrow_forward
- Access Workbench Part 3 A. Figure 1 shows the column characteristics for the ASSIGNMENT table. Using the column characteristics, create the ASSIGNMENT table using 'create table' script in the WPC database. Create the relationship and referential integrity constraint between ASSIGNMENT and PROJECT, and between ASSIGNMENT and EMPLOYEE. Figure 1: Column Characteristics for Assignment Table Column Name Key Primary Key, Foreign Key Required Remarks Long Integer Туре ProjectID Number Yes EmployeeNumber Number Primary Key, Forcign Key Yes Long Integer Hours Worked Double, fixed. 1 decimal places Number No No Cepyright e2013 Pearson bducation, pblishing as Prentice Hall В. For the ASSIGNMENT table, use figure 2 to insert the data in the ASSIGNMENT table. Figure 2: Assignment Data ProjectID EmployeeNumber Hours Worked 1000 30.0 1000 8. 75.0 1000 10 55.0 1100 4 40.0 1100 6 45.0 1200 1 25.0 1200 20.0 1200 4 45.0 1200 40.0 1300 1 35.0 1300 8. 80.0 1300 10 50.0 1400 4 15.0 1400 10.0 1400 6 27.5…arrow_forwardI need the answer as soon as possiblearrow_forwardBelow given relations of a database are in First Normal Form (1st NF). Decompose (Split) the relations to Normalize in 2NF and 3NF. tbl Project Project Code Project Name Project Manager Budget Reservation System HR System Attendance System PC010 Mr. Said 25000 PC011 MS. Malak 32000 PC012 Mr. Rajesh 19000 DBMS tbl Emp Dept Project Code Emp No Hourly Pay Emp Name Dept No Dept Name Ali Mohd. PC010 S100 D03 Database 7.500 PC010 S101 Hamood D02 Testing 5.500 PC010 S102 Riyaz D01 IT 8.200 PC011 S103 Pavan D03 Database 6.500 PC011 S104 Basma D02 Testing 5.400 PC011 S115 Asaad D01 IT 7.900 PC012 S137 Fathima D03 Database 6.200 PC012 S218 Avinash D02 Testing 6.100 PC012 S109 Роoja D01 IT 9.300arrow_forward
- The 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_forwardGiven the following relation that stores details of employees and their projects: If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. 1.ProjectID ➡ EmployeeName 2.ProjectID ➡ EmployeeSalary 3.ProjectID , EmployeeName ➡ EmployeeSalary 4.EmployeeName ➡ EmployeeSalary 5.EmployeeSalary ➡ ProjectID 6.EmployeeSalary ➡ EmployeeName , ProjectIDarrow_forwardSpecify the degree of this relationship (1:1, 1:M, or M:N): The attributes of employee include ID, Name, Address, and Birth_Date. Employees work on projects. The attributes of project include Project_Code, Description, and Start_Date. Each employee may be assigned to many projects. A project is required to have at least one employee assigned.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