Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a conceptual data model for the following scenario: The data model should consist of the usual 5 components: E-R diagram, Entity Types (including entity

Develop a conceptual data model for the following scenario:

The data model should consist of the usual 5 components: E-R diagram, Entity Types (including entity type identifiers), assumptions, additional constraints, and limitations:

It is desired to develop a shop database for a shop of different classes of products.

A shop sells different classes of products to customers. For each class, it is required to keep the following information: class identification number (class-id) and class name. Each class has one or more products.

Every customer may or may not buy products. The following information of customers needs to be kept: customer identification number (customer-id), customer-name, address, mobile phone number and email address.

An employee may sell zero, one or more products. The following information of employees are required to be kept: employee identification number (emp-id), employee name, hire-date, number of working hours, salary, address, mobile phone number and email address. Each employee can work at most eight hours daily.

A product may or may not be be sold by employees to customers such as two HP laptops (quantity is 2) may or may not be sold by two different employees to two different customers. For every product, the product identification number (product-id), product name, quantity, price and description need to be kept. Each product is exactly belonging to a class.

The product-id should starts with letter p.

Every customer may or may not receive discounts on the products, and each product may or may not have discounts for customers. The discounts information are required to be kept, and these information are: customer identification number, product identification number, discount amount and discount date.

The customer can receive at most two discounts on products.

After the customer bought the products he/she chose. He/she can evaluate the service received by filling an evaluation form giving on a screen in the shop. A customer may or may not fill an evaluation form, and every evaluation form is filled by a customer. The evaluation form consists of the following information that needs to be kept: form identification number (form-id), description, evaluation result and evaluation-date.

Note: you should expect about 8 entity types, 8 relationship types, 32 attributes, 9 additional constraints, 4 assumptions and 2 limitations in the CDM for this application.

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

Recommended Textbook for

Advances In Databases 28th British National Conference On Databases Bncod 28 Manchester Uk July 2011 Revised Selected Papers Lncs 7051

Authors: Alvaro A.A. Fernandes ,Alasdair J.G. Gray ,Khalid Belhajjame

2011th Edition

3642245765, 978-3642245763

More Books

Students also viewed these Databases questions