Database Systems: Questions and Answers

Topics: Data modeling, Database model, Database management system Pages: 2 (254 words) Published: January 5, 2012
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.
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Database Questions
  • Essay about question answer
  • Database Models and Legacy Systems Essay
  • database system Research Paper
  • Database System Concepts Essay
  • Management Information Systems: Questions and Answers Essay
  • Intro to Database Systems Chapter 1 Essay
  • Database Systems Essay

Become a StudyMode Member

Sign Up - It's Free