Share
Explore BrainMass

Analyze & Select a DBMS for company

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.

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