In this question, you need to design an ER diagram for a company that sells cars. We make the following assumptions: The company owns multiple shops that customers can visit to buy cars, and each shop has a unique address, and a phone number. For each employee of the company, we want to store the unique SSN, the name, and the hiring date. Each employee has a fixed shop at which he/she works. Each shop is managed by exactly one employee who serves as the shop manager. An employee can be the manager of at most one shop. For each car, we want to keep track of the unique license number, the year, and the model. Each car belongs to exactly one shop. • We also keep track of the customers, where, for each customer, we store a unique email address and a name. When a customer buys a car, we keep track of the date of the sale and the employee who was serving the customer.

In this question, you need to design an ER diagram for a company that sells cars. We make the following assumptions: The company owns multiple shops that customers can visit to buy cars, and each shop has a unique address, and a phone number. For each employee of the company, we want to store the unique SSN, the name, and the hiring date. Each employee has a fixed shop at which he/she works. Each shop is managed by exactly one employee who serves as the shop manager. An employee can be the manager of at most one shop. For each car, we want to keep track of the unique license number, the year, and the model. Each car belongs to exactly one shop. • We also keep track of the customers, where, for each customer, we store a unique email address and a name. When a customer buys a car, we keep track of the date of the sale and the employee who was serving the customer.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

How is computer science similar to other fields? Their method?
What is it about computer science that attracts people of various ages and backgrounds?
Why is computer science appealing to people of diverse ages and backgrounds?
What is machine learning?
What are the similarities and differences between computer science and other fields? How do they get there?
What's different about computer science? How come?
What are the similarities and differences between computer science and other fields? How do they get there?
How is computer science like other fields? What's their process?
What killed John von Neumann?
What is it about computer science that attracts individuals of various ages and backgrounds?
What are the main differences between Computer Science and Computer Engineering?
What are the similarities and differences between computer science and other fields? How do they get there?