Database Environment Flashcards

1
Q

What are the main components of a DBMS environment?

A
  • Hardware
  • Software
  • Data
  • Procedures
  • People

Each component plays a crucial role in the effective functioning of a DBMS.

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

What functions does a DBMS provide?

A
  • Data storage, retrieval, and update
  • User-accessible catalog
  • Transaction support
  • Concurrency control
  • Recovery services
  • Authorisation services
  • Data communication support
  • Integrity services
  • Utility services

These functions ensure the reliability and security of database management.

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

What is the purpose of the external level in the ANSI-SPARC architecture?

A

It describes the part of the database relevant to each user, representing users’ views of the database.

This level allows users to interact with the database without needing to understand its internal workings.

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

What does the conceptual level of the ANSI-SPARC architecture represent?

A

It provides a community view of the database, describing what data is stored and the relationships among data.

This level facilitates mapping between external and internal levels.

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

What is the internal level in the ANSI-SPARC architecture?

A

It describes how the data is physically stored on the computer.

This level deals with the actual storage structures used by the database.

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

What are the advantages of using a DBMS?

A
  • Control of data redundancy
  • Data consistency
  • More information from integrated data
  • Sharing of data across departments
  • Improved data integrity and security
  • Enforcement of standards
  • Increased productivity

These advantages contribute to a more efficient and reliable data management system.

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

What are some disadvantages of DBMS?

A
  • Complexity
  • Size
  • Cost
  • Additional hardware requirements
  • Performance issues
  • Greater impact of a failure

These disadvantages can affect the implementation and maintenance of DBMS.

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

What does a Data Administrator (DA) do?

A

Responsible for management of data resources, database planning, development of standards, and advising senior managers.

The DA ensures database development aligns with corporate objectives.

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

What is the role of a Database Administrator (DBA)?

A

Responsible for the physical realization of the database, including design, implementation, security, and maintenance.

The DBA requires technical knowledge of the DBMS.

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

Fill in the blank: The _______ level describes how data is stored in the ANSI-SPARC three-level architecture.

A

Internal

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

True or False: The conceptual level in the ANSI-SPARC architecture can have multiple external views.

A

True

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

What is the purpose of the system catalog in a database?

A

It serves as a description of the data that provides program-data independence.

This allows changes to the data structure without affecting application programs.

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

How many levels exist in each level in the three-level architecture?

A

There can only ever be 1 conceptual level and 1 internal level, but there can be many external levels.

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

What is a major objective of the three-level architecture?

A

Data independence.

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

What is logical data independence?

A

Changes to the conceptual schema should not require changes to external schema or application programs.

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

What does physical data independence refer to?

A

Immunity of conceptual schema to changes in the internal schema.

17
Q

What is the role of Data Definition Language (DDL)?

A

Allows the DBA or user to describe and name entities, attributes, and relationships.

18
Q

What operations does Data Manipulation Language (DML) support?

A

Insertion, retrieval, modification, or deletion of existing data.

19
Q

What is a Fourth Generation Language (4GL)?

A

Includes query languages, forms generators, report generators, graphics generators, and application generators.

20
Q

What are the components of a data model?

A
  • Structural part
  • Manipulative part
  • Set of integrity rules
21
Q

What is the purpose of a data model?

A

To represent data in an understandable way.

22
Q

What are the categories of data models?

A
  • Object-based
  • Record-based
  • Physical
23
Q

What is conceptual modeling?

A

The process of constructing a model of information use that is independent of implementation details.

24
Q

What is the result of conceptual modeling?

A

A conceptual data model.

25
Q

What is the client-server architecture?

A

A model where the server holds the database and the DBMS, while the client manages the user interface.

26
Q

What are the advantages of client-server architecture?

A
  • Wider access to existing databases
  • Increased performance
  • Possible reduction in hardware costs
  • Reduction in communication costs
  • Increased consistency
27
Q

Fill in the blank: The internal structure of a database should be unaffected by changes to _______.

A

Physical aspects of storage

28
Q

True or False: Users should be aware of changes made to the conceptual schema.

29
Q

What does DBMS stand for?

A

Database Managment System

30
Q

What are the names of each level in the ANSI-SPARC Architecture?

A
  • External
  • Conceptual
  • Internal
31
Q

What does DA stand for?

A

Data Administrator

32
Q

What does DBA stand for?

A

Database Administrator

33
Q

What does DDL stand for?

A

Data Definition Language

34
Q

What does DML stand for?

A

Data Manipulation Language

35
Q

Name 3 types of data models

A
  • Object based
  • Record based
  • Physical
36
Q

What does an object based data model include?

A
  • Entities
  • Attributes
  • Relationships
37
Q

What does a record based data model include?

A

A number of fixed formats records

38
Q

What does a physical data model refer to?

A

How data is stored in the computer representing information