Answered step by step
Verified Expert Solution
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?
Sample
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 collectionsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started