Brainscape's Knowledge GenomeTM

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


See full index

BTM 382 > The Relational Database Model > Flashcards

The Relational Database Model Flashcards

1
Q

What does the Relational Database Model do?

A

It enables logical representation of data and its relationshipsW

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

What does logical simplicity yield?

A

It yields simple and effective database design methodologies

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

What is the logical view facilitated by?

A

It is facilitated by the creation of data relationships based on a logical construct called a relation

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

What are the 8 characteristics of a relational table?

A

Table is perceived as a two-dimensional structure composed of rows and columns
Each table row (tuple) represents a single entity occurence within the entity set
Each table column represents an attribute, and each column has a distinct name
Each intersection of a row and column represents a single data value
All values in a column must conform to the same data format
The order of the rows and columns is immaterial to the DBMS
Each table must have an attribute or combination of attributes that uniquely identifies each row

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

What does a key consist of?

A

A key consists of one or more attributes that determine other attributes

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

What does a key ensure?

A

It ensures that each row in a table is uniquely identifiable

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

What does a key establish?

A

It establishes relationships among tables and to ensure the integrity of the data

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

What is a primary key?

A

It is an attribute or combination of attributes that uniquely identifies a row

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

What is a determination?

A

It is a state in which knowing the value of one attribute makes it possible to determine the value of another

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

What does a determination establish?

A

It establishes the role of a key

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

What is a determination based on?

A

It is based on the relationships among the attributes

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

What is functional dependence?

A

It is a value of one or more attributes that determines the value of one or more other attributes

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

What is a determinant?

A

It is an attribute whose value determines another

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

What is a dependent?

A

It is an attribute whose value is determined by the other attribute

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

What is a composite key?

A

It is a key that is composed of more than one attribute

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

What is a key attribute?

A

It is an attribute that is a part of a key

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

What is a superkey?

A

It is a key that can uniquely identify any row in the table

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

What is a candidate key?

A

It is a minimal superkey

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

What is a foreign key?

A

It is the primary key of one table that has been placed into another table to create a common attribute

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

What is a secondary key?

A

It is a key that is used strictly for data retrieval purposes

21
Q

What is entity integrity?

A

It is when all primary key entries are unique, and no part of a primary key may be null

22
Q

What is the purpose of entity integrity?

A

Each row will have a unique identity, and foreign key values can properly reference primary key values

23
Q

What is referential integrity?

A

It is when a foreign key may have either a null entry, as long as it is not a part of its table’s primary key, or an entry that matches the primary key value in a table to which it is related (every non-null foreign key value must reference an existing primary key value)

24
Q

What is the purpose of referential integrity?

A

It is possible for an attribute not to have a corresponding value, but it will be impossible to have an invalid entry; the enforcement of the referential integrity rule makes it impossible to delete a row in one table whose primary key has mandatory matching foreign key values in another table

25
Q

What could a null represent?

A

An unknown attribute value
A known, but missing, attribute value
A “not applicable” condition

26
Q

What are some ways to handle nulls?

A

Flags
Constraints

27
Q

What is a flag?

A

It is a special code used to indicate the absence of some value

28
Q

What is a constraint? (2)

A

NOT NULL constraint: placed on a column to ensure that every row in the table has a value for that column
UNIQUE constraint: restriction placed on a column to ensure that no duplicate values exist for that column

29
Q

What property do relational operators have?

A

They have the property of closure

30
Q

What is closure?

A

It is a property of relational operators that permits the use of relational algebra operations on existing tables (relations) to produce new relations

31
Q

What is select?

A

It is a unary operator that yields a horizontal subset of a table (slide 17)

32
Q

What is project?

A

It is a unary operator that yields a vertical subset of a table (slide 18)

33
Q

What is union?

A

It combines all rows from two tables, excluding duplicate rows (slide 19)

34
Q

What is union compatible?

A

It is when tables share the same number of columns, and their corresponding columns share compatible domains

35
Q

What is intersect?

A

It is a relational set operator that yields only the rows that appear in both tables
Tables must be union-compatible to yield valid results (slide 20)

36
Q

What is difference?

A

It is a relational set operator that yields all rows in one table that are not found in the other table
Tables must be union compatible to yield valid results (table 21)

37
Q

What is product?

A

It is a relational operator that yields all possible pairs of rows from two tables

38
Q

What do joins do?

A

They allow information to be intelligently combined from two or more tables

39
Q

What is a natural join?

A

It links tables by selecting only the rows with common values in their common attribute

40
Q

What is an inner join?

A

It only returns matched records from the tables that are being joined

41
Q

What is an outer join?

A

It is when matched pairs are retained and unmatched values in the other table are left null

42
Q

What is a left outer join?

A

It is a join yields all of the rows in the first table, including those that do not have a matching value in the second table

43
Q

What is a right outer join?

A

It is a join that yields all of the rows in the second table, including those that do not have matching values in the first table

44
Q

What is a data dictionary?

A

It is a description of all tables in the database created by the user and designer

45
Q

What is a system catalogue?

A

It is a system data dictionary that describes all objects within the database

46
Q

What is one-to-many (1:M)?

A

It is the norm for relational databases

47
Q

What is a one-to-one (1:1)?

A

It is one entity that can be related to only one other entity and vice versa

48
Q

What is a many-to-many (M:N)?

A

It is implemented by creating a new entity in 1:M relationships with the original entities

49
Q

What is a composite entity?

A

It is an entity that helps avoid problems inherent to M:N relationships

BTM 382 (6 decks)

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