Share
Explore BrainMass

Normalized Relational Database Management System

Please help with the following problem.

Design a completely Normalized Relational Database Management System that meets both the high-level and technical requirements of the web-based project management system.
Submit a word doc answering all parts of the question.
Thanks in advance.

File is attached.

Attachments

Solution Preview

Posting Number: 421488

Subject Category: Computer science / Database Design

Date of Response: 08/30/2011

Keywords: Relational Database Management System, Normalized, 3NF, Project Management System, Visio, Schema

Page Title: Design Relational Database for Web Based Project Management System

Solution Abstract: The goal of this solution is to assist the student by giving the solution of the ERD Model and Data Dictionary for a Data Management System for Project Management. The solution contains the data model in Visio and inline statements of basic considerations needed to develop the design. The considerations will be listed inline here and in a Word document.

Description: The solution is comprised of a Microsoft Visio document of the Database Design drawing, the inline solution here, and a Word attachment outlining the same.

Attachment Description: Microsoft Word 2007 document: " 421488 Database Design PM Considerations.docx" . The Visio Document: "421488 3NF -- Project Mgmt System v2.vsd "

Brief Description: I need help with the following problem.
Design a completely Normalized Relational Database Management System that meets both the high-level and technical requirements of the web-based project management system.
Submit a word doc answering all parts of the question.
Thanks in advance.

Full Problem Description:
Normalized Relational Database Management System
I need help with the following problem.
Design a completely Normalized Relational Database Management System that meets both the high-level and technical requirements of the web-based project management system.
Submit a word doc answering all parts of the question.
Thanks in advance.

File is attached.

A. High level requirements for the web-based project management application:
Allows you to track multiple Projects which may or may not depend on each other.
Each Project has multiple tasks which may be started in parallel when they have the same sequence number or sequentially with lower
sequence numbers starting first.
Each Task may be assigned to multiple projects and may or may not depend on other Tasks.
Each Task may be owned or ...

Solution Summary

The solution assists in designing a normalized relational database management system.

$2.19