Database Analysis and Design Report: A Case Study of Fast Food Hub UK

This report provides a comprehensive analysis and design of a database system, focusing on its application for Fast Food Hub UK. It includes an Entity Relationship Diagram (ERD) illustrating the relationships between entities such as menu items, ingredients, customers, and suppliers. A detailed data dictionary outlines the attributes of each table within the database, including customer information, orders, ingredients, and staff details. The report also presents evidence of linked tables, showcasing the relational nature of the database. Furthermore, it features examples of reports and forms designed for efficient data management and user interaction. The conclusion emphasizes the benefits of a well-designed database for organizing and accessing business data effectively.

DATABASE ANALYSIS
AND DESIGN

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
MAIN BODY..................................................................................................................................1
Database used..............................................................................................................................1
Entity Relationship Diagram.......................................................................................................1
Data dictionary.............................................................................................................................3
Evidence that tables in database are linked together...................................................................4
Reports.........................................................................................................................................6
Forms...........................................................................................................................................8
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................12

INTRODUCTION
Database is the organized collection that include the structured information, any typical
data which can be easily retrieved from its system. Database management system define as the
computerized system which keeps the data and allow the users to perform the different
operations, also enable the user to manipulate the data (Starks, Pratt and Last, 2019). There are
the different type of the database which can be used by the organization to manage their business
related data. Database allows the organizations to arrange their data in organize manner at one
place so it will be easier to access the data. MS's access is one of the database which provides the
flexibility in order to manage the data. It is the relational database that is used to store the
appropriate data in the SQL server. It is beneficial to cope up with the problems when arise in
managing the data in excel or in other spreadsheets. Database is design according to the
requirements, as every business has their different data to be managed, so it designs accordingly.
In the database system any typical data can be read, write or updated in a effective manner. Fast
food hub UK's food business which is located in the Birmingham, they have the varieties of the
food and services which is able to enhance their brand image. This report covers the area which
involves the Entity relationship diagram, documentation which involves the tables. It further
illustrates the data dictionary, reports and forms.
MAIN BODY
Database used
Ms access database is the information management appliance, it is the database management
system that joins the relational database with the “graphical user interface”. It manages and
stores the data in its own created format. MS access is the widely used database in the business
as it is more efficient in analyzing the large amount of data. It provides the flexibility in using,
with its intuitive designing features. This database system is helpful in developing the functional
application on time. As by using the visual basic user can easily create the forms and reports.
Entity Relationship Diagram
ER diagram shows the connectivity of the entity which are present in the database. Entity define
as the object of the data whereas the entity set is the collection of the similar other entities. Every
entities have the attributes which involves the properties and information about its parent node. It
is the graphical representation where it shows the relationship between the objects in a database
1

management system. ER diagram process the data modeling approaches which is used to explain
the business processes and also define as a base of the relational database (Popov and Fridman,
2018).
Importance of the ERD:
This diagram is beneficial as it helps to give the visual initial feature in the database design,
which is mainly used to identify the information system that are required by the organization. It
is essential for organizing the data, through which the user can easily understand the data. Entity
are represent in a rectangle shape while relationship represents in a diamond shape or the
attributes can be represented in a oval shape. Every entity can have the more than one attributes.
In this diagram it shows the different entities which are menu, ingredients, customer, supplier
every entity have their different attributes which is connected with the relation (Samaiya and
Agarwal, 2018). ER diagram is mainly divides in two type in which one is conceptual that is
used as base for the logical data and the other one is physical ERD represent the actual database
design.
2

Data dictionary
Data dictionary define as the collection of the information which involves the attributes of the
data as name, definition which are present in the data base management system. It also gives the
metadata, It gives the meaningful and understandable description about the data. Data dictionary
is beneficial as it provides the information as whom have the access for the data and what is the
physical location of the data. It is reliable as it helps to done the things without wasting any time.
Database user does not allow to access the data dictionary as it is only handles or manage by the
database administrator.
Active data dictionary:
In this the data is automatically updated whenever the changes are made in the database system.
That's why it is called as active data dictionary due to its self updating feature.
Passive data dictionary:
This data dictionary can't manage easily, it is managed separately and it does not update when
the data changes in database, user need to separately update it to match it with the database
(Sharma, 2017).
Table name Attributes
Customer  Cust_id (PK)
 Cust_name
 Cust_address
 Cust_phone_no
Customer_order  C_order_id (PK)
 cust_id (FK)
 item_id (FK)
 item_price
 C_order_date
Ingirdient_order  I_order_id (PK)
 Supplier_id (FK)
 ingridient_id (FK)
 ingridient_price
 I_order_date
3

Ingredients  ingridient_id (PK)
 ingridient_name
 ingrident_price
 ingrident_quantiy
Menu  item_id (PK)
 item_name
 item_price
 ingridient_id (FK)
Staff_members  staff_id (PK)
 staff_ name
 staff_ designation
 Store_id (FK)
Store  Store_id (PK)
 Store_location
Supplier  Supplier_id (PK)
 Supplier_name
 ingridient_id (FK)
Evidence that tables in database are linked together
Customer table
Custoemr_order table
4

Ingredient_order table
Ingredient table
Menu table
Staff_members table
5

Store table
Supplier table
Reports
Reports is useful to present the data in a print, it is helpful to represent the database components
in the easy format which can be easily read out. User can also customize the report to make it
look appealing.
Customer order report
6

Ingredient’s order
Store and staff members report
7

Forms
Forms are usually used to implement, modify the records. Main reason to design the form as it is
gives the easiest way to lead the people for entering the appropriate data. Whenever the data is
enter in the form it directly flows to the database designer and goes to the related database table
(Mershad and Hamieh, 2021). It make the task easier as using the extensive tables can confuse
the user, therefore to reduce the redundancy forms are created to enter the data in easy way.
Customer order MASTER Form
8

Custoemr order Sub form
Ingredients form
9

Menu form
CONCLUSION
From the above report it is concluded that database is designed to make the work easier.
It enables the organizations to store their data at one place, also provides the easy access so any
time they can access the information. This report describes the description of the database which
10

is used, ER diagram and the data dictionary which is explained in the report. It further explained
the Data dictionary and description about the forms and reports, along with the diagrammatic
representation that is included in the report.
11

REFERENCES
Mershad, K. and Hamieh, A., 2021. SDMS: smart database management system for accessing
heterogeneous databases. International Journal of Intelligent Information and Database
Systems. 14(2). pp.115-152.
Popov, S.G. and Fridman, V.S., 2018. Review of methods for dynamic distribution of data in
distributed database management systems. Computing, Telecommunication and
Control. 11(4). pp.82-107.
Samaiya, S. and Agarwal, M., 2018, January. Real time database management system. In 2018
2nd International Conference on Inventive Systems and Control (ICISC) (pp. 903-908).
IEEE.
Sharma, N., 2017. Overview of the Database Management System. International Journal of
Advanced Research in Computer Science. 8(4).
Starks, J.L., Pratt, P.J. and Last, M.Z., 2019. Concepts of database management. Cengage
Learning, Inc..
12