Database Design & Data Modeling for Music School

Which of the following is an example of a data model?

• Student records

• Weather forecast

• Video game simulation

• None of the above

Which of the following is NOT typically stored in a database?

• Student information

• Class schedules

• Random thoughts

• Grades and assessments

What type of information is NOT mentioned as being stored in databases?

• Student information

• Class schedules

• Grades and assessments

• Weather forecasts

A good database design should ________ duplicate data.

• Create

• Eliminate

• Ignore

• Increase

Good database design uses ________ data types.

• Inappropriate

• Appropriate

• Random

• Complex

A well-designed database should capture ________ information.

• All necessary

• Unnecessary

• Partial

• No

Which data type in databases is used for storing names and addresses?

• Short Text

• Numbers

• Date/Time

• Currency

Fill in the blank: The data type used for storing class schedules is ______.

• Currency

• Date/Time

• Yes/No

• AutoNumber

Instead of using 'John Smith' as a full name, how should it be broken down?

• First Name: 'John', Last Name: 'Smith'

• First Name: 'Smith', Last Name: 'John'

• First Name: 'John Smith', Last Name: ''

• First Name: '', Last Name: 'John Smith'

Fill in the blank: Instead of 'John Smith', it is better to use ________.

• 'Smith John'

• 'John' and 'Smith'

• 'John Smith'

• 'Smith'