Introduction to Web and Database Concepts

This report covers the basics of web and database concepts, including entity relationship diagrams, data dictionaries, tables, forms, and reports. It also includes examples and tables for a fast food organization's database. Subject: Computer Science, Course Code: NA, Course Name: NA, College/University: NA

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

Form
for creating the form for the table click on the table or query then select form tab on navigation
pane then the form will be made.
Customer
Item

Items ordered by customers
Order form -default menu

Order subforum
CONCLUSION
From the above report it is concluded that the web and database management system are
provided a support to the organization to logically arrange their data. As by using this would
enable the organization to easily access to the data that would be beneficial for managing the
company 's operations effectively. This report covers the areas which involves the Entity
relationship diagram, which is made for every entity who has role in the organizational activity.
It further includes the data dictionary to collect the information also described the types in data

dictionary. It lastly involves the table, form and report structure for the database.

REFERENCES
Books and journals
Arai, K., 2021, November. Method for Web: GIS System Applicable to Assimilation Model
Database Constructions. In Proceedings of the Future Technologies Conference (pp. 814-
825). Springer, Cham.
Krawczyk, A., 2018. A concept for the modernization of underground mining master maps based
on the enrichment of data definitions and spatial database technology. In E3S Web of
Conferences (Vol. 26, p. 00010). EDP Sciences.
Pullan, G. and Li, X., 2018. dbslice-Flexible, Web-Based, Database-Driven Visualization.
In 2018 AIAA Aerospace Sciences Meeting (p. 1173).
Yang, X. and Liu, J., 2018, June. Using Join Operation in Relational Database to Composite
Web Services. In World Congress on Services (pp. 77-90). Springer, Cham.
Zemmouchi-Ghomari, L., Djouambi, A. and Chabane, C., 2018. Proposal for a Mutual
Conversion Relational Database-Ontology Approach. International Journal of Modern
Education & Computer Science. 10(7).
1