Essay about A Case Study in Database Design

2268 Words Jan 12th, 2016 10 Pages
Technological University of the Philippines
Ayala Blvd., Ermita Manila

A Rental Record System for “Petilla Dormitory”
Sampaloc, Manila

A Case Study in Database Design

Partial Fulfillment of the Requirements in
Database Lecture
Bachelor of Science in Information System

Submitted by:
FRANCIA, Jan Diether
GISALA, Aaron
MORALES, Shiela May C.
NOARIN, Jenny M.

October 2015

Table of Contents
Title page ------------------------------------------------------------------------ I

I. Overview

A. Company Profile ------------------------------------------------------------- 1
B. Sample Forms --------------------------------------------------------------- 2

II. Database Planning

A. Mission Statement
…show more content…
This dormitory consist of three floors, each floors have 3 rooms, each room can occupy for single or double deck. Petilla Dormitory is not a popular and big dorm in Sampaloc, Manila but you can say that staying there is worth it because of its clean, organize facilities and very warm welcome of people there.

B. Sample Forms

II. Database Planning

A. Mission Statement
The purpose of this system is to lessen the energy exerted by the owner of Petilla Dormitory in booking customers who wants to rent a room and to keep their records with ease.

B. Mission Objectives
1. To provide a room for a customer for as long as the customer wants.
2. To book an available room for every customer that wants to rent a room in the dormitory.
3. To keep the records or information of the customers that are renting in every room of the dormitory.
4. To prioritize the safety and satisfaction of our customers by providing the best service and facilities.

C. Project Team Roles and Responsibility Assignment
C.1 Project Team Roles PROJECT TEAM MEMBERS | ROLE | GISALA, AARON | TEAM MANAGER | PINEDA, PATRICK JOHN | SUPPORT TECHNICIAN | MORALES, SHIELA MAY | DATABASE DESIGNER | NOARIN, JENNY M. | TECHNICAL WRITER | FRANCIA, JAN DIETHER | SYSTEM ANALYST |

C.2 Responsibility Assignment Matrix Activity | Team Manager | System Analyst | Database Designer | Technical Writer | Support Technician |

Related Documents