2: INFORMATION TECHNOLOGY AND SYSTEMS
2.7
3 Database systems
3.1 A database is a collection of records and files designed in such a way that it is possible for
the whole of the user community to search and obtain a wide range of data and process it
into standard and ad hoc reports.
3.2 Data will be stored in tables, and will be accessed by users via a piece of software called the
database management system (DBMS).
3.3 A database has three major characteristics:
(a) It is shared
(b) It provides for needs of different users
(c) It can evolve to meet future needs
3.4
Advantages of a database Disadvantages of a database
Reduced duplication of data or data
redundancy
High set-up costs
Reduced storage costs Risk of failure
Consistent data Data not meeting all users' needs
Security and privacy Costs of security and contingency planning
3.5 A database administrator (DBA) controls and sets standards for:
(a) Data input
(b) Physical storage structures
(c) System performance
(d) Back-up and recovery strategies
(e) Security of data
3.6 A database structure is developed for each database. This structure specifics which files will
be held in the database and what 'records' and 'fields' they contain. It will specify how many
characters can be entered in each field.
4 Internet technology
4.1 Internet technology can be used in organisations in different ways, eg
(a) Source of information
(b) Sales channel
(c) Communication channel
(d) Supply chain management