Ask a question to Desklib · AI bot
Information About Different Categories of Food
Added on -2019-09-16
| 10 pages
| 990 words
| 410 views
Trusted by 2+ million users,
1000+ happy students everyday
STUDENT NAME04 November, 2016ASSIGNMENT 2
ContentsSECTION B..........................................................................................................................................2GROUP PART......................................................................................................................................6ENTITY RELATIONSHIP DIAGRAM............................................................................................6RELATIONAL MODEL DIAGRAM...............................................................................................71 | Page
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
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan