Week 5 Checkpoint Bead Bar Consultant
DBMSs perform many functions for the business community. One of these functions is to manage data storage. Databases can hold a large amount of data for companies. Companies use DBMSs to store all information on their customers, their suppliers and can manage inventory as well. DBMSs also allow us to access this data quickly, which is important and great for business. Databases are essential to the business community.
I would recommend that Bead Bar use an enterprise DBMS because they are looking to be a global business.
The enterprise databases will allow Bead Bar executives to hold a great amount of various data, provide security so that data cannot be compromised, and allow other Bead Bar executives to access the database and view pertinent data. The Bead Bar should use a distributed enterprise database because they have five franchises, with possible plans to build more, and are about to start an online store. A distribute enterprise database is more reliable, and much faster than a centralized database. They will also allow each store to automatically know the prices that the main store sets. The local databases report their sales, inventory levels, and so on to the main store, which then sends price changes and the like to each database.
The Bead Bar should use a relational model database. The relational model is flexible and much easier to use than the network model. I believe that the relational model is best because each executive of the Bead Bar has a different use for a database, and the relational model will provide the tools they need for each of their uses. The relational model can also handle numerous tables and relate the tables to each other. This will prove to be a great convenience for the Bead Bar.
View Full Essay