Mock Exam Flashcards

Definitions

1
Q

What is Data

A

facts,txt,graphics,images

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

What is a database application

A

application programs
like programs that create,read delete,update
like a dbms
or end user application

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

What is a constraint

A

a rule that cannot be violated by
database users

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

what is a repository

A

centralized storehouse for all data definitions

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

Metadata

A

includes data definitions and constraints
Data that describes properties and context of user data

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

What is a data Warehouse

A

integrated decision support database derived from multiple databases

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

information

A

data placed in context or summarized

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

user view

A

logical description of portion of database

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

database management system

A

a software application that is used to create, maintain, and provide controlled access to user databases

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

data independence

A

sepration of data description from programs

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

database

A

organized collection of related data

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

enterprise resource planning

A

a business management systems that integrates all functions of the enterprise

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

systems development life cycle

A

a structrured step-by-step approach to systems development

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

prototyping

A

rapid approach to systems development

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

enterprise data model

A

a graphical model that shows the
high-level entities for the organization
and the relationships among those
entities

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

Conceptual schema

A

A comprehensive description of business data

17
Q

internal schema

A

consists of two data models: a logical
model and a physical mode
defines the physical storage structure of the database. The internal schema is a very low-level representation of the entire database.

18
Q

external schema

A

consists of the enterprise data model and multiple user views