Information About Different Categories of Food

Added on - 16 Sep 2019

  • 10

    Pages

  • 990

    Words

  • 273

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
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
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document