Postgresql-database Flashcards

1
Q

What is a database schema?

A

It is a collection of tables

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

What is a table?

A

table is a list of rows each having the same set of attributes. For example, all students in a “students” table could have “firstName”, “lastName”, and “dateOfBirth” attributes

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

What are rows

A

each row is a record in that spreadsheet (table). rows have the same set of attributes

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