Introduction to Databases
Part 1 Background
Chapter 1 Introduction to Databases
1.1 A database management system provides a number of facilities that will vary from system to system. Describe the type of facilities you might expect, especially those that aid the initial implementation of a database and its subsequent administration.
Initially, the type of facilities expected should be described. These include: data storage and retrieval, concurrency control mechanism, authorization services, integrity mechanisms and transaction support. The focus is then on facilities such as data definition, which is stored in the catalog, authorization control to manage the users. View definition, transaction support and integrity controls also aid subsequent administration.
1.2 Discuss the problems that arise when organizations rely upon multiple computerized file systems to store data.
Discuss the advantages and disadvantages in using a database management system to carry out the same functions.
For the first part the answer should cover broadly all the problems associated with file-based systems, such as: data duplication, data inconsistency, problems with validation and security, fragmentation of data.
For the second part, the focus is on a DBMS to support the same operations. Advantages include: providing all the data structuring facilities, security mechanisms, integrity mechanisms, backup and recovery facilities, minimal redundancy, data sharing, data independence. Disadvantages include: cost, size, complexity.
1.3 Applications built around file management systems have often been used to satisfy user requirements. Discuss the problems that arise with such systems, and what advantages a database management system could offer instead.
This answer contains the points made in part one of the previous question and also includes the advantages contained in part two of the previous question.
1.4 Explain what is meant by a database management system, and contrast it
Chapter 1 Introduction to Databases
1.1 A database management system provides a number of facilities that will vary from system to system. Describe the type of facilities you might expect, especially those that aid the initial implementation of a database and its subsequent administration.
Initially, the type of facilities expected should be described. These include: data storage and retrieval, concurrency control mechanism, authorization services, integrity mechanisms and transaction support. The focus is then on facilities such as data definition, which is stored in the catalog, authorization control to manage the users. View definition, transaction support and integrity controls also aid subsequent administration.
1.2 Discuss the problems that arise when organizations rely upon multiple computerized file systems to store data.
Discuss the advantages and disadvantages in using a database management system to carry out the same functions.
For the first part the answer should cover broadly all the problems associated with file-based systems, such as: data duplication, data inconsistency, problems with validation and security, fragmentation of data.
For the second part, the focus is on a DBMS to support the same operations. Advantages include: providing all the data structuring facilities, security mechanisms, integrity mechanisms, backup and recovery facilities, minimal redundancy, data sharing, data independence. Disadvantages include: cost, size, complexity.
1.3 Applications built around file management systems have often been used to satisfy user requirements. Discuss the problems that arise with such systems, and what advantages a database management system could offer instead.
This answer contains the points made in part one of the previous question and also includes the advantages contained in part two of the previous question.
1.4 Explain what is meant by a database management system, and contrast it