postgres-database Flashcards

1
Q

What is a database schema?

A

defines how the data is organized within a relational database

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

What is a table?

A

every item in a table must have the same column

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

What is a row?

A

an object, instance of an object, a single set of data(with descriptive columns)

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

What is an attribute and what other names are used to describe them?

A

column, key, property

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