Introduction To Databases

Question 1

Database

Answer 1

A collection of recorded meaningful and related data

Question 2

Fuel processing approach

Answer 2

Customized programs are written to access data stored in files

Question 3

Database approach

Answer 3

Data defined once, stored and maintained in one repository and accessed by various users

Question 4

Self describing nature of a database?

Answer 4

Contains catalog that stores description of a particular database, allowed to work with different applications

Question 5

Program-Data independence

Answer 5

Allows changing data structures and storage without having change database access programs

Question 6

Program-Operation Independence

Answer 6

Object-oriented, object-relational systems have operations on data(2 operations)

• interface(operation name and parameters)
• implementation”method”(can be changed without affecting the interface

Question 7

Multi User Transaction Processing

Answer 7

Allowing a set of concurrent users to retrieve from and to update the database

Question 8

Users and Controllers of Dtabase

Answer 8

Administrators, Designers

Question 9

User who queries and reports, and updates database

Answer 9

Casual Users, naive or parametric users (tellers), stand alone user, sophisticated users

Question 10

Sophisticated users

Answer 10

Familiar with capabilities and implement their own applications to meet their needs

Question 11

Stand-alone users

Answer 11

Maintain their personal database using readytouse programs

Question 12

Support of Multiple views of data

Answer 12

• User sees view of data of interest

- view may be a subset of database or contain virtual data derived from database