Brainscape's Knowledge GenomeTM

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


See full index

ITFN 1201 > Test 1 Note Cards > Flashcards

Test 1 Note Cards Flashcards

1
Q

The problems with lists are …

A

The Redundancy and Multiple themes

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

Addresses many of the information complexity issues …

A

Relational Databases

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

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

A

relational database

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

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

A

SQL

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

The four components of a database system are:

A

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

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

uses a database application to track things

A

user

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

a self-describing collection of related records

A

Database

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

contents of a Database are…

A

user data
Metadata
Indexes
Application Metadata

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

serves as an intermediary between database applications and the database…

A

Database Management System (DBMS)

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

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

A

referential integrity constraints

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

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

A

database application

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

Name the functions of a Database Applications

A

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

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

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

A

entity

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

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

A

relation

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

Two characteristics of a Relation are ….

A

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

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

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

A

Key

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

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

A

composite Key

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

is candidate to become a primary key…

A

Candidate key

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

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

A

primary key

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

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

A

surrogate key

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

a primary key from one table placed into another

A

foreign key

22
Q

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

A

referential integrity

23
Q

means no data was entered

A

Null value

24
Q

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

A

functional Dependency

25
Q

ensures that a relation is well formed

A

Normalization

26
Q

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

A
  • Entities
  • Attributes
  • Identifiers
27
Q

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

A

entity class

28
Q

an occurrence of an entity within an entity class

A

entity instance

29
Q

describes the entity’s characteristics

A

attributes

30
Q

identifies a particular instance in the entity class…

A

identifiers

31
Q

Make an entity Attribute Display

A

Entity
Identifires
attriutes

32
Q

defines the numbers of entity classes participating in the relationship

A

relationship degree

33
Q

one entity related to another one

A

1:1

34
Q

one entity related many entities

A

1:N

35
Q

Many entities related to many entities

A

N:M

36
Q

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

A

cardinality

37
Q

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

A

Maxium cardinality

38
Q

zero optionaI and one mandatory …

A

Minimum cardinality

39
Q

a company has an employee represents a…..

A

HAS- A relationship

40
Q

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

A

Information Engineering
crowfoot model

41
Q

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

A

IDEF1X

42
Q

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

A

UML

43
Q

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

A

weak entity

44
Q

an entity that is not weak

A

strong entity

45
Q

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

A

identifying relationship

46
Q

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

A

non identifying relationship

47
Q

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

A

exclusive

48
Q

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

A

inclusive

49
Q

attributes of a supertype are called

A

discriminator

50
Q

relationships that connect supertypes and subtypes are called

A

IS-A relationships

51
Q

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

A

recursive relationship

ITFN 1201 (2 decks)

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