Flashcards
Databases
Flashcards do conjunto (12)
- 1What is a database?A database is an organised collection of related data. It is possible to add, edit, manage and retrieve data from a database. The structure of a database allows data to be found and used quickly.
- 2State 4 different data types and give an example.Number (Integer) = 43 - A whole number but no fractions.
Number (Real) = 435.256 - Any number.
Text or string = John Smith - Letters, numbers or other characters such as punctuation marks.
Data/Time = 04/10/12 - Any date or time. - 3Define the key term 'Field'A field is a single item of data within a record.
- 4Define the key term 'Record'A record consists of a collection of related fields.
- 5Define the key term 'file'A file is a collection of related fields.
- 6Define the key term 'Key Field'Key Field: A key field uniquely identifies each record. No two records have the same data in their key field. Also knows as Primary Key.
- 7State the different Validation Rules- Range Check
- Type Check
- Format/Picture Check
- Length Check
- Presence Check
- Lookup Check - 8What is a report?A report is a printed document that contains data from the database, organised and analysed in a certain way. A report from a student database might list the students in each class in alphabetical order.
- 9What is a form?Forms are used to make to data entry more attractive and secure rather than entering data into raw tables.
- 10State the uses of a database.- Add, change or delete records.
- Search for a particular record.
- Sort the records into a given order.
- Print records about some aspect of the database. - 11What is a simple query search?A simple query search looks for data in only one field.
- 12What is a complex query search?A complex query search looks at data with multiple criteria.
Informações
- Descrição
- FlashCards sobre Databases, criado por Kirstie Farley em 06-02-2015.
- Criado por
- Kirstie Farley
- Visualizações
- 0
- Avaliação