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 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
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.
Create 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:…
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice.
For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address.
For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate.
For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
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 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
- 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_forwardAll entity names, relationship names, and attribute definitions must be correct.arrow_forward1. Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. OFFICE (OFFICE NUM, OFFICE NAME, (ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY RENT, OWNER_NUM)) 2. Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. PROPERTY (PROPERTY ID, OFFICE NUM, ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY RENT, OWNER NUM, LAST NAME, FIRST NAME)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_forwardSome Tiny College staff employees are information technology (IT) personnel. Some IT personnel provide technology support for academic programs, some provide technology infrastructure support, and some provide support for both. IT personnel are not professors; they are required to take periodic training to retain their technical expertise. Tiny College tracks all IT personnel training by date, type, and results (completed versus not completed). Given that information, create the complete ERD that contains all primary keys, foreign keys, and main attributes.To upload and submit your assignment, click the Choose File button below to find and select your saved document. Make sure that the file is saved with your last name in the file name. (Example: ch5_problem1_Jones.doc)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_forward
- Garden 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_forwardGive some specific guidelines for defining attributes?arrow_forward1. The table shows a class list for the XYZ UNIVERSITY, convert this user view to a set of 3NF relations. Assume the following: a. An instructor has a unique code. b. Astudent has a unique course. C. A course has a unique description. XYZ UNIVERSITY First Semester, SY 2020-2021 Course No. : COE 412 Description : Operating Systems Instructor Code : 0001 Instructor Name : Mr. X ID NUMBER STUDENT NAME COURSE 38214 BRIGHT BSCPE 40875 CORTEZ BSECE 51893 EDWARD BSITarrow_forward
- Joan Yancey has been asked to create a database for her company, Yancey Shipping. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. She has determined that she needs the following tables and fields in her database:(Table 1) Employee Information:Fields - Last Name, First Name, Street Address, City, State, Zip Code, Social Security Number, Phone Number, Hourly Pay Rate, and Project Number (Table 2) Project Information:Fields - Project Number, Project Name, Project Leader, Project Location, Total Hours, and Actual Completion Date What data type should Joan Yancey use for the Actual Completion Date field and why?arrow_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.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_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