Explore BrainMass
Share

Explore BrainMass

    Scope of Database Administration and Normalization

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

    Please see attached file for full problem description.

    I need help answering the following database questions:

    1. I'm to provide a concise, but complete, written description of what functions are included within the scope of data administration, and make a case why data administration is unique from traditional information systems and database functions. Also to provide one or more samples of an organization chart showing the "fit" and relationship of a data administration function in an organization, including a description of how organizational chart of data administration function relates to and supports traditional IS and database functions and indicate to whom does the data administration function should report.

    2. Reviewed the data model below and correct to a normal form. Developing a report listing the problems with the data model below and provide a correct data model and an accompanying data dictionary for the system based on the information about the system characteristics given below. (NOTE: This is a small database. DO NOT put in any additional information or data elements not identified in the specifications below).

    Data Model

    The system functionality is suppose to include:
    ? Ability to input new client information including
    o Last, first, and middle name
    o Date of Birth
    o Gender
    o Current Address
    ? Ability to update client information
    o Last, first, and middle name
    o Date of Birth
    o Gender
    o Current Address
    ? Ability to input client appointment dates
    o Date of visit
    o Time of visit
    o Practitioner
    ? Ability to update client appointment dates
    o Date of visit
    o Time of visit
    o Practitioner

    The system also needs to be able to generate the following reports:
    ? List of all clients
    ? List of appointments by client
    ? List of appointments by date

    © BrainMass Inc. brainmass.com October 9, 2019, 8:21 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/148290

    Attachments

    Solution Summary

    This solution analyzes the scope of database administration and also takes an in depth look at Normalization and various normal forms.

    $2.19