Database Systems: Questions and Answers

Only available on StudyMode
  • Download(s) : 346
  • Published : January 5, 2012
Open Document
Text Preview
Tutorial (Week 2)

Answer the following questions:

1 List four examples of database systems.

2 Discuss each of the following terms:

Data, Database, Database Management System, Data Independence, Security, Integrity and Views.

3 Describe the approach taken to the handling of data in the early file-based systems. Discuss the disadvantages of this approach.

4 Describe the main characteristics of the database approach and contrast it with the file-based approach.

5 Discuss the roles of the following personnel in the database environment: Data Administrator
Database Administrator
Logical Database Designer
Physical Database Designer
Application Developer

6 Discuss the advantages and disadvantages of database management systems.

7 Discuss the concept of data independence and explain its importance in a database environment.

8 To address the issue of data independence, the ANSI-SPARC three-level architecture was proposed. Compare and contrast the three levels of this model.

9 What is a data model? Discuss the main types of data models.

10 Describe the types of facility you would expect to be provided in a multi-user DBMS.

11 Of the facilities described in your answer to Question 10, which ones do you think would not be needed in a standalone PC DBMS? Provide justification for your answer.

12 Consider a two-dimensional integer array of size m×n that is to be used in your favourite programming language. Using this array as an example, illustrate the difference (a) between the three levelsof data abstraction, and (b) between a schema and an instance.
tracking img