Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak

This study was focus on designed database system for web-based computer inventory system for Jabatan Pelajaran Perak namely JPCIS. A methodology is defined for the design of this relational database. The methodology is presented as a systematic guide to the five main phases of database design namely...

Full description

Saved in:

Bibliographic Details
Main Author:	Shafie, Abd Rashid
Format:	Thesis
Language:	eng eng
Published:	2005
Subjects:	QA71-90 Instruments and machines
Online Access:	https://etd.uum.edu.my/1998/1/rashid.pdf https://etd.uum.edu.my/1998/2/1.rashid.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-uum-etd.1998
record_format	uketd_dc
spelling	my-uum-etd.19982013-07-24T12:13:59Z Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak 2005 Shafie, Abd Rashid Osman, Baharuddin Faculty of Information Technology Faculty of Information Technology QA71-90 Instruments and machines This study was focus on designed database system for web-based computer inventory system for Jabatan Pelajaran Perak namely JPCIS. A methodology is defined for the design of this relational database. The methodology is presented as a systematic guide to the five main phases of database design namely as follows (1) Requirement Analysis, (2) Conceptual Database Design, (3) Logical Database Design, (4) Physical Database Design, and (5) Prototyping. The data requirements are defined and conceptualised using an extended Entity-Relationship Model (ER Model), with the extensions being additional semantics such as relationship, optional relationship, and the generalisation abstractions. There are three categories of users and 15 entities been identified. Cross-Referencing Transaction been used to analyse transactions. The main objective is to understand the functionality of transaction (query) run on the database. In Logical Database Design with involved build and validate local logical design, Data Flow Diagram been drawn to visualized it. Data Flow Diagram been used to analyse transactions. The main objective is to understand the functionality of transaction (query) run on the database. Finally automated prototyping been used to validate the database system and the test shown that it meet the users needs. 2005 Thesis https://etd.uum.edu.my/1998/ https://etd.uum.edu.my/1998/1/rashid.pdf application/pdf eng validuser https://etd.uum.edu.my/1998/2/1.rashid.pdf application/pdf eng public masters masters Universiti Utara Malaysia
institution	Universiti Utara Malaysia
collection	UUM ETD
language	eng eng
advisor	Osman, Baharuddin
topic	QA71-90 Instruments and machines
spellingShingle	QA71-90 Instruments and machines Shafie, Abd Rashid Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak
description	This study was focus on designed database system for web-based computer inventory system for Jabatan Pelajaran Perak namely JPCIS. A methodology is defined for the design of this relational database. The methodology is presented as a systematic guide to the five main phases of database design namely as follows (1) Requirement Analysis, (2) Conceptual Database Design, (3) Logical Database Design, (4) Physical Database Design, and (5) Prototyping. The data requirements are defined and conceptualised using an extended Entity-Relationship Model (ER Model), with the extensions being additional semantics such as relationship, optional relationship, and the generalisation abstractions. There are three categories of users and 15 entities been identified. Cross-Referencing Transaction been used to analyse transactions. The main objective is to understand the functionality of transaction (query) run on the database. In Logical Database Design with involved build and validate local logical design, Data Flow Diagram been drawn to visualized it. Data Flow Diagram been used to analyse transactions. The main objective is to understand the functionality of transaction (query) run on the database. Finally automated prototyping been used to validate the database system and the test shown that it meet the users needs.
format	Thesis
qualification_name	masters
qualification_level	Master's degree
author	Shafie, Abd Rashid
author_facet	Shafie, Abd Rashid
author_sort	Shafie, Abd Rashid
title	Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak
title_short	Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak
title_full	Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak
title_fullStr	Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak
title_full_unstemmed	Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak
title_sort	relational database design for web-based computer inventory system jabatan pelajaran negeri (jpn) perak
granting_institution	Universiti Utara Malaysia
granting_department	Faculty of Information Technology
publishDate	2005
url	https://etd.uum.edu.my/1998/1/rashid.pdf https://etd.uum.edu.my/1998/2/1.rashid.pdf
_version_	1747827244439437312

Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak

Similar Items