Database chap 1

Question 1

3 Example of DB Application

Answer 1

Renting a video,studying at university,renting a car

Question 2

File-Based Systems

Answer 2

Collection of application programs that perform services for end users

Question 3

Limitation Of File-Based approach

Answer 3

1.Duplication of data
2.Seperation and isolation of data
3.Data dependence
4.Incompitable file formats
5.fixed queries

Question 4

Database

Answer 4

Shared collection of logically related data-designed- to meet-information need of organization

Question 5

Database Management System

Answer 5

A software system that enable users to define,create,mantain and control access to database

Question 6

Application Program

Answer 6

Computer programs that interact with the database

Question 7

Data Definition Language

Answer 7

Make specifications of data types,structures and any data constraints.

Question 8

Data Manipulation Language

Answer 8

General equiry facility of the data

Question 9

Views

Answer 9

Virtual table that presents data from one or more tables.

Question 10

Views Benefits

Answer 10

1.Reduce complexity
2.Provide security
3.Mechanism to customize database appearance
4.Database structure will be consistent even the underlying database is change

Question 11

Roles in database

Answer 11

Data Administrator,Database Administrator,Database Designer

Question 12

History Of Database Systems

Answer 12

First Generation-Hierarchical and Netword
Second Generation-Relational
Third Generation-Object relational and object oriented

Question 13

DBMS advantages

Answer 13

Control Data Redundancy
Data Consistency
Improved data intergrity
Improved security

Question 14

Disadvantage of DBMS

Answer 14

1.Complex to design and manage
2.Require very large storage space
3.Purchasing license for DBMS can be expensive
4.Additional hardware required which can lead to increased cost in hardware