Purchase Solution

Normalized Relational Database Management System

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

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 ...

Purchase this Solution


Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.