Relational Database design Flashcards

1
Q

Convert a mental model into a SQL schema.

A

.

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

Describe a 1 to 1 relationship in SQL

A

.

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

Describe a 1 to many relationship in SQL

A

.

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

Describe a many to many relationship in SQL

A

.

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

Describe a SQL join

A

.

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

Describe a SQL join table

A

.

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

Describe SQL normalization

A

.

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

Describe SQL de-normalization

A

.

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

Describe SQL ACID principals

A

.

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