Database Approach

Database Approach

1. What is a database?

   • A database is a general collection of data from any source
     • Example can be details for a bank
     • Another example can be for school/college/Universities
     • Users have control over the data held in a database
   • It is used to remove duplicate data(ie make the data redundant)
   • A database can represent relationships using very hard structured diagrams
   • It provide effective access for users who have different data needs (ie management, payroll)

2. Advantages of Databases

   • It will be constantly up to date
     • It will significantly reduce the duplication datat
   • Data Protection
     • Can be controlled at various levels
       • Password Protection
       • Automatic Restarts
   • Independance of Data and Programs
     • Both of the data and the program and can be independently altered
   • Facilities
     • Will be interactive
     • Real time updates
     • Online Access
   • Evolutionary System
     • Inexperienced users
       • Learn from experience
     • Users can build up data from scratch
   • System Design
     • Very easy to create a systems designer
       • design
       • Maintenance
       • back up

3. Disadvantages of Databases

   • Costs
     • Very expensive
       • To purchase
       • To buy
       • To Run
       • To maintain
   • Memory
     • Need a large memory
     • Need a big storage device
     • High channel to support high data traffic