Project Name
Project Proposal
ITS232
Introduction to Database Management System
SEMESTER JUNE 2012 – NOVEMBER 2012
GROUP: CS1104A/B/C/D
Name 1, student number 1
Name 2, student number 2
Name 3, student number 3
Name 4, student number 4
<Lecturer’s Name>
FSKM, UiTM Pahang
1
Rubric
CATEGORY / REMARKS & MARKSPOOR / MEDIOCRE / GOOD / EXCELLENT / OUTSTANDING
ORGANIZATONAL BACKGROUND / Organization background is described clearly with full of useful information that allow lecturer to have full understanding towards the organization
1 / 2 / 3 / 4 / 5
ORGANIZATION CHART / Organization chart is genuine and reflect to organization background. The chart also must be created using SmartArt feature available in MS Word and refer to original organization chart
1 / 2 / 3 / 4 / 5
EXISTING PROCESS DESCRIPTION / Students have chosen one process and able to elaborate clearly how the process is executed in sequence. All data need to be stored are stated in this section.
1 / 2 / 3 / 4 / 5
PROJECT OBJECTIVES / Objectives are identified and reflect to Existing Process Description section
1 / 2 / 3 / 4 / 5
PROJECT BOUNDARY / Students able to identify what should be included in the project and what should not be included in the project.
1 / 2 / 3 / 4 / 5
DATABASE DESIGN / ERD is constructed using appropriate tool. All the notations are correctly applied in the diagram
1 / 2 / 3 / 4 / 5
DATA DICTIONARY / Data dictionary is created based on constructed ERD. All required information available in the provided tables
1 / 2 / 3 / 4 / 5
ORGANIZATIONAL CHART / Team organizational chart is created correctly using SmartArt feature available in MS Word.
1 / 2 / 3 / 4 / 5
ROLES & RESPONSIBILITIES / Roles and responsibilities are assigned to each group member and clearly elaborate to ensure every member know their scope and tasks
1 / 2 / 3 / 4 / 5
PROJECT PLAN / Project timeline is created using appropriate tool and presented in the proposal clearly
1 / 2 / 3 / 4 / 5
Total marks: ……………/ 50
Table of Contents
Rubric
1.0Introduction
1.1Organizational Background
1.2Organizational Chart
1.3Existing Process Description
2.0Project Overview
2.1Project Objectives
2.2Project Boundary
2.3Database Design
2.4Data Dictionary
3.0Team Structure
3.1Organizational Chart
3.2Roles and Responsibilities
4.0Project Timeline
1
1.0Introduction
1.1Organizational Background
Brief the history of the organization. Required information are date of establishment, founder name(s), location, organization core business and any extra information that will help lecturer to understand the organization.
1.2Organizational Chart
Provide the hierarchy of the organization using SmartArt feature available in MS Word. Marks will be deducted if content does not comply with stated requirement and does not follow the original chart from the organization.
1.3Existing Process Description
Choose ONE process from the organization. Then, describe clearly how the organization execute the existing process. The elaboration must be in sequence for easy understanding. States data from existing process need to be stored as well.
2.0Project Overview
2.1Project Objectives
State at least two project objectives why do you choose this project and it must reflect to Existing Process Description section.
2.2Project Boundary
Describe the project boundary clearly here. Therefore, you will not include any out of scope areas into your project.
2.3Database Design
Provide Entity Relationship Diagram (ERD). ERD must be constructed using specific tool(s) meant for database modeling such as MS Visio, MySQL Workbench, Oracle Data Modeler, and any other suitable tool(s). Marks will be deducted if ERD is constructed using inappropriate tool(s).
2.4Data Dictionary
Use provided table below to represent your database data dictionary. One table below represent one entity. If your ERD contains five entities, it means you will have 5 tables below.
Table NameNo / Attribute / Datatype / PK / FK / Lookup Table (If FK)
Y/N / Y/N
3.0Team Structure
3.1Organizational Chart
Create your team organizational chart using SmartArt feature available in MS Word. Your team should consist of 1 Project Manager, 1 or 2 Database Designers, and 1 or 2 Database Programmers depending on number of group members you have.
3.2Roles and Responsibilities
Provide your group member’s formal picture, role based on your team organizational chart and responsibilities for each team member. The responsibilities must depend on role assigned to the members.
4.0Project Timeline
Show your project timeline here. The timeline should be created using appropriate tool.
1