Concept explainers
Develop an EER model for the following situation, using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor:
A technology company provides offerings to its customers. Offerings are of two separate types: products and services. Offerings are identified by an offering ID and an attribute of description. In addition, products are described by product name, standard price, and date of first release; services are described by name of the company's unit responsible for the service and conditions of service. There are repair, maintenance, and other types of services. A repair service has a cost and is the repair of some product; a maintenance service has an hourly rate. Fortunately, some products never require repair. However, there are many potential repair services for a product. A customer may purchase an offering, and the company needs to keep track of when the offering was purchased and the contact person for that offering with the customer. Unfortunately, not all offerings are purchased. Customers are identified by customer ID and have descriptive data of name, address, and phone number. When a service is performed, that service is billed to some customer. Because some customers purchase offerings for their clients, a customer may be billed for services he or she did not purchase, as well as for ones that were purchased. When a customer is billed for a service (although some may never require a service of any type), the company needs to keep track of the date the service was performed, the date the bill is due, and the amount due.
Trending nowThis is a popular solution!
Chapter 3 Solutions
Modern Database Management
Additional Engineering Textbook Solutions
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Using MIS (10th Edition)
Starting Out with C++: Early Objects
Database Concepts (7th Edition)
Web Development and Design Foundations with HTML5 (9th Edition) (What's New in Computer Science)
Computer Systems: A Programmer's Perspective (3rd Edition)
- (a) Explain carefully four ways in which the diagram fails to model the intended world. In each case make sure you contrast the actual meaning with the intended meaning. (b) Give an entity-relationship diagram, still using two entity types, which correctly models the intended world. (c) Give a database schema (including primary keys) for the ER diagram which you have given in the previous part. (d) Is there any part of the ER diagram which is not captured in the schema? How might this aspect be captured in the final database?arrow_forwardCreate an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any. A person can be an employee, alumnus, or a student. For a person, P_id (identifier), date of birth, gender, and contacts are stored. A person can have more than one contact number and there are no other types of person that exist. An instance of a person can belong to more than one type. Date hired and salary is the unique attributes of the employee. For alumnus, the degree is required to be stored that comprises of year and designation. The major department is the attribute of the student. A student can be a graduate student or an undergraduate student but not both at the same time. No other type of student exists. For graduate student test score is stored and for undergraduate student class standing is stored. Employees can be faculty, staff, or others but not…arrow_forwardDescribe how functional dependencies may be used to denote the following:• The entity sets student and teacher have a one-to-one relationship set.• There is a many-to-one connection set between the entity sets student and teacher.arrow_forward
- For each entity, there needs to be an indication of whether it is one-to-one, one-to-many or many-to-many relationship. Here are the answers I have but I could use more guidance with it. I struggle with this type of question. BOOK and BOOK COPY (1:1) COURSE and COURSE-SECTION (M:N) COURSE-SECTION and ROOM (M:1) INSTRUCTOR and COURSE (1:M) ROOM and INSTRUCTOR (M:1)arrow_forwardCreate an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any. [20 Marks] A person can be an employee, alumnus or a student. For person P_id (identifier), date of birth, gender and contacts are stored. Person can have more than one contact numbers and there are no other types of person that exists. An instance of person can belong to more than one type. Date hired and salary is the unique attributes of employee. For alumnus degree is required to be stored that comprises of year and designation. Major department is the attribute of student. A student can be a graduate student or an undergraduate student but not both at the same time. No other type of student exists. For graduate student test score is stored and for undergraduate student class standing is stored. Employee can be faculty, staff or others but not both at the same…arrow_forwardAnalyze the given entity relationship diagram and answer the following questions. What is the degree of “has” relationship?arrow_forward
- An instructor has several phone numbers. When reducing the ER diagram down to a schema this must be addressed. Which of the following statements are true? a. an instructors phone is what is known as a multi-valued attribute b. a multi-valued attribute of an entity is expressed as a separate schema with attributes including the primary key of the original entity and the multi-valued attribute c. the instructor should have a column for each type of phone number d. multi-valued attributes must be flatted out to a separate attribute for each componentarrow_forward3 Create an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any. A person can be an employee, alumnus or a student. For person P_id (identifier), date of birth, gender and contacts are stored. Person can have more than one contact numbers and there are no other types of person that exists. An instance of person can belong to more than one type. Date hired and salary is the unique attributes of employee. For alumnus degree is required to be stored that comprises of year and designation. Major department is the attribute of student. A student can be a graduate student or an undergraduate student but not both at the same time. No other type of student exists. For graduate student test score is stored and for undergraduate student class standing is stored. Employee can be faculty, staff or others but not both at the same time. For…arrow_forwardBy adding the primary-key characteristics of the identifying entity set in its attributes, a weak entity set may always be converted into a strong entity set. Describe the kind of redundancy that will result from our choice.arrow_forward
- A weak entity set can always be made into a strong entity set by adding to its attributes the primary-key attributes of its identifying entity set. Outline what sort of redundancy will result if we do so.arrow_forwardCreate an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any. A person can be an employee,alumnus or a student.For person P_id(identifier), date of birth,gender and contacts are stored. Person can have more than one contact numbers and there are no other types of person that exists.An instance of person can belong to more than one type.Date hired and salary is the unique attributes of employee.For alumnus degree is required to be stored that comprises of year and designation. Major department is the attribute of student. A student can be a graduate student or an undergraduate student but not both at the same time.No other type of student exists.For graduate student test score is stored and for undergraduate student class standing is stored.Employee can be faculty, staff or others but not both at the same time. For faculty…arrow_forwardExplain how functional dependencies can be used to indicate the following: • A one-to-one relationship set exists between entity sets student and instructor. • A many-to-one relationship set exists between entity setsstudent and instructor.arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education