Lesson 1 (Week 1-2) Flashcards

1
Q

____ is the management of organizational processes and systems that acquire, create, organize, distribute, and use information.

A

Information management

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

A Database (DB) is structure that can store information about:

A
  • multiple types of entities,
  • attributes that describe entities
  • relationships among entities
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A Database (DB) is collection of related data - with the following properties:

A
  • A DB is logically coherent and has some relevant meaning
  • A DB is designed, built and populated with data for a specific purpose
  • A DB represents some aspect of the real world.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

____ Models which show how the users recognize the business

A

User or Conceptual Models

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

____ implies the logic of business operations. The relationship between different components and the flow of data through the organization are examples of this model

A

Logical Models

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

____ which denotes the actual methods in implementing the database on a computer system based on the logical model

A

Physical Models

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

____ is a collection of software programs used to define, create, operate and maintain data in a database

A

Database Management System

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

refers to a structure which contains the database, the database management system, and the application programs in which the users interact.

A

Database System

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

A ____ consists of isolated data which makes it difficult to organize and represent.

A

File system

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

Advantages of a DBMS

A
  • Data Consistency and Integrity
  • Application program independence
  • Data Sharing
  • Backup and Recovery
  • Security and Privacy
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Multiple views of data

A Database usually consists of:

A
  • User Data
  • Metadata
  • Indexes
  • Application metadata
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Users of data operate directly by inserting, modifying and viewing data. We will use tables as storages for data having some relationships between them. Each table contains one or more columns. A set of columns create a database record.

A

User Data

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

A database is self-describing. ____ refers to data about data. It describes the means of storing user data in terms of table and column name, length, data type, primary keys, etc.

A

Metadata

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

____ give us alternative means of accessing user data by sorting and searching.

A

Indexes

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

____ can be accessed through database development programs and provide facilities for storing forms, reports, queries and other modules of an application.

A

Application Metadata

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

____ refers to the activity of identifying the schema of a database in a given data model.

A

Database Design

17
Q

____ is the database structure that depicts the relationships, data types and constraints, which is not dependent on any application.

A

Database Schema

18
Q

A set of activities for defining the structure of a database is called a ____.

A

data model

19
Q

The term ____ or state is used for the actual data in a database at a given time.

A

database instance

20
Q

The Database Development Process

A
  • Determining user requirements and evaluating their needs
  • Data Modeling
  • Implementation
  • Testing
  • Deployment