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...
Saved in:
| Main Author: | |
|---|---|
| Format: | Thesis |
| Language: | en en |
| Published: |
2005
|
| Subjects: | |
| Online Access: | https://etd.uum.edu.my/1998/1/rashid.pdf https://etd.uum.edu.my/1998/2/1.rashid.pdf https://etd.uum.edu.my/1998/ |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1833435769478316032 |
|---|---|
| author | Shafie, Abd Rashid |
| author_facet | Shafie, Abd Rashid |
| author_sort | Shafie, Abd Rashid |
| building | UUM Library |
| collection | Institutional Repository |
| content_provider | Universiti Utara Malaysia |
| content_source | UUM Electronic Theses |
| continent | Asia |
| country | Malaysia |
| 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 |
| id | my.uum.etd-1998 |
| institution | Universiti Utara Malaysia |
| language | en en |
| publishDate | 2005 |
| record_format | eprints |
| spelling | my.uum.etd-19982013-07-24T12:13:59Z https://etd.uum.edu.my/1998/ Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak Shafie, Abd Rashid 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 NonPeerReviewed application/pdf en https://etd.uum.edu.my/1998/1/rashid.pdf application/pdf en https://etd.uum.edu.my/1998/2/1.rashid.pdf Shafie, Abd Rashid (2005) Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak. Masters thesis, Universiti Utara Malaysia. |
| spellingShingle | QA71-90 Instruments and machines Shafie, Abd Rashid Relational Database Design for Web-Based Computer Inventory System Jabatan Pelajaran Negeri (JPN) Perak |
| title | 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_short | 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 |
| topic | QA71-90 Instruments and machines |
| url | https://etd.uum.edu.my/1998/1/rashid.pdf https://etd.uum.edu.my/1998/2/1.rashid.pdf https://etd.uum.edu.my/1998/ |
| url_provider | http://etd.uum.edu.my/ |