Additional Flashcards Preview

CS101 FINALS > Additional > Flashcards

Flashcards in Additional Deck (52)
Loading flashcards...
1

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

Database Systems

2

Integrated system designed primarily to minimize repetition of data

Database Systems

3

DDL

Data Definition Language

4

DML

Data Manipulation Language/Data Management Language

5

DQL

Data Query Language

6

DCL

Data Control Language

7

DMCL

Device Media Control Language

8

TCL

Transaction Query/Control Language

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

Database Management System (DBMS)

10

Database System Components

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

11

Automated tools used to design databases and application programs

Computer-Aided Software Engineering (CASE) Tools

12

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

Repository

13

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

Database Management System (DBMS)

14

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

Database

15

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

Application Programs

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

User Interfaces

17

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

Data Administrators

18

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

System Developers

19

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

End Users

20

Types of Users in DBMS

Application Programmers
Sophisticated Users
Specialized Users
Naive Users

21

Typical Functions of DBMS

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

22

Examples of DBMS Products

Oracle
Informix
Access
Foxpro
dBase
SQL Server Studio 2
MySQL

23

Any distinguishable object about which information is stored
May be physical or abstract

Entity

24

Does not rely on another entity for identification
Exists on its own

Independent Entity

25

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

Dependent Entity

26

Example of Independent and Dependent Entities

Independent: Department in an organization
Dependent: Department Manager

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

Weak Entity

28

Properties of entity
Used for identifying and expressing entities

Attributes

29

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

Degree

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

Connectivity