Scribd
Upload
4 views1 page

Database Systems Tutorial Overview

This tutorial provides an introduction to database systems, covering key terms such as DBMS, data inconsistency, and data abstraction. It outlines significant differences between file processing systems and DBMS, explains data independence, and lists the functions of a database administrator. Additionally, it discusses programming languages, steps for setting up a database, and illustrates concepts using a 2D integer array.

Uploaded by

Poonam Bhardwaj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
4 views1 page

Database Systems Tutorial Overview

This tutorial provides an introduction to database systems, covering key terms such as DBMS, data inconsistency, and data abstraction. It outlines significant differences between file processing systems and DBMS, explains data independence, and lists the functions of a database administrator. Additionally, it discusses programming languages, steps for setting up a database, and illustrates concepts using a 2D integer array.

Uploaded by

Poonam Bhardwaj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Tutorial -1: Database Systems

(Introduction)

1. Describe Following terms:


a. DBMS
b. Database System Applications
c. File Systems
d. Data Inconsistency
e. Consistency Constraints
f. Data Views
g. Data Abstraction
h. Instance
i. Schema
2. List for significant differences between a file processing system and DBMS.
3. Explain the difference between physical and logical data independence.
4. What are five main functions of a database administrator?
5. List seven programming languages that are procedural and two that are non
procedural. Which group is easier to learn and use?
6. List six major steps that you would take in setting up a database for particular
enterprise.
7. Consider a 2 dimensional integer array of size n x m that is to be used in your
favorite programming language. Using the array as an example, illustrate the
difference:
a. Between the three levels of data abstraction
b. Between a schema and instance

Dated : 29-07-2011

You might also like