DATABASES+(SOFTWARE+THAT+ORGANISES+DATA+INTO+TABLES)


 * A database is an organised collection of data.
 * Data is organised into data structures called files, records, fields and characters.
 * The data structure is defined in a data dictionary.
 * This includes information about the characteristics of each item entered into the database, such as the field name, field size, data type and field description
 * A table or list arranges data into columns (fields) and rows (records).

ACTIVITY

Use the attached file to answer the following questions:
 * 1) What is a database?
 * 2) Describe the advantages of electronic databases over manual databases
 * 3) What is the purpose of a DBMS?
 * 4) What is a flat file database?
 * 5) List the four data structures using in databases
 * 6) What is a data dictionary?
 * 7) Explain the differences between a table and a form
 * 8) Describe a well-designed form
 * 9) A database is to be created containing student information. Construct a data dictionary using these fields: family name, First name, Gender, School year, Class, Street, Suburb, Post-code, Phone, DOB (date of birth) and Age.
 * 10) <span style="font-family: 'Arial Black',Gadget,sans-serif; font-size: 140%;">The following questions refer to the ADDRESS database in the attached file.
 * 11) <span style="font-family: 'Arial Black',Gadget,sans-serif; font-size: 140%;">How many fields are there in the database?
 * 12) <span style="font-family: 'Arial Black',Gadget,sans-serif; font-size: 140%;">How many records are contained in the database?
 * 13) <span style="font-family: 'Arial Black',Gadget,sans-serif; font-size: 140%;">What is the name of the third field?
 * 14) <span style="font-family: 'Arial Black',Gadget,sans-serif; font-size: 140%;">Write down the data in the second record
 * 15) <span style="font-family: 'Arial Black',Gadget,sans-serif; font-size: 140%;">What is the last entry in the 'Suburb' field?
 * 16) <span style="font-family: 'Arial Black',Gadget,sans-serif; font-size: 140%;">What is the maximum number of characters needed for the 'Post-code' field?