Design a database for a retail store that orders different products from various

Question

Design a database for a retail store that orders different products from various vendors and sells them to the customers.   

The data requirements: maintain the customer information, product inventory, product vendors, orders placed withvendors and sales to the customers.

Functional requirements: product inventory information, monthly sales, profits from sales

Present a conceptual database design using Entity-Relationship diagram (ERD). Determine the attributes of all the data sources from the functional requirements. Show all the entity types with possible primary keys and attributes identify the relationships with cardinality numbers and any attributes applicable to relationships

Explanation / Answer

create table customer(custid number, fname varchar(20), lname varchar(20), contact number));

create table product(pid number, pname varchar(20), stock number);

create table prod_ven(venid number, pid number, ven_add varchar(20));

create table order(orderno number, customerid number, pid number, tot number, odate date);

select * from prod_ven;

select sum(tot) from order group by month(odate);

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.