logo

Information About Different Categories of Food

10 Pages990 Words410 Views
   

Added on  2019-09-16

Information About Different Categories of Food

   Added on 2019-09-16

ShareRelated Documents
STUDENT NAME04 November, 2016ASSIGNMENT 2
Information About Different Categories of Food_1
ContentsSECTION B..........................................................................................................................................2GROUP PART......................................................................................................................................6ENTITY RELATIONSHIP DIAGRAM............................................................................................6RELATIONAL MODEL DIAGRAM...............................................................................................71 | Page
Information About Different Categories of Food_2
SECTION B 1.Identify entitiesa.CITY b.RESTAURANT c. PROMOTION d.CATEGORY e.MENU_ITEMS f.CUSTOMER g.RIDER h.ORDER i.ORDER_DETAILS 2.Identify attributesa.CITY: CITY_ID, CITY_NAMEb.RESTAURANT: RID, RNAME, RADDRESS, ZIPCODE, PHONE,CITY_IDc.PROMOTION: PROMOTION_ID, RID, DETAILS, FROM_DATE, TO_DATE, PROMOTIONAL_PRICEd.CATEGORY: CATEGORY_ID, CNAMEe.MENU_ITEMS: ITEM_ID, PRICE, DESCRIPTION, RID, CIDf.CUSTOMER: CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONEg.RIDER: RIDER_ID, RIDER_NAME, PHONEh.ORDER: ORDER_ID, ORDER_DATE, ORDER_TIME, DELIVERY_TIME,RIDER_ID, CUSTOMER_ID, i.ORDER_DETAILS: ORDER_ID, PRICE, QUANTITY, ITEM_ID, PROMOCODE3.functional dependencies2 | Page
Information About Different Categories of Food_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design for Food Delivery Service
|8
|646
|458