Rock Hill Music Festival Data Normalization

What is the primary key for the 'tickets' table?

• ticket number

• ticket type ID

• customer ID

• customer type ID

Which field can be used as a foreign key in the 'customer types' table?

• ticket number

• ticket type ID

• customer ID

• customer type ID

What is the primary key for the 'customers' table?

• ticket number

• ticket type ID

• customer ID

• customer type ID

Which field can be used as a foreign key in the 'customers' table?

• ticket number

• ticket type ID

• customer ID

• customer type ID

What is the primary key for the 'ticket types' table?

• ticket number

• ticket type ID

• customer ID

• customer type ID

Which field can be used as a foreign key in the 'ticket types' table?

• ticket number

• ticket type ID

• customer ID

• customer type ID

How many customer types are there?

• 1

• 2

• 3

• 4

How many customers are there?

• 3

• 4

• 5

• 6

How many ticket types are there?

• 1

• 2

• 3

• 4

How many tickets are there?

• 3

• 4

• 5

• 6