Chapter1 Flashcards

1
Q

What is database management system ?

A

Is a collection of interrelated data and set of programs to access those data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the primary goal of DBMS

A

Is to provide a way to store and retrieve database information that is both convenient and efficient

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is major purpose of database system

A

To provide users with an abstract view of data (systems hides certain details)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the levels of abstraction.

A

Physical level.
Logical level
View level

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is physical level

A

Is the lowest level of abstraction describing how data are stored. Describe complex low level data structures in detail

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is logical level

A

Is the level that describes what data are stored in the database and what relationships exist among those data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What level of abstraction does the data administrator decides what info to keep in the database ?

A

Logical level of abstraction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is View level

A

Is the highest level of abstraction that describes only part of the entire database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is schema ?

A

Is the overall design of the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is an instance?

A

Is the collection of info that are stored in the database at a particular moment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The ability to modify the physical without changing the logical schema is called?

A

Physical data independence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Mention classification of data models

A

Relational
Entity relational
Object based data model
Semistructure data model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is relational model

A

Uses collection of tables to represent both data and the relationships among those data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is entity relationship model

A

Uses collection of basic objects called entities and relationships among those objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is object based data model

A

Extended the entity relationship with encapsulation , method and object identitity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is semstructured data model

A

Permits the specification of data where individuals data items of the same type may have different sets of attributes

17
Q

What is database manipulation lang

A

Is a lng that enables users to access or manipulate data as organised by the appropriate data model

18
Q

Types of data base manipulation lang

A

Procedural and non procedural

19
Q

What is a procedural and non procedural

A

Procedural DBML requires a user to specify what data are needed and how to get them while non procedural requires a user to specify what data are needed without specifying how to get those data

20
Q

What is data base definition lang

A

Is a lang that is used in the definition of database schema

21
Q

What is a super key

A

Is a set of one or more attributes that taken collectively allow us to identify uniquely a tuple in the relation

22
Q

What is relational algebra

A

It consists of set of operations that takes one or two relations as input and produce a new relation as their result

23
Q

Mention six basic operators

A

Project
Select
Cartisian product
Set difference
Union
Rename