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
Logical Database Designer
Physical Database Designer
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.
Please join StudyMode to read the full document