Database Systems

SellerContactBuyerItem PictureSalessCreitcardSellerseller_idPKNameContact_IDCreditCard_IDPasswordUsernamecontact_IDPKaddress_IDTelephoneEmailBuyer_IDPKNameContact_IDPasswordUsernameCreditCard_IDItem_IDPKNameInitial_priceDescriptionQuantityPicture_IDStart_TimeEnd_TimeSeller_IDPicture_IDPKItem_IDImageBuyer_IdPKItem_IDPriceCreditcard_IDPKOwners_nameCard_NOExpiry Dateaddress_IDPKStreet_noCityStateZip

Seller Contact Buyer Item Picture Saless Creitcard Seller seller_id int FK PK Name int FK PK Contact_ID int FK PK CreditCard_ID int FK PK Password int FK PK Username int FK PK contact_ID int FK PK address_ID int FK PK Telephone int FK PK Email int FK PK M1 M2 M3 M4 Buyer_ID int FK PK Name int FK PK Contact_ID int FK PK Password int FK PK Username int FK PK CreditCard_ID int FK PK M1 M2 M3 M4 Item_ID int FK PK Name int FK PK Initial_price int FK PK Description int FK PK Quantity int FK PK Picture_ID int FK PK Start_Time int FK PK End_Time int FK PK Seller_ID int FK PK Picture_ID int FK PK Item_ID int FK PK Image int FK PK M1 M2 M3 M4 Buyer_Id int FK PK Item_ID int FK PK Price int FK PK M1 M2 M3 M4 Creditcard_ID int FK PK Owners_name int FK PK Card_NO int FK PK Expiry Date int FK PK M1 M2 M3 M4 address_ID int FK PK Street_no int FK PK City int FK PK State int FK PK Zip int FK PK M1 M2 M3 M4

SellerSeller_IDNameUsernamePasswordContact_IDCreditCard_IDContactEmailTelephoneAddress_IDContact_IDAdressAdress_IDCityNameStreet_NoZipStateItemContact_IDPicture_IDNameItem_IDinitial_priceQuantityDescriptionSeller_idEnd_timeStart_timePicturePicture IDImageItem_IDBuyerBuyer_IDPasswordCreditcard_IDContact_IDNameUsernameCreditcardCreditcard_IDExpiry_DateOwner_NameCard_NoSalesBuyer_IDpriceItem_ID

Seller <<Stereotype>> parameter Seller_ID Name Username Password Contact_ID CreditCard_ID Contact <<Stereotype>> parameter Email Telephone Address_ID Contact_ID Adress <<Stereotype>> parameter Adress_ID City Name Street_No Zip State Item <<Stereotype>> parameter Contact_ID Picture_ID Name Item_ID initial_price Quantity Description Seller_id End_time Start_time Picture <<Stereotype>> parameter Picture ID Image Item_ID Buyer <<Stereotype>> parameter Buyer_ID Password Creditcard_ID Contact_ID Name Username Creditcard <<Stereotype>> parameter Creditcard_ID Expiry_Date Owner_Name Card_No Sales <<Stereotype>> parameter Buyer_ID price Item_ID