Library Management System
Valeriano Fugoso Public Library Integrated Library System
A Case Study
Presented to the
Department of Information & Computer Studies
Faculty of Engineering
University of Santo Tomas
In Partial Fulfillment of the Requirements in
Database Management Systems
October 2010
Title Page
Table of Contents 1. Introduction. 2. About the Company 1. Background and History 2. Organizational Chart 3. Contact Person/s 3. The Current System 1. Detailed Description of the Current System 2. Problem Areas 3. Functional Decomposition 4. Enterprise Data Model 1. Business Rules 2. Preliminary ER Model 3. Enhanced ER Model 4. Entity Cluster 4. Analysis and its Proposed Solution 1. Description and Analysis of the Proposed 2. Objectives 1. General Objective 2. Specific Objectives 3. Scope Of Work 4. Workflow Model 5. Enterprise Data Model 1. Proposed Business Rules 2. New ER Model 3. New Enhanced ER Model 4. Entity Cluster 5. Database Design 1. Current Relations and Assumptions based on the Existing Database 2. Logical Database Design 1. Database Normalization 2. Data Dictionary / Metadata for the UNF 3. Physical Database Design and its Implementation 6. Database Implementation 1. Final Database Design 1. Relational Tables 2. Metadata 2. Database Relation and Relationship Instances 3. User Interface and Forms 4. Queries and Result 5. Reports 6. Codes (Major 7. Recommendation (Support and Maintenance) Summary and Conclusion
Appendix A. Work Breakdown Structure and Schedule B. Current System Documentation B.1 Sample Forms and Reports B.2 Transcript of Interviews
1. Introduction
A library is an organization which collects, processes, preserves, safeguards books
A Case Study
Presented to the
Department of Information & Computer Studies
Faculty of Engineering
University of Santo Tomas
In Partial Fulfillment of the Requirements in
Database Management Systems
October 2010
Title Page
Table of Contents 1. Introduction. 2. About the Company 1. Background and History 2. Organizational Chart 3. Contact Person/s 3. The Current System 1. Detailed Description of the Current System 2. Problem Areas 3. Functional Decomposition 4. Enterprise Data Model 1. Business Rules 2. Preliminary ER Model 3. Enhanced ER Model 4. Entity Cluster 4. Analysis and its Proposed Solution 1. Description and Analysis of the Proposed 2. Objectives 1. General Objective 2. Specific Objectives 3. Scope Of Work 4. Workflow Model 5. Enterprise Data Model 1. Proposed Business Rules 2. New ER Model 3. New Enhanced ER Model 4. Entity Cluster 5. Database Design 1. Current Relations and Assumptions based on the Existing Database 2. Logical Database Design 1. Database Normalization 2. Data Dictionary / Metadata for the UNF 3. Physical Database Design and its Implementation 6. Database Implementation 1. Final Database Design 1. Relational Tables 2. Metadata 2. Database Relation and Relationship Instances 3. User Interface and Forms 4. Queries and Result 5. Reports 6. Codes (Major 7. Recommendation (Support and Maintenance) Summary and Conclusion
Appendix A. Work Breakdown Structure and Schedule B. Current System Documentation B.1 Sample Forms and Reports B.2 Transcript of Interviews
1. Introduction
A library is an organization which collects, processes, preserves, safeguards books