Database Project Documentation Outline - Weebly



Database Project Sample Guideline

1. Introduction

1. Background

2. Objectives/Purpose of the system

3. Problems in the existing system

4. Scope of the system

5. Methodology

2. The Existing System Analysis

1. Overview

2. Requirements of the System

3. Feasibility Analysis (including Budget and Schedule)

3. Database Design

1. Conceptual Database Design

1. Entities identification and Description

2. Attributes identification and description

3. Relationship identification and description

4. Entity Relationship (ER) Diagram

2. Logical Database Design

1. ER to Table Mapping

2. Validate Model using Normalization

1. First Normal Form (1NF)

2. Second Normal Form (2NF)

3. Third Normal form (3NF)

3. Relational Schema with Referential Integrity after normalization

3. Physical Database Design of the New System

1. Physical Design Strategy

2. Hardware Implementation

3. Front End Design Outline

4. Implementation and Support

1. Database Coding and testing (practical work)

This part should be submitted with CD. The developed database should be detached from the DBMS and copied into a CD for submission.

Annexes

1. SQL Scripts for creating the Database

2. SQL Script for creating tables, views, stored procedures, and triggers used to enforce business rules and referential integrity.

3. Collaboration among Group members

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download