Use conversion algorithm to convert ER diagram to Relational Model Or All ER to relational model intermediatory conversion steps with final relational model (i.e. step 4)

 

Transcribed Image Text:

RUberID REmail Passwd Mobilenumber Name RESTAURANT 1 of 1 weekly paid R-WPAYMENT RPayID PayDate Pay Uberfees - |+ Commid. MC_details MarketingComm, sends AddID Address DELADDRESS UserID receives DPayID D-WPAYMENT PayDate Pay Paid-weekly ^ DELIVERYPERSON Address numlocations add-menu ContractStatus Passwd UberDID save Name Name give Add Language Email, AVAILABILTY accepts PayOption MENU DayofWeek available POPTIOND Pay_details Type MobileNumber Emat call Duration Phone Address add CUSTOMER IDProof_details IDProof Type BackgroundCheck AccountStatus RUBERID MenuID Menuname Description consists Menuhour belongs-to CATEGORIES RUBERID CategoryName CustomisationID RUBerID Limit details MENUITEMS MenultemName MenuID CartID UserID checkout selectCART RUberID Description selected Price has-custom Taxrate DietaryPref AvStatus imageavailable Expiry Date isPrimary creates insert getsorder Action givespayopt has Date ByWhom Comment STATUS Statusid Statusname ORDER givespromo gets-feed ORDERID DeliveryOption give delvopt paymentMethod DeliveryAddress Menulter Name MenuID CUSTOMOPTION CustName CustomisationID Cost ReceiptID MenuCost PromoCode SpecialInstruction Statusid EstimatedDelTime Iscancelled? DeliveryFee ServiceFee Otherfees has-coption CUSTOMISATION Discount RECEIPT OrderDate PickupAddress EstimatedPickup Time include ScheduledDelivery ld DeliveryDate DeliveryTime PromoCode Status Discount_detail PROMO FEEDBACK FeedbackID StarRating Comments ForWhom ByWhom RUberID REmail Passwd Mobilenumber Name RESTAURANT 1 of 1 weekly paid R-WPAYMENT RPayID PayDate Pay Uberfees - |+ Commid. MC_details MarketingComm, sends AddID Address DELADDRESS UserID receives DPayID D-WPAYMENT PayDate Pay Paid-weekly ^ DELIVERYPERSON Address numlocations add-menu ContractStatus Passwd UberDID save Name Name give Add Language Email, AVAILABILTY accepts PayOption MENU DayofWeek available POPTIOND Pay_details Type MobileNumber Emat call Duration Phone Address add CUSTOMER IDProof_details IDProof Type BackgroundCheck AccountStatus RUBERID MenuID Menuname Description consists Menuhour belongs-to CATEGORIES RUBERID CategoryName CustomisationID RUBerID Limit details MENUITEMS MenultemName MenuID CartID UserID checkout selectCART RUberID Description selected Price has-custom Taxrate DietaryPref AvStatus imageavailable Expiry Date isPrimary creates insert getsorder Action givespayopt has Date ByWhom Comment STATUS Statusid Statusname ORDER givespromo gets-feed ORDERID DeliveryOption give delvopt paymentMethod DeliveryAddress Menulter Name MenuID CUSTOMOPTION CustName CustomisationID Cost ReceiptID MenuCost PromoCode SpecialInstruction Statusid EstimatedDelTime Iscancelled? DeliveryFee ServiceFee Otherfees has-coption CUSTOMISATION Discount RECEIPT OrderDate PickupAddress EstimatedPickup Time include ScheduledDelivery ld DeliveryDate DeliveryTime PromoCode Status Discount_detail PROMO FEEDBACK FeedbackID StarRating Comments ForWhom ByWhom