Assessment 1 Database Analysis and Design

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