Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you explain the ER diagram in writing like this sample? Sample Customer H -- Purchase Made by Customer Phone Country Fname Lname pincode district

Can you explain the ER diagram in writing like this sample?

image text in transcribed

Sample

image text in transcribed

Customer H -- Purchase Made by Customer Phone Country Fname Lname pincode district Street street_code street_name city + Product ProductD type price product price detail prouct_deatils name product_name # made by 1 Payment -payment for Paymento amount data payment_amount which gives Raw materials Fmnlovee emp_nam Raw Materials price raw_price name raw_details raw_name available_quantit Profit --manages by... -- emanaged by .. ProftID Date Profit_amount phone start_date countrycode city pincode streetcode streetname country MILII Database Design The first entity is employee. It includes all positions such as the employer who is making collection, working in store and taking orders. Second entity is position" and third one is store. Fourth is collection and its "type" is also an entity which is fifth entity which helps to the cash, credit card, check etc. Sixth is "stock". It is related with store and stock unit. They will decide the "unit" such as package, colic etc, it is the seventh entity. And the eighth one is orders which has all information and it is related to the order type which is ninth entity of the company. The last and tenth entity is "customers which is related to the orders and collections

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

Advanced Database Systems For Integration Of Media And User Environments 98

Authors: Yahiko Kambayashi, Akifumi Makinouchi, Shunsuke Uemura, Katsumi Tanaka, Yoshifumi Masunaga

1st Edition

9810234368, 978-9810234362

More Books

Students also viewed these Databases questions

Question

b. Where did they come from?

Answered: 1 week ago