Web and Database Concepts: Designing a Database for Fast Food Hub

This report provides an overview of web and database concepts, focusing on the design of a database for a fast food business named Fast Food Hub. It covers essential elements such as Entity Relationship (ER) diagrams, which visually represent the relationships between entities like customers, orders, items, staff members, and ingredients. The report also details the importance and types of data dictionaries, emphasizing their role in maintaining data consistency. Furthermore, it explains the normalization process and presents database tables, forms, and reports designed to efficiently manage the fast food hub's data, including customer details, item inventory, staff information, order processing, and supplier management. The conclusion highlights the benefits of a well-structured database system in enhancing operational efficiency and data accessibility for the organization.

INTRODUCTION TO WEB
AND DATABASE
CONCEPTS

Table of Contents
INTRODUCTION...........................................................................................................................3

INTRODUCTION
Web defines as a composite system which involves the interconnected elements. It is the part of
computer system which include the documents that are linked together. Database concept is the
approach of organizing the information in the structured form, or to store the relevant data
electronically into the system (Zemmouchi-Ghomari, Djouambi and Chabane, 2018). It is
managed by the data base management team to reduce the redundancy in the system. Fast food
hub is successful food business located in Birmingham, England. This report will cover as
organization wants to develop their database which involves the entity relationship diagram,
tables, forms for creating the database.
MAIN BODY
ER diagram
It defines as the relationship between the set of entities which are involved in the database. Entity
can be understood as the object or data component. It is the graphical representation which
depicts or show the relationship of object which can be customer, object, place or events. Entity
diagram helps the user to easily understand the database concept through the diagram. For this
report the entity diagram involves the entity as customer, order, item, staff member and
ingredient which is required to prepare the product. As fast food organization is able to increase
their customer base, but they are facing problem in the paper work which can be loss for them if
any worst situation occur. It is of type which are many to many, one to many or many to one. As
one to many define as one record in the table associated with many records of the other table,
one to one means one record of table have relation with only one record of the table, and many to
many means multiple records in the table are associated with other table's multiple records.

Figure 1ER diagram

Relationship
Data dictionary

Data dictionary is defined as the collection of all the information that are present in the database.
Data dictionary is also responsible for providing the metadata which is the data that give the
information about another data (Arai, 2021). It mainly summarizes the basic information about
findings. In data base management system it is the repository of information which is about the
data set. As any changes in database structure will reflect in the data dictionary. Two type of data
dictionary can be seen one is active and other one is passive data dictionary.
Active data dictionary:
It is the type of data dictionary which is very consistent and actively managed by the data base
management system. If any changes and alteration can be made in database structure then it can
be seen in the database dictionary with the help of this attribute. It is directly updated by the
database system. As for the fast food organization if they are making any changes regarding their
services or terms it will directly seen in their database data dictionary.
Passive data dictionary:
This type of data dictionary is not managed or updated by the database management system
unlike active data dictionary which is managed by the system. It generally used for copying the
log from the active database to apply to keep up to date. It is not usually used by the clients.
For this report the customer, items, staff member, order, supplier, ingredient and supplier
order data dictionary are made. As it effectively assist to avoid the inconsistencies in data which
makes the user to easily develop the understanding about the database system. As it enables the
fast food organization to collect consistent data to use data for good performance of their
business (Yang and Liu, 2018).
Entities Attributes
Customer_details  Cust_Id (PK)
 Cust_name
 Cust_phoneNo
 Cust_address
Items  Item_id (PK)

 Item_name
 Quantity_available
 Price
 Ingredient_Id (FK)
Staff_members  Staff_id (PK)
 Staff_name
 Staff_PhoneNo
 Designation
Order  Order_id (PK)
 Cust_Id (FK)
 Order_date
 Item_Id (FK)
 Quantity_ordered
 Cust_address
 Total
 Payment_method
 Cust_address
 Delivery_person (Staff_id) (FK)
Ingredients_required  Ingredient_Id (PK)
 Ingredient_name
Supplier  Supplier_id (PK)
 Supplier_name
Supplier_order  S_order_id (PK)
 Supplier_id (FK)
 Ingredient_Id (FK)
 Qty
Normalization
Cust_name
Item
Order date
total
Customer_id
Customer name
Customer phone
Cust_Id
Cust_phoneNo
Cust_address
Cust_id
Order_date
Cust_address
Total

1NF 2NF 3NF
Tables created
Tables in database are defined as database object which involves all the information in database.
In this the data is in organized or logical form. Every row in the table represent the unique
record, and column in the table record the field. It is made to easy access to the information,
as for the fast food organization their table involve the data about their customer which
involves their id, name address and contact details (Pullan and Li, 2018).
 Customer_details table
 Above customer table shows the entries which is made in the company's data base system. It
shows the unique id of the customer with their details so it will be easier for the company to
access the detail to provide services and products.
Order_id
Item
Total Item_id
Item_name
Price

 Items table
 As for the item table it shows the entry of each item which involve the item id, name, its
availability to make it easier for the staff to effectively run the services.
 Staff_members table
 Staff member table shows the entry of the employees as their name, id so that their data can
be maintained for effective payroll.

 Order table
 Ingredients_required table
 Supplier table

 Supplier_order table
Order table involves the detail as number of order required by the customer, payment method.
Ingredient table and supplier table shows all the entries of the product and include the supplier id
for purchasing the raw materials form them.
Report
The above report is form as on navigation pane by clicking on the table for which the report need
to be form. Then on create tab click on the report which allow to develop the report and display
out in the layout view (Krawczyk, 2018). Therefore, for the customer, item, or order the report
has been made.
Customer orders

Total sales of items