Information About Different Categories of Food

Added on - 16 Sep 2019

  • Dissertation

    type

  • 10

    pages

  • 990

    words

  • 125

    views

  • 0

    downloads

Showing pages 1 to 3 of 10 pages
STUDENT NAME04 November, 2016ASSIGNMENT 2
ContentsSECTION B..........................................................................................................................................2GROUP PART......................................................................................................................................6ENTITY RELATIONSHIP DIAGRAM............................................................................................6RELATIONAL MODEL DIAGRAM...............................................................................................71|Page
SECTION B1.Identify entitiesa.CITYb.RESTAURANTc.PROMOTIONd.CATEGORYe.MENU_ITEMSf.CUSTOMERg.RIDERh.ORDERi.ORDER_DETAILS2.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
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document