Database Design and ERD Creation

A higher access level was provided for the employees who would log in to the latter platform as administrators with the capability of updating the stock of an item, creating new inventory and content management services. Hence, there existed a database in the corporate which was MySQL based.

Problem and constraints.

The business organization had incurred operational costs of running its owned database server and webserver in its own intranet. They would need also to add a layered security to protect its MySQL database.

Database environment objectives

The objective of the database environment is to be able to manage the various data that are involved in the online transactions and purchase of items. The database environment would also manage the existing inventory and help to trace orders and shipping processes.

Scope and boundaries

The organization would need fulfill the following requirements of the database;

a. 3 tier architecture – it would need the presentation layer which is in the form of the public webpage and the android up; the application layer which shall reside in the web server and the database layer which would reside in the database server. The layering would provide a high security of the database

b. Integration of a firewall to secure traffic in and out the private network

c. Creation of the web site to make orders

d. Creation of the android app to also make online orders

e. Design of the database schema to hold inventory, order details and account sessions among other relevant information

Data specifications

The organization manages data based on the following entities and their attributes;