The database environment for the Barry’s Bug Blasters is very outdated. When analyzing the Finance & Account section of the company’s website, there are PDF files that have the history of balance sheets, income, and cash flow statements. The information that is available on the site and PDF’s is arranged easy to read, but having the correct database would help expedite with searching and modifying of data within these documents. The addition of a database would allow the finance and accounting department to have complete control of the data that is published and won’t have to rely on someone updating the sites page. The problem with having PDF’s with all of the previous years is that the documents have to be opened individually, thus making comparing data difficult and cumbersome. As specified earlier, modifying data would be problematic with the current setup. There is also very little structure the way that it comprised at the moment making it challenging to find pertinent information. Another constraint is the information given is a bit vague in its description, having drop down menus to the table would help resolute the problem. Since this is a small business Microsoft Access would be the best fit for the type of changes that need to be implemented. The finance and accounting department should be the only users that have rights to modify the data to aid any confusion that may occur. Having a relational database management system (RDBMS) in place puts all of the data into tables, while hiding the complexity of the relational model from the user. The main objectives of the database management system are data availability, data integrity, data security, and data independence. The finance and account department would have full access and only grant access to management.
The scope of the database defines the extent of the design accordingly to operational requirements. The scope of this database is to provide the finance and accounting department with...
Please join StudyMode to read the full document