Explore BrainMass
Share

Explore BrainMass

    Normalized Relational Database Management System

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 10, 2019, 3:28 am ad1c9bdddf
    https://brainmass.com/computer-science/linked-lists/normalized-relational-database-management-system-421488

    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