Databases

Question 1

What are databases used for?

Answer 1

Store and organise large amounts of data on a computer.

Question 2

What are two types of ways to sort your data?

Answer 2

Ascending order (A-Z, 0-10)
Descending order (Z-A, 10-0)

Question 3

What do you have to CREAT to search in a database?

Answer 3

Queries; written in the form of Field-Operator-Criteria

Question 4

What are the type of operators?

Answer 4

= - (Town=Wolverhampton - finds customers living in Wolverhampton

<> - (Town<>Wolverhampton - finds all customers living apart living in Wolverhampton)

>

• (Items > 10 - finds orders more than 10)

< - (Items < 10 - finds orders less than 10)

AND - (Town = Wolverhampton AND Items > 10 - finds orders with more than 10 items that were made by a customer in Wolverhampton)

OR - (Town= Wolverhampton OR Items > 10)- finds either orders with more than 10 items OR orders made by a customer in Wolverhampton

LIKE - (LIKE Town = New - finds customers which live in a town beginning with ‘New’)

Question 5

What are the Data Types?

Answer 5

Number - (Quantity in stock, shoe size - stores NUMBERS ONLY)

Text - (First name, postcode, telephone number - stores

letters, numbers and spaces)

Date - (Date of birth, date of order - allows only DATES to be entered)

Time - (Time of order, Time of transaction - allows only TIMES to be entered)

Currency - (Stock price, selling price - must begin with a currency sign $ or £)

Boolean - (Male/female, true/false, yes/no - used where only TWO choices are available)

Lists - (Size -XS, S, M, L, XL, preferred of contact - mail, SMS, telephone, email - used where the user gives two choices that they can pick from a DROP-DOWN MENU)

Picture - (Product image, screen picture - PICTURES of products or people)

Sound - (MP3 track - used to organise sound or music)

Video - (Video file - organises video files)