SQL

Question 1

what is a benefit of structuring data?

Answer 1

it allows us to do things we can’t do efficiently or feasibly with unstructured data.

Question 2

what are 3 DBMS functionalities?

Answer 2

1. data entry validation
2. queries
3. simultaneous updates by multiple users.

Question 3

what is the SQL format?

Answer 3

select
from
where
group by
order by

Question 4

what are 3 attributes of a database?

Answer 4

1. they keep data in multiple tables
2. each table has a primary key
3. tables are linked by matching field values.

Question 5

what are the 3 scenarios for when you need another table?

Answer 5

1. you have more than 1 entity
2. you have multiple values of some field
3. given the value of field A, you know the value of field B without looking since the value of field B is always the same for a given value of A

Question 6

what does it mean to have more than one entity?

Answer 6

fields for one are empty for another

Question 7

give an example for when you have multiple values of some field

Answer 7

multiple songs on each album

Question 8

what does […] mean?

Answer 8

that … is optional.