NEW
Font size
WorksheetsDatabase Design & Data Modeling for Music School
Total questions: 15
Worksheet time: 8mins
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'
Which of the following is an example of a primary key?
A) Student ID number
B) Student name
C) Student address
D) Student age
Fill in the blank: It is recommended to use ______ menus where possible in forms and data entry.
Drop-down
Pop-up
Slide
Hidden
Fill in the blank: The field that records the time of the lesson in a music school's database is called ________.
Lesson Time
Teacher Name
Instrument
Grade Level
In database design, it is advised to avoid storing ________ data.
Raw
Calculated
Text
Image
Getting ________ feedback is a best practice in database design.
User
Manager
Developer
No
