.

Wednesday, February 27, 2019

Lolo

Tutorial (Week 2) ISYS224 perform the following questions 1 List four examples of selective informationbase systems. 2 cover each(prenominal) of the following terms Data, Database, Database Management System, Data Independence, Security, Integrity and Views. 3 portray the approach taken to the handling of selective information in the early file-based systems. argue the disadvantages of this approach. 4 Describe the main characteristics of the database approach and contrast it with the file-based approach. 5 prove the roles of the following personnel in the database environment Data decision makerDatabase 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 justify 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 installation 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 demand 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. use this array as an example, illustrate the difference (a) between the three levelsof data abstraction, and (b) between a schema and an instance.

No comments:

Post a Comment