The ER Diagram of a Online Shopping website is given below. The Online shopping site is identified by it’s website address, registration number and name.

Untitled

Mapping into Relational model

Entities:

Online Shopping Site

            Reg_no               Name        Web_address

Customer

           C_ID        Name        Ph_no      Address

Products

          P_ID         Name       Price            Model

Payment

                    Amount

Pay_ID

                   P_type

Cart

                            Cart_id                           Total_cost

Cart item

                 Quantity                  Item_id                 Totalcost

Relationships:

Visited by

                              Regno                                C_ID

Has

                           Regno                               P_ID

Does

                         Pay_ID                             C_ID

Buys

                           C_ID                             P_ID

Done for

                         Pay_ID                            Cart_ID

Added to

                         P_ID                           Item_ID

Made of

                         Cart_ID                          Item_ID
Advertisements