SSD7-Ex-5.zip_ssd7_ssd7 5_ssd7 ex_ssd7 ex5_ssd7 exercise

Entities and their attributes for the E-Commerce Project: 1. BookTitle(Strong Entity): ATTRIBUTEStype VALUE TYPE VALUE CONTENTS KEY TYPE ISBN single value Primary Title single value Author Multi-value (Author1, Author2, etc.) PublisherId composite value ("P", Number) Foreign Edition single value DateOfPublication composite value (Year, Month, Day) Price single value Description single value QuantityInStore single value CategoryId composite value ("T", Number) Foreign PromotionDiscount single value 2. Category(Strong Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE CategoryId composite value ("T", Number) Primary CategoryName single value 3. Customer(Strong Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE CustomerId composite value ("C", Number) Primary Email composite value (mail_id,”@”,domain) Name composite value (Fname, Mname, Lname) Address composite value (Number, Street, City, State, Country) PinCode single value PhoneNumber composite value (AreaCode, Number) Password single value 4. Publisher(Strong Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE PublisherId composite value ("P", Number) Primary Name single value Address composite value (Number, Street, City, State, Country) PinCode single value PhoneNumber composite value (AreaCode, Number) 5. Promotion(Weak Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE ISBN single value EndDate composite value (Year, Month, Day) 6. Order(Strong Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE OrderId composite value ("O", Number) Primary CustomerId composite value ("C", Number) Foreign Address composite value (Number, Street, City, State, Country) PaymentId single value ("P", Number) Foreign OrderDate composite value (Year, Month, Day) ShipDate composite value (Year, Month, Day) AgentId composite value ("A", Number) Foreign TotalCost single value 7. PaymentDetail(Weak Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE PaymentId single value ("P", Number) Primary ExpiryDate composite value (Year, Month, Day) PaymentMethod single value PaymentCardNumber single value CustomerId composite value ("C", Number) Foreign 8. ShippingDetail(Strong Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE ShipId composite value ("S", Number) Primary OrderId composite value ("O", Number) Foreign ShipDate composite value (Year, Month, Day) AgentId composite value ("A", Number) Foreign 9. ShippingAgency(Strong Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE AgentId composite value ("A", Number) Primary AgentName single value AgentAddress composite value (Number, Street, City, State, Country) PinCode single value PhoneNumber composite value (AreaCode, Number) 10. FulfilledOrder(Weak Entity): ATTRIBUTES VALUE TYPE VALUE CONTENTS KEY TYPE OrderId composite value ("O", Number) Foreign ISBN single value Foreign Quantity single value ShipId composite value ("S", Number) Foreign DeliveryDate composite value (Year, Month, Day)