Database Design and Development | BKC company

PROGRAM TITLE: Database Design and Development
UNIT TITLE: Database Design and Development
ASSIGNMENT NUMBER: 1
ASSIGNMENT NAME: Assignment 1
SUBMISSION DATE: 19/3/2022
DATE RECEIVED: 19/3/2022
TUTORIAL LECTURER: Pham Son Tung
WORD COUNT: 4333
STUDENT NAME: Hoang Van Hiep
STUDENT ID: BKC 12227
MOBILE NUMBER: 0866814728

Summative Feedback:
Internal verification:

Table of Contents
A. Introduction............................................................................................................ 5
B. System Requirements............................................................................................ 5
I. Analysis of the management purpose of the company........................................5
II. Data management system..................................................................................6
1. Objects to manage........................................................................................... 6
2. Properties of Objects........................................................................................ 7
3. Relationships between entities......................................................................10
IV. Relational database system.............................................................................14
1. RDBMS........................................................................................................... 14
2. Database Deployment.................................................................................... 16
3.Database Deployment Flowchart....................................................................18
4.Implement a query language..........................................................................18
V. Data Normalization........................................................................................... 23
1. What is normalization?...................................................................................23
2. The goal of data normalization.......................................................................23
3. Types of data normalization...........................................................................24
C. System security and database maintenance........................................................25
I. Security.............................................................................................................. 25
1. Granting and revoking user rights..................................................................25
II. Database Maintenance...................................................................................... 28
D. Test run & check the system............................................................................... 28
I. Test run.............................................................................................................. 28
II. Check................................................................................................................ 29
E. Technical and User Document.............................................................................. 31
I. Configuration requirements................................................................................ 31
II. Database Installation Guide..............................................................................31
III. SQL Server 2019 User Guide............................................................................39
1. Execute new commands................................................................................39
2. Execute commands........................................................................................ 40
3. Instructions to get the data form base...........................................................40
Reference links:........................................................................................................ 41

A. Introduction
Currently in the development era, small and large companies have been using advanced
technology and systems to manage data. But there are still companies that are still using old
management systems that do not meet the requirements. meet the growing demand for growth.
And BKC is one of them. Up until now, BKC has managed their business using a computer
system developed by a university student. learned 5 years ago. The system was too slow and no
system documentation was generated when it was deployed that it was not possible to easily
make changes to the system. So BKC hired a development team. database at a large IT
consulting company to design, create and deploy a new database system to meet the current and
future needs of customers. Director of BKC believes, As business needs evolve and to manage
businesses successfully they must invest in new technology and systems to run the company
efficiently.
B. System Requirements
I. Analysis of the management purpose of the company
BKC Company has set out the requirements in the system to manage human resources in
the company and their business activities, specifically as follows. The first is human resource
management. The company has a lot of employees working together. To be able to manage many
employees, the company needs to have full basic information of an employee including full
name, date of birth, phone number, address, email address.Each employee Employees have an
account so they can log in to the company's general network to be able to get company data. To
be able to manage easily to be able to log in, employees need to enter their username and
password. and email address for account registration. We have taken into account that the
company has many levels, so in addition to the above login information, they also have to choose
more in the account type section. Account type will have appropriate options. suitable for each
member of the company to be able to manage different data. With a company that is on the way
of growth and expansion, what they do first is to open sales agents. Each sales agent can sell
many products with many management staff. Opening so many agents also helps products to
reach more customers easily. Next is product management. Their double glazed products are
individually manufactured with different quality and design, along with different prices. Not only
that, but they also deal in windows and doors that are ordered from a number of houses. Large

supply and stock. They also make several types of windows and doors according to the
individual requirements of each customer. Each sales agent has different detailed orders and
invoices, and customers also have different requirements. so.Next, is customer management.A
customer has an account to be able to log in to purchase.A registered account includes
information such as full name, date of birth, phone number...etc. Customers also have a medium
account to manage customer information easily. Finally, manage orders. Invoices include
information such as order code, customer code, employee code, agent code. ,status and date of
order. When paying, customers will receive a detailed invoice including detailed invoice code,
product code, price, etc. Each invoice will be created and stored by an employee in charge.
II. Data management system
1. Objects to manage
- account
- employees
- salesAgent
- customer
- productCompany
- productType
- product
- supplier
- invoice
- detailedInvoice

2. Properties of Objects
1. Account
Object Describe Properties
account accountID
username
password
email
accountType
2. salesAgent
Object Describe Properties
salesAgent salesAgent ID
name
address
phoneNumber
3. Employees
Object Describe Properties
employees employeesID
name
dateOfBirth
phoneNumber
address

email
4. customer
Object Describe Properties
customer customerID
name
dateOfBirth
phoneNumber
address
email
5. supplier
Object Describe Properties
supplier supplierID
name
address
phoneNumber
email
6. productType
object Describe Properties
productType productTypeID
name
7. productCompany

Object Describe Properties
productCompany productCompanyID
name
8. product
Object Describe Properties
product productID
name
dateOfManufacture
price
amount
goodsCondition
9. invoice
Object Describe Properties
invoice invoiceID
date
goodsCondition
10. detailedInvoice
Object Describe Properties
detailedInvoice quantityPurchased
cost