Database management system for a trading company

Generating invoices, manipulating inventory transactions and checking for low balance of stock have been inevitable daily operations for an engineering trading company, Tatho Enterprise. These manually tedious tasks will soon be replaced by a computerized database designed to cater to the needs of t...

Full description

Bibliographic Details
Main Author: Teo, Zhi Yin.
Other Authors: Lee Yong Tsui
Format: Final Year Project (FYP)
Language:English
Published: 2012
Subjects:
Online Access:http://hdl.handle.net/10356/50202
_version_ 1826128512886505472
author Teo, Zhi Yin.
author2 Lee Yong Tsui
author_facet Lee Yong Tsui
Teo, Zhi Yin.
author_sort Teo, Zhi Yin.
collection NTU
description Generating invoices, manipulating inventory transactions and checking for low balance of stock have been inevitable daily operations for an engineering trading company, Tatho Enterprise. These manually tedious tasks will soon be replaced by a computerized database designed to cater to the needs of this company. The proposed project will be developed using Microsoft Office Access 2010. In this project, the database is designed according to the company’s needs. Frequent consultation with the director of Tatho Enterprise had allowed the project to be steered towards the needs of the company. In order to reduce redundancy, the project is built on the basis of normalization rules of database design. The project is incorporated into Tatho Enterprise’s operations at different stages of development so that any arising issues can be resolved almost immediately. This will also allow the developer to understand the needs and requirements of the users and perfect the database management system’s user interface. After reviewing the project, Tatho Enterprise expressed satisfaction and has confidence that the implementation of the project will increase their efficiency at work. However, the author believes that more features can be included in the database system management to fully utilize the program’s capability. Future developments will include features such as increased database security and preparing accounts.
first_indexed 2024-10-01T07:26:10Z
format Final Year Project (FYP)
id ntu-10356/50202
institution Nanyang Technological University
language English
last_indexed 2024-10-01T07:26:10Z
publishDate 2012
record_format dspace
spelling ntu-10356/502022023-03-04T18:27:10Z Database management system for a trading company Teo, Zhi Yin. Lee Yong Tsui School of Mechanical and Aerospace Engineering DRNTU::Engineering Generating invoices, manipulating inventory transactions and checking for low balance of stock have been inevitable daily operations for an engineering trading company, Tatho Enterprise. These manually tedious tasks will soon be replaced by a computerized database designed to cater to the needs of this company. The proposed project will be developed using Microsoft Office Access 2010. In this project, the database is designed according to the company’s needs. Frequent consultation with the director of Tatho Enterprise had allowed the project to be steered towards the needs of the company. In order to reduce redundancy, the project is built on the basis of normalization rules of database design. The project is incorporated into Tatho Enterprise’s operations at different stages of development so that any arising issues can be resolved almost immediately. This will also allow the developer to understand the needs and requirements of the users and perfect the database management system’s user interface. After reviewing the project, Tatho Enterprise expressed satisfaction and has confidence that the implementation of the project will increase their efficiency at work. However, the author believes that more features can be included in the database system management to fully utilize the program’s capability. Future developments will include features such as increased database security and preparing accounts. Bachelor of Engineering (Mechanical Engineering) 2012-05-31T02:17:00Z 2012-05-31T02:17:00Z 2012 2012 Final Year Project (FYP) http://hdl.handle.net/10356/50202 en Nanyang Technological University 102 p. application/pdf
spellingShingle DRNTU::Engineering
Teo, Zhi Yin.
Database management system for a trading company
title Database management system for a trading company
title_full Database management system for a trading company
title_fullStr Database management system for a trading company
title_full_unstemmed Database management system for a trading company
title_short Database management system for a trading company
title_sort database management system for a trading company
topic DRNTU::Engineering
url http://hdl.handle.net/10356/50202
work_keys_str_mv AT teozhiyin databasemanagementsystemforatradingcompany