CANTEEN MANAGEMENT SYSTEM ENTITIES AND THEIR ATTRIBUTES Canteen Entity

Canteen management system entities and their

This preview shows page 3 - 5 out of 14 pages.

CANTEEN MANAGEMENT SYSTEM ENTITIES AND THEIR ATTRIBUTES: Canteen Entity: Attributes of Canteen are Canteen_ Name, Address and Phone Employee Entity: Attributes of Employee are Emp_ID, Emp_Name, Address, Phone, Position_ID(FK). Section Entity: Attributes of Section are Sec_ID(PK), Sec_Name, SecType_ID(FK) SecPro_ID(FK). Section Property: the Attributes of Section Property are SecPro and Sec_Name. Section Type: the attributes of Section Type include SecType_ID(PK) and SecType_Name Order Entity : the attributes of orders entities are order_ID(PK) and order_Date and Order Type_ID(FK) Order Type: the attributes of the order type are OrderType_ID and Order Type_Name Customer Entity: the attributes of the Customers are Cus_ID, Cus_Name, Address and Phone Reservation Entity: the attributes of the reservation entities are Res_ID(PK), Res_Date, Cus_ID(FK).
Image of page 3
DESCRIPTION OF CANTEEN MANAGEMENT SYSTEM DATABASE: The details of Canteen is store into the canteen tables respective with all tables. Each entity (order, order type, customers, reservation, employee, position, section Type, section property and Section) primary key and unique key
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 14 pages?

  • Fall '19
  • Entity-relationship model, entity, Canteen Management System, Canteen Management System ER Diagram

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture