Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A well-known car rental company stores its data in a special database. This company has many customers and many types of cars as product. All

A well-known car rental company stores its data in a special database. This company has many customers and many types of cars as product. All customers have a unique customer_id. Customers are categorized as national customers or international customers. A customer must be national or international, and cannot belong to both of the categories at the same time. International customers are identified by their unique id, currency, company name and address composed of city state and zip code. National customers are identified by their unique id, name and address. National customers may have more than one address information. Products are identified by a unique product_id, model, type and price. Only two type of products are rented in this company. These product types are car and mini van. Each car has a color and motor attributes. Each mini van has a color and number of seats attribute. A product may belong to at le ast one of these types. Moreover, it may not belong to both of them at the same time. Customers may request products, and a product may be requested by more than one customer, also it may not be requested by any customer at all. When a product is requested or ordered by a customer; request id, request type and request content information is stored. Design an EER diagram for the system.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions