Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CS101 FINALS > Additional > Flashcards

Additional Flashcards

1
Q

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

A

Database Systems

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

Integrated system designed primarily to minimize repetition of data

A

Database Systems

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

DDL

A

Data Definition Language

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

DML

A

Data Manipulation Language/Data Management Language

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

DQL

A

Data Query Language

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

DCL

A

Data Control Language

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

DMCL

A

Device Media Control Language

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

TCL

A

Transaction Query/Control Language

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

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

A

Database Management System (DBMS)

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

Database System Components

A 
Computer-Aided Software Engineering (CASE) Tools
Repository
Database Management System (DBMS)
Database
Application Programs
User Interface
Data Administrators
System Developers
End Users
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Automated tools used to design databases and application programs

A

Computer-Aided Software Engineering (CASE) Tools

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

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

A

Repository

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

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

A

Database Management System (DBMS)

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

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

A

Database

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

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

A

Application Programs

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

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

A

User Interfaces

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

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

A

Data Administrators

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

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

A

System Developers

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

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

A

End Users

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

Types of Users in DBMS

A

Application Programmers
Sophisticated Users
Specialized Users
Naive Users

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

Typical Functions of DBMS

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

Examples of DBMS Products

A 
Oracle
Informix
Access
Foxpro
dBase
SQL Server Studio 2
MySQL
23
Q

Any distinguishable object about which information is stored

May be physical or abstract

A

Entity

24
Q

Does not rely on another entity for identification

Exists on its own

A

Independent Entity

25
Q

Relies on another entity for identification

Exists on the existence of some other entity

A

Dependent Entity

26
Q

Example of Independent and Dependent Entities

A

Independent: Department in an organization
Dependent: Department Manager

27
Q

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

A

Weak Entity

28
Q

Properties of entity

Used for identifying and expressing entities

A

Attributes

29
Q

The number of entities associated with the relationship

N-ary, binary or ternary relationships

A

Degree

30
Q

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

A

Connectivity

31
Q

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

A

Cardinality

32
Q

Basic types of connectivity for relations

A

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

33
Q

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

A

One-to-One (1:1) Relationship

34
Q

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

A

One-to-Many (1:N) Relationship

35
Q

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

A

Many-to-Many (N:M) Relationship

36
Q

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

A

Optional Relationship

37
Q

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

A

Mandatory Relationship

38
Q

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.

A

Field

39
Q

All the information related to one person, place or thing

Example: all the information in a personal address book about one person

A

Record

40
Q

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

A

Database

41
Q

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

A

Access

42
Q

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

A

Objects

43
Q

Access is often referred to as a _____

A

Relational database management system

44
Q

Types of Access Database Objects

A 
Table
Query
Form
Report
Page
Macro
Module
45
Q

Provide the basic unit and primary object for building databases

A

Table

46
Q

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

A

Query

47
Q

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

A

Form

48
Q

Special layouts designed to present data in a printed document format

A

Report

49
Q

Provide a layout design for publishing database data on the Web

A

Page

50
Q

Used to automate tasks such as opening forms or printing reports

A

Macro

51
Q

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

A

Module

52
Q

Planning A Database

A
  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

CS101 FINALS (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions