Assessment 1 Database Analysis and Design

Assessment 1 Database
Analysis and Design

Table of Contents
INTRODUCTION...........................................................................................................................1
MAIN BODY...................................................................................................................................1
Problem Identification............................................................................................................1
Company requirements...........................................................................................................1
System design techniques.......................................................................................................2
Entity Relationship Diagram..................................................................................................7
UML Diagrams.....................................................................................................................14
CONCLUSION..............................................................................................................................18
References:.....................................................................................................................................19

INTRODUCTION
Database management system is referred as the management and administrating the big
or little information or data in the company to add, find, alter and remove the data, this is done so
that operation of the company can be ceaseless in future (Cionni, Dimalanta, Breen and
Hamilton, 2018). Data analysis via digital method is an effortless way to execute so that
favourable manner can be select out to study the information and data for amended forthcoming
thought process. The following discussions is made on the problem identification, company
requirements, system design techniques, entity relationship diagram and UML diagrams in
circumstance of the given case examination with proper findings and conclusion in command to
evolve the digital catering services system to pull off the customers and stakeholders in an
effectual and prompt way.
MAIN BODY
Problem Identification
Celtic Caterers, which is located in Wales provides catering services for the local
community events and they are planning to expand their services to other cities. Currently they
do not have a computerized system to manage and operate their business functions as they use a
manual paper-based system to handle orders and other operations. Due to this issue as they are
getting lots of orders, they are currently struggling to handle the complexity of the business.
Therefore, company has requested to design and develop an online-based database solution to
handle their business operations. The following requirements have been identified from the case
study given in the project brief.
Company requirements
 Store manager must take orders from the customers
 During the conversation, store manager will explain the events, products and the
available dates and the price for the customer.
 If the customer agrees, store manager will issue an invoice to the customer and based on
the cost, customer will pay an advance or full amount and book for the event.
 And then store manager will pass the order details to the kitchen staff and then kitchen
staff will prepare everything for the event(s).
1

System design techniques
Structure charts
It is characterized as the primal method of structured system design, it is reasoned as the
graphical presentation of the standard series and the relation among them (García-Martínez,
Sanz, Muñoz-Cruzado and Perié, 2020). It is chiefly of 2 kinds, structured charts and program
structured charts. First one presents the abbreviated crack-up of the role of the software without
taking any circumstance like package into account. Second one renders the actualized programs
and procedures which are to be evolve up or build up. Structure charts presents the structure of
the system. It is also can be utilized to display case the data flow rate among modules. It is not
answerable for the demonstration of the rate of flow of control and more over it also not provide
any data about the sequencing of circumstances and status trial. The below fig is of the plan
structure chart which instances the heterogeneous signalling that can be used. A box represents
the module, lines which are conjunctive the modules are presenting the calling series.
Parameters, qualified calls and iterations are also can be depicted on the structured charts as well
by utilizing the signalling shown.
2

Data flow oriented design
It is a method of derivation the plan of the modules which are interdependent on the
information flow diagram. It is advisable tool for processing system which are adjusted in quality
for illustration accountancy, stock list and pay sheet (Davis and Yen, 2019). It has some
procedure which are as follows: 1st is the explanation of the uppermost model, 2nd is the
determination of the leading input line, processing centre and end result line. It can also be
acknowledged by correspondence of flow rate of the information. 3rd is explanation of module
for to each one and all end result and input line and the processing centre. In cause if process
centre, explanation of sub component for to each one and all of the processes which are
happening in a collateral form. 4th explains the step such as for to each one and all module
which are at lower level, take the part which are related of the information flow diagram and
3

repeating of step 2 and 3 until and unless it is amply decomposed. 5th step explains the designing
in command to cut down the connection and addition the modules coherence. It is necessary
because information flow diagrams never take the account of flow rate of the power, packaging
thought process and trivial ways.
4