In designing a new system database there are a number of issues that need to be addressed. Firstly we need to know the purpose of the system; what it will be used for, how many people will be used by and an idea of how big the system will be. In building the new system there are issues related to the infrastructure that also need to be looked at; firstly the cost. We know that the budget for development is generous, but at the same time we also know that the budget for maintenance is scarce. With any system of such size, security is also an issue. With so many personal details being held on a system and even just the purpose for which it is being used means that we would want the system to be secure in a number of ways; this including data integrity and the prevention of unauthorized access.
The need for databases is the heart of running the business. The databases we use hold all information about the daily transactions and important customer information.
The databases we use at McBride Financial Services hold all information about the daily transactions and important customer information. Our Microsoft Access databases are custom built to suit the business needs. The databases utilize the Structured Query Language (SQL) Server to run security and transactions. The SQL server provides client computers with highly efficient access to database files. SQL is a relational database management system for building business applications with increased data protection. Information in one database is linked to another database or a spreadsheet on another network or system. Access to these databases is very limited because of security. The databases we use hold many information.
The cost of developing the system is important; even with a high budget it...