Food Delivery System Assignment

INTERMEDIATE DATABASE
1

Contents
INTRODUCTION...........................................................................................................................3
TASKS.............................................................................................................................................3
Entity Relationship Diagram.......................................................................................................3
Data dictionary:...........................................................................................................................4
Construct the database tables.......................................................................................................8
SQL Statement and provide the results based on the records....................................................12
Create one oracle form to handle entry that must display and enter data..................................18
CONCLUSION..............................................................................................................................20
REFERENCES..............................................................................................................................21
2

INTRODUCTION
Database system is defined as a collection of information that can store in the form of single
data set. It should be maintained, update, retrieve and modify the data in the database system.
This assignment is based on the online food delivery system that provide the services to the
customer. It useful for consumer to select the different categories of food item by using online
system. This documentation will discuss about the database table that created by MS SQL server
tool to store record in proper manner. It will construct the form by using Oracle Application
Express (APEX).
TASKS
Entity Relationship Diagram
Figure 1 ER Model
Entity relationship diagram is a type of graphical representation that can be shown all entities
and its specific attributes (Abad iand et.al., 2018). Each one has established a relationship
between one and more tables. It should be containing values in each column of database system.
It has some specific primary key and foreign key in the database system. It is an essential part of
DBMS that help to establish a relationship between one or more tables. In this diagram, it shown
3

all the necessary attributes of each table in proper manner.
Data dictionary:
Entities Attributes
Food table  Food_no (PK)
 Food_name
 Food_type
 Food_menu
 Food_expiry_hour
 Food price
 Restaurtant_id (FK)
Restaurant table  Restaurant_ID (PK)
 Restaurant_Name
 Restaurant_Address
 Restaurant_Phone
 Restaurant_Email
 Restaurant_PIC
Order table  Order_ID (PK)
 Order_Date
 Order_Qty
 Order_Amount
 Food_No (FK)
 Cust_ID (FK)
Customer table  Cust_ID (PK)
4

 Cust_Name
 Cust_Address
 Cust_Phone
 Cust_Email
Table:1
Database Name: - FoodDB
5

6