Test 1 Note Cards

Question 1

The problems with lists are …

Answer 1

The Redundancy and Multiple themes

Question 2

Addresses many of the information complexity issues …

Answer 2

Relational Databases

Question 3

stores information in tables, each info topic is stored in its own table . ..

Answer 3

relational database

Question 4

Aa international standard for creating, processing, and querying databases and their tables…

Answer 4

SQL

Question 5

The four components of a database system are:

Answer 5

Users, Database Application, Database Management System (DBMS), Database

Question 6

uses a database application to track things

Answer 6

user

Question 7

a self-describing collection of related records

Answer 7

Database

Question 8

contents of a Database are…

Answer 8

user data
Metadata
Indexes
Application Metadata

Question 9

serves as an intermediary between database applications and the database…

Answer 9

Database Management System (DBMS)

Question 10

ensure that the values of a column in one table are valid based on values in another table

Answer 10

referential integrity constraints

Question 11

a set of one or more computer programs that serve as an intermediary between the user and this DBMS …

Answer 11

database application

Question 12

Name the functions of a Database Applications

Answer 12

Create and process forms
Process User Queries
Create and process reports
Execute application logic
control database applications

Question 13

An…… is important to auser that needs to be represented in a database, represents one theme or topic

Answer 13

entity

Question 14

a……. is a 2-D table that has specific characteristics that consist of rows and columns

Answer 14

relation

Question 15

Two characteristics of a Relation are ….

Answer 15

Cells of the table hold a single valve
No two rows may be identical

Question 16

A…… is one or more columns of relations that are used to identify a row

Answer 16

Key

Question 17

A key that contains two or more attributes, needed for a key to be unique,…

Answer 17

composite Key

Question 18

is candidate to become a primary key…

Answer 18

Candidate key

Question 19

chosen to be the main key for the relation. uniquely identifys a single row….

Answer 19

primary key

Question 20

unique numeric value that is added to a relation to serve as the primary or main key.

Answer 20

surrogate key

Question 21

a primary key from one table placed into another

Answer 21

foreign key

Question 22

states that every value of a foreign key must match a value of an existing primary key…

Answer 22

referential integrity

Question 23

means no data was entered

Answer 23

Null value

Question 24

when one attribute determines the value of another attribute in the same table

Answer 24

functional Dependency

Question 25

ensures that a relation is well formed

Answer 25

Normalization

Question 26

Along with relationships These are the requirements of an E-R Model

Answer 26

- Entities - Attributes - Identifiers

Question 27

a description of the structure and format of occurrences of the entity

Answer 27

entity class

Question 28

an occurrence of an entity within an entity class

Answer 28

entity instance

Question 29

describes the entity's characteristics

Answer 29

attributes

Question 30

identifies a particular instance in the entity class...

Answer 30

identifiers

Question 31

Make an entity Attribute Display

Answer 31

Entity Identifires attriutes

Question 32

defines the numbers of entity classes participating in the relationship

Answer 32

relationship degree

Question 33

one entity related to another one

Answer 33

1:1

Question 34

one entity related many entities

Answer 34

1:N

Question 35

Many entities related to many entities

Answer 35

N:M

Question 36

relationships are named and classified by their ..., which also means count

Answer 36

cardinality

Question 37

maximun number at entity Instances that may participate in a relationship.

Answer 37

Maxium cardinality

Question 38

zero optionaI and one mandatory ...

Answer 38

Minimum cardinality

Question 39

a company has an employee represents a.....

Answer 39

HAS- A relationship

Question 40

Uses Crow's feet to show the many sides of a relationship

Answer 40

Information Engineering crowfoot model

Question 41

a version of the E-M model that is a national standard....

Answer 41

IDEF1X

Question 42

a set of structures and techniques for modeling and designing objet - oriented programs and applications

Answer 42

UML

Question 43

an entity that can not exist in the database without another entity

Answer 43

weak entity

Question 44

an entity that is not weak

Answer 44

strong entity

Question 45

relationship between a strong and weak entity is called an....... if the weak entity is ID- dependent

Answer 45

identifying relationship

Question 46

relationship between a strong and weak entity is called an....... if the weak entity is non ID-dependent

Answer 46

non identifying relationship

Question 47

if the supertype relates to at most one subtype, then it is

Answer 47

exclusive

Question 48

if the supertype relates to one or more subtypes, then it is

Answer 48

inclusive

Question 49

attributes of a supertype are called

Answer 49

discriminator

Question 50

relationships that connect supertypes and subtypes are called

Answer 50

IS-A relationships

Question 51

a...... is when an entity has a relationship to itself

Answer 51

recursive relationship