Database Flashcards

1
Q

_ is an integrated collection of related files, along with details of the interpretation of the data contained therein.

A

database system

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

what does dbms stands for

A

Database management system

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

_ is a software system that allows access
to data contained in a database.

A

database management system (DBMS)

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

_can be defined as the value of an attribute of an entity.

A

DATA

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

Any collection of related data items of entities having the same attributes may be referred to as a _

A

DATABASE

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

_ has been described as “one of the most rapidly growing areas of computer and information science”.

A

Database technology

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

An _ may be concrete as person or book

A

entity

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

An _ is a set of entities of the same type that share the same properties or attributes .

A

entity set

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

An entity is represented by set of _.

A

attributes

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

means a fact or more specially a value of attribute of an entity.

A

Data

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

means the support, foundation or key ingredient of anything.

A

Base

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

A _can be conceived as a system whose base, whose key concept, is simply a particular way of handling data.

A

‘DATABASE’

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

A _can be conceived as a system whose base, whose key concept, is simply a particular way of handling data.

A

‘DATABASE’

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

Who said that Database is a mechanized shared formally defined and central
collection of data used in an organization

A

Prakash Naveen

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

Who said that Database is a collection of inter-related data stored together without harmful or unnecessary redundancy to serve multiple application

A

J.M Martin

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

who defines a database as a “ a collection of inter-related data stored so that it may be accessed by authorized users with simple user-friendly dialogues”.

A

Mac-Millan

17
Q

Functions of Database

A

User-friendly
Economy
Privacy and Security
Performance
Compatibility
Support
Data sharing
Data Independence

18
Q

Types of Databases

A

Bibliographic Databases
Knowledge Databases
Graphic-oriented databases
Decision-making databases

19
Q

What does CAD stands for

A

Computer-Aided Design

20
Q

What does CAL stands for

A

Computer-Aided Learning

21
Q

What does CAI stands for

A

Computer-Aided Instruction

22
Q

_ is considered as a central pool of data which can be shared by a community of users

23
Q

_have data which is free of format (unformatted data).

A
  • Bibliographic Databases:
24
Q

_are used in Artificial Intelligence applications. The data contained in these is discrete and formatted.

A

Knowledge Databases:

25
_could possibly used in Computer-Aided Design(CAD).
Graphic-Oriented Databases :
26
_are used in corporate management and allied administrative tasks.
Decision-making Databases:
27
Concept of Data Structure
List Structure Tree/Hierarchical Structure Network Structure
28
_A list is nothing more than a special data structure made up of data record where the Nth record is related (N-1) and (N-2) simply because of positioning.
List Structure:
29
_ is a non-linear multilevel hierarchical structure in which each node may be related to N-nodes at any level below it.
* Tree / Hierarchical Structure :
30
It is a one-to-one relationship
List structure
31
_another form of hierarchical structure. In this view as in the hierarchy approach, the data is represented by records and links. many-to-many relationship.
* Network Structure:
32
is essentially a collection of interrelated data and a set of programs to access this data.
DBMS
33
_ is the design of the database structure that will be used to store and manage data rather than the design of the DBMS software.
Database design