Database Computing Project 2022

Running head: DATABASE COMPUTING
Database Computing
Name of the Student
Name of the University
Author’s note:

DATABASE COMPUTING1
Table of Contents
Introduction:....................................................................................................................................2
Problem Description:.......................................................................................................................2
Use Case and Class Diagram:..........................................................................................................4
Use Case:.....................................................................................................................................4
Class Diagram:.............................................................................................................................5
Normalization:.................................................................................................................................5
Designing and Implementing Database:..........................................................................................7
Conclusion:....................................................................................................................................14
Bibliography:.................................................................................................................................16

DATABASE COMPUTING2
Introduction:
Database can be referred to the organized set of information. These information are
stored in a specific computer location so that information can be accessed later. Each database
allows four operations such as create, update, read and delete (Eckstein and Schultz 2018).
Database management system is a piece of application that provides an interface to the user
through which database operations can be executed. Each operation in database is either write or
read. Read operations does not affect database but write operations update database schema.
Structured data has a single structure for all the instance of a particular entity. Relational
databases uses these structured data to create information storage that establishes defined link
between data. MS Access is a relational database developed and maintained by Microsoft.
Unlike other database management systems like MySQL, Oracle, SQL Server, MS Access
provides various features to generate forms and reports to show data a comprehensive way
without using any external technology (Arulraj and Pavlo 2017).
This report will consists of database system development for a warehouse. Details
description of the warehouse will be provided in the report. Each development decision made in
this project will be based on the issues and requirements of warehouse. UML diagrams like Use
Case and Class diagrams will be provided to graphically represent the dynamic behavior and
static structure of the database respectively (Sahoo and Mohanty 2017). Finally, a database will
be developed using MS Access.
Problem Description:
My family runs a vegetable shop that sales fresh vegetables to local customers. High
quality fresh vegetables are hard to come by these days. That’s why our family shop had

DATABASE COMPUTING3
experienced increase in sales from last year. Customers can book their order through phone. One
person responsible for accepting the order will write down the lists of item into a piece of paper.
As papers based information is hard to manage, often orders related information goes missing. If
it happens, then customer has to reorder after coming to shop and wait until their order is ready.
Manual record of information is often error prone. Staff may write wrong item or quantity which
may lead to wrong order. These issues are affecting customer experiences. Our shop is facing
difficult time in maintaining customer relationship due to inaccurate order related issues.
Business is experiencing delay in processes.
Another major issue my family business facing is that no data related to warehouse is
recorded into any reliable location. At time of accepting order from customer, shop employee
does not have any idea of stock available in warehouse. It results into promising delivery of
products that are not available in warehouse. Often due to miss information of predictable sales,
warehouse store more stock of a particular item or items that required. This results into waste of
product which in-turn reduce profit margin of business. If details of products along with
available stock can be stored then it will be easy to maintain business.