Explore BrainMass
Share

Explore BrainMass

    Analyze & Select a DBMS for company

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

    Complete Question#2 in the Bead Bar Consultant Activity on page 113. Use Section 4.4 in Ch. 4 (pp95) to help organize your recommendations. Be sure to describe the database function(s), type(s), and model(s) you recommend for the Bead Bar and your reasoning.

    © BrainMass Inc. brainmass.com October 9, 2019, 8:02 pm ad1c9bdddf
    https://brainmass.com/business/management-information-systems/analyze-select-a-dbms-for-company-137063

    Solution Preview

    Complete Question#2 in the Bead Bar Consultant Activity on page 113. Use Section 4.4 in Ch. 4 (pp95) to help organize your recommendations. Be sure to describe the database function(s), type(s), and model(s) you recommend for the Bead Bar and your reasoning.
    *Response must be 200-300 words*

    What DBMSs do you recommend for the Bead Bar?

    Describe Database function(s)
    The following functions that are important, but performed behind the scenes, for Bead Bar are as follows:
    1. Manage data storage
    Handling data storage is one of the main functions of DBMSs. The interface and layout must be very user friendly since there are concerns of training users.
    2. Transform data into information and present it to users
    3. Provide security for data
    Data is a vital corporate asset. Bead Bar must ensure security of their database. Since security threats sometimes come from people within an organization and from outside sources database security is essential.

    4. Allow for multi-user access
    5. Contain a database programming
    6. Provides a data dictionary, which is used to define the structure of the database.

    Model(s) recommended

    The recommended model would be the Enterprise DBMSs, such as Oracle's 9i Database software, since it seems appropriate for Bead Bar and their franchisees who are located in multiple locations. The executives all have different needs and this will allow the company to store large amounts of data. Although there are definite disadvantages, such as extensive training to use properly, it will have the ability to perform many functions. Inventory seems to be a need that has been expressed by several executives, this model will allow users from different locations to connect and retrieve current inventory ...

    Solution Summary

    Describe Database Functions, Models and recommendations for a Company.

    $2.19