Additional

Question 1

A computerized system whose overall purpose is to maintain information and make it available on demand

Answer 1

Database Systems

Question 2

Integrated system designed primarily to minimize repetition of data

Answer 2

Database Systems

Question 3

DDL

Answer 3

Data Definition Language

Question 4

DML

Answer 4

Data Manipulation Language/Data Management Language

Question 5

DQL

Answer 5

Data Query Language

Question 6

DCL

Answer 6

Data Control Language

Question 7

DMCL

Answer 7

Device Media Control Language

Question 8

TCL

Answer 8

Transaction Query/Control Language

Question 9

Consists of a collection of interrelated data whose goal is to provide an environment which is convenient and efficient to use in retrieving and storing information

Answer 9

Database Management System (DBMS)

Question 10

Database System Components

Answer 10

Computer-Aided Software Engineering (CASE) Tools
Repository
Database Management System (DBMS)
Database
Application Programs
User Interface
Data Administrators
System Developers
End Users

Question 11

Automated tools used to design databases and application programs

Answer 11

Computer-Aided Software Engineering (CASE) Tools

Question 12

Centralized knowledge base containing all data definitions, screen, report formats and definitions of other organizations and systems components

Answer 12

Repository

Question 13

Commercial software system used to provide access to the database and also to the repository

Answer 13

Database Management System (DBMS)

Question 14

An integrated collection of data, organized to meet the information needs of multiple users in an organization

Answer 14

Database

Question 15

Computer programs that are used to create and maintain the database and provide information to users

Answer 15

Application Programs

Question 16

Languages, menus, and other facilities by which users interacts with various systems components such as CASE tools, application programs, the DBMS, and the repository

Answer 16

User Interfaces

Question 17

Persons who are responsible for designing databases and for developing policies regarding database security and integrity

Answer 17

Data Administrators

Question 18

Persons such as systems analysts and programmers who design new application programs

Answer 18

System Developers

Question 19

Persons through the organization who add, delete and modify data in the database and who request or receive information from the database

Answer 19

End Users

Question 20

Types of Users in DBMS

Answer 20

Application Programmers
Sophisticated Users
Specialized Users
Naive Users

Question 21

Typical Functions of DBMS

Answer 21

Controlling redundancy
Restricting unauthorized access
Providing multi-user interfaces
Representing complex relationships
Enforcing integrity constraints
Providing backup and recovery

Question 22

Examples of DBMS Products

Answer 22

Oracle
Informix
Access
Foxpro
dBase
SQL Server Studio 2
MySQL

Question 23

Any distinguishable object about which information is stored

May be physical or abstract

Answer 23

Entity

Question 24

Does not rely on another entity for identification

Exists on its own

Answer 24

Independent Entity

Question 25

Relies on another entity for identification | Exists on the existence of some other entity

Answer 25

Dependent Entity

Question 26

Example of Independent and Dependent Entities

Answer 26

Independent: Department in an organization Dependent: Department Manager

Question 27

Does not have any key attributes of its own Identified by being related to specific entities from another entity type in combination with some of their attribute values

Answer 27

Weak Entity

Question 28

Properties of entity | Used for identifying and expressing entities

Answer 28

Attributes

Question 29

The number of entities associated with the relationship | N-ary, binary or ternary relationships

Answer 29

Degree

Question 30

How many instances of one entity are associated with how many instances of other entity in a relationship Describes the mapping of associated entity instances in the relationship

Answer 30

Connectivity

Question 31

The actual number of related occurrences for each of the two entities

Answer 31

Cardinality

Question 32

Basic types of connectivity for relations

Answer 32

One-to-One (1:1) Relationship One-to-Many (1:N) Relationship Many-to-Many (N:M) Relationship

Question 33

At most one instance of an entity A is associated with one instance of entity B

Answer 33

One-to-One (1:1) Relationship

Question 34

For one instance of entity A, there are zero, one, or many instances of entity B but for one instance of entity B, there is only one instance of entity A

Answer 34

One-to-Many (1:N) Relationship

Question 35

Non-specific; for one instance of entity A, there are zero, one, or many instances of entity B and for one instance of entity B there are zero, one, or many instances of entity A

Answer 35

Many-to-Many (N:M) Relationship

Question 36

If a relationship can have a cardinality of zero; typically indicated by conditional tense (such as ‘may be’)

Answer 36

Optional Relationship

Question 37

If a relationship must have a cardinality of at least one; indicated by words such as ‘must have’

Answer 37

Mandatory Relationship

Question 38

Each piece of information about a person, place or thing | Example: a person’s first name or last name, date of birth, company name, etc.

Answer 38

Field

Question 39

All the information related to one person, place or thing | Example: all the information in a personal address book about one person

Answer 39

Record

Question 40

A collection of all records related to a particular subject or purpose Example: all records contained in a personal address book

Answer 40

Database

Question 41

A sophisticated database application that is often referred to as an object-oriented database.

Answer 41

Access

Question 42

Object-oriented database used tools, called _____, to store and display database records and other information.

Answer 42

Objects

Question 43

Access is often referred to as a _____

Answer 43

Relational database management system

Question 44

Types of Access Database Objects

Answer 44

``` Table Query Form Report Page Macro Module ```

Question 45

Provide the basic unit and primary object for building databases

Answer 45

Table

Question 46

Provide a tool for selecting data from database tables based on criteria you set

Answer 46

Query

Question 47

Special layout design that display data in a separate window one record at a time, and that can be used to enter or view data

Answer 47

Form

Question 48

Special layouts designed to present data in a printed document format

Answer 48

Report

Question 49

Provide a layout design for publishing database data on the Web

Answer 49

Page

Question 50

Used to automate tasks such as opening forms or printing reports

Answer 50

Macro

Question 51

Contain Visual Basic for Applications programming code that can extend the functionality of your database

Answer 51

Module

Question 52

Planning A Database

Answer 52

1. Define the purpose of your database 2. Plan tables and fields 3. Plan queries to recognize data 4. Plan forms, pages and reports 5. Create the database objects