Database Management System

Running Head: DATABASE MANAGEMENT SYSTEM
Title:
Database Management System
Student ID:
Student Name:

1
DATABASE MANAGEMENT SYSTEM
Table of Contents
Background.........................................................2
Requirements.....................................................2
Mission statement................................................2
DBMS Selection...................................................2
ERD................................................................3
Normalised Schema..................................................3
Database schema....................................................4
Foreign Key constraints............................................4
SQL Statements.....................................................5
Group report......................................................12
Challenges and solution...........................................12
Bibliography......................................................14

2
DATABASE MANAGEMENT SYSTEM
Background
Requirements
The business rules required for the implementation of the
database are described below:
 The details of the patrons are to be stored in the system with
the customer number being unique attribute which is to be used
for the reference of the customer data.
 The details of the departments are to be stored in the
database.
 The names of the stores and their addresses and fax are to be
stored in the system identified uniquely by their store
number.
 The details of the products and their prices are to be stored
in the system.
 The details of the orders made by the customers in the system
and employees handling the orders are required to be stored in
the system.
Mission statement
The system would be helpful for the organization in
maintaining their data also provide the organization with efficient
data storing options that would be increasing the business
efficiencies of the organization.
DBMS Selection
The Organization has chosen phpmyadmin mysql available on the
xampp server to develop their database that would be supporting
their backend process for the development of the system.

3
DATABASE MANAGEMENT SYSTEM
ERD
Normalised Schema
Department (DepartmentNumber (pk), DepartmentName)
Store (StoreNumber (pk), StoreName, Address, Fax)
Employee (EmployeeNumber (pk), LastName, FirstName, StoreNumber
(fk), DepartmentNumber (fk))
Products (ProductNumber (pk), ProductTitle, UnitPrice)
Orders (OrderNumber (pk), OrderQuantity, ProductNumber, OrderDate,
CustomerNumber (fk), EmployeeNumber (fk))
Payroll (PayrollID (pk), EmployeeID (fk), Amount, PaymentDate)