Brainscape's Knowledge GenomeTM

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


See full index

Database - Normalization > Chapter 2 - Relational Database Fundamentals. > Flashcards

Chapter 2 - Relational Database Fundamentals. Flashcards

1
Q

Application programs that process data and databases consist of what four major components?

A

The database, the transaction programming, the application programming and some type of user interface.

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

In a multitier database architecture what is the client responsible for?

A

Presenting data to the user.

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

In a multitier database architecture what is the server responsible for?

A

The server is responsible for delivering data services to the client.

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

In a two-tier architecture the client does what?

A

Processes the application logic and presentation of the user interface.

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

What is a fat client?

A

A client that performs the bulk of the data processing operation.

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

What is a thin client?

A

A client designed to be small so that the bulk of the data processing occurs on the server.

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

Can a web browser act as a thin client?

A

Yes

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

Can a Web server act as an application server?

A

Yes

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

The server is connected to the client how?

A

By way of a local area network (LAN) or a wide area network (WAN).

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

What is an advantage of a thin client?

A

It requires less expensive hardware and less administrative overhead.

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

A three-tier architecture correlates naturally to what environment?

A

The web environment.

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

The n-tier architecture is the same as the three-tier architecture except…

A

It can have multiple application and data management servers.

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

Relation

A

A two-dimensional table consisting of columns and rows in a relational database.

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

A row or tuple

A

The collection of one set of attributes in a relation.

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

Column or attribute

A

A property of a relation

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

Domain

A

The allowable values for an attribute.

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

Degree

A

The number of attributes in a relation.

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

Cardinality

A

The number of rows in a relation.

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

Normalization

A

The process of organizing and refining relations with in a relational database.

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

What does normalization do?

A

Normalization may reduce the duplication of data items within the database and often results in the creation of additional tables.

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

Entity

A

A uniquely identifiable element about which data is stored in a database.

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

When like named columns appear in multiple tables and the same data manipulation process needs to access those columns how is the column described?

A

The name of the column is preceded by the name of the table.

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

A column can contain what type of values?

A

Values culled from one domain and one domain only.

24
Q

The intersection of the column and row can have how many values?

A

One and only one.

25
Q

Primary key

A

A unique identifier with in a row.

26
Q

Base tables

A

The relations actually defined within a database.

27
Q

Virtual tables

A

Database relations created as a result of data manipulation operation and not a permanent part of the database.

28
Q

Null

A

A database value meaning unknown.

29
Q

What are the three pieces of information needed to retrieve a value?

A

The name of the table, the name of the column, the primary key of the row.

30
Q

What three qualities should a primary key have?

A
  1. The primary key should be a value that is extremely unlikely to be no.
  2. The primary key should be a value that will never change.
  3. The primary key should not be made up of meaningful data.
31
Q

Composite key

A

A primary or foreign key that is made up of multiple attributes.

32
Q

Foreign key

A

A column or concatenated columns that are identical to the primary key of a relation in the same database.

A foreign key specifies that any given row of a particular table references only one row of the relation containing the parent key.

33
Q

Parent key

A

The primary key referenced by a foreign key.

34
Q

How many parent keys can a foreign key reference?

A

Only one.

35
Q

Data model

A

A formal method of describing data and data relationships.

36
Q

A complete data model should contain what three distinct components?

A
  1. Structural information detailing a particular set of rules by which a database can be built.
  2. Manipulative information detailing the kinds of operations that are permitted on the data.
  3. Integrity information that provides details about how the data will be kept accurate.
37
Q

Who developed Entity-Relationship (ER) modeling?

A

Dr. Peter P. Chen.

38
Q

Entity-Relationship (ER) Modeling

A

A conceptual database design method that describes relationships between entities.

39
Q

Strong entity

A

An entity whose data is meaningful without having to reference another entity in the data model.

40
Q

Weak Entity

A

An entity that must reference another entity for its data to be meaningful.

41
Q

When talking about degrees what is the name one is referenced to?

A

Unary

42
Q

In degrees what is another name for two?

A

Binary

43
Q

In degrees how is three or more referenced?

A

Ternary

44
Q

In cardinality how is one to one written and what is the definition?

A

1:1

For each instance of entity A, there is no more than one entity B.

45
Q

In cardinality how is a one to many relationship written and what is the definition?

A

1:n
For each instance of entity A, there are zero or more instances of entity B, for each instance of entity B, there is only one entity A.

46
Q

In cardinality how is a many to many relationship written and what is the definition?

A

m:n
For each instance of entity A, there are zero or more instances of entity B, and for each instance of Entity B, there are zero or more instances of entity A.

47
Q

Domain constraints

A

A set of restrictions on the values allowed for the attributes of relations.

48
Q

Entity integrity

A

A relational constraint stating that no part of a primary key may be null.

49
Q

Referential integrity

A

A relational constraint stating that every foreign key that is not null must reference an existing primary key value.

50
Q

View

A

A data operation given a name and stored in a database that creates a virtual table when invoked by a user.

51
Q

DDL stands for what and what is the definition?

A

Data definition language. A descriptive language used to create and named entities and the relationships between them in a database.

52
Q

Meta-data

A

Metadata refers to things such as relations, attributes, constraints, views, privileges, and users.

53
Q

Query language

A

The part of a Nonprocedural DML retrieves data from a database.

54
Q

If attribute within a row needs to have more than one value what needs to happen?

A

The relation must be redesigned.

55
Q

Partial functional dependency

A

B is functionally dependent on A and attribute can be removed from A and the dependency still exists.

Database - Normalization (7 decks)

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