Lolo

Tutorial (Week 2) ISYS224 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 End-Users 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. 0 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 schem a and an instance.