Week 5 Day 5 Bead Bar Consultant Checkpoint

The Bead Bar has five franchises, six studios, Bead Bar on Board, and wants to take the company global by establishing a website. I would recommend the Enterprise DBMS, specifically Oracle’s Database 11g. Enterprise DBMS’s are for businesses that have multiple locations and store large amounts of data. The databases that are developed using the database management systems applications serve many functions.

The Bead Bar needs a DBMS that addresses the following:

1. Identifying trends/better understanding of the business

2. Schedule/management of employees and employee benefits

3. Integration with franchisees (offer more services and increase royalties)

4. Track sales leads

5. Record transactions, accounting, creating financial statements, audits

6. Customer information (data mining to find marketing trends)

7. Inventory management/ automatic re-ordering

The Oracle Database 11g has the capacity to handle these concerns. “It delivers this leading performance, scalability, security, and reliability on a choice of clustered or single-server running Windows, Linux, and UNIX” (Oracle, 2008). “It can handle detailed transaction processing, business intelligence, and content management applications” (Oracle, 2008). It also has a unique feature built in that protects data from server failure, site failure, human error, and planned downtime is reduced.

The Bead Bars