DATABASE DESIGN

What is a Database?

• A music band.

• A new type of technology.

• An organised collection of data.

• Computer code.

Which is NOT an advantage of using a database.

• Storage space is reduced.

• Accessing data is slow and inefficient.

• Easy to access data.

• Easy to edit.

What can a database be used for?

• Play music.

• Play video games.

• Order takeaway food.

• Organise large amounts of data.

What should you think about when creating a database? (Choose all correct answers.)

• Is the collected data correct and accurate?

• Is the database readable?

• Does it make enough money?

• Is the data organised and formatted correctly?

Which of these is a Data Type? (Choose all correct answers.)

• Address

• Currency

• FirstName

• Text

What is the smallest unit of data?

• Centimeter

• Data

• Character

• Information

Which of these is NOT an Entity?

• Person

• Animal

• Car

• Date of Birth

A row in a database table is called...

• A column

• A record

• An attribute

• Information

Which of the following is an Attribute? (Choose all correct answers.)

• PhoneNumber

• Hyperlink

• UserID

• SQL

Which is NOT a Boolean data type?

• Yes/No

• On/Off

• True/False

• Red/Green/Blue