Karteikarten
Database MLF
Karten in diesem Stapel (30)
- 1What is a field?A single item of data within a record
- 2What is a record?A record consists of a collection of related fields
- 3What is a file/table?A collection of related fields
- 4What is a key field/ primary key?Uniquely identifies each record. No two records have the same data in their key field
- 5What is a report?A Printed document that contains data from the database organised or analysed in a certain way e.g. may list students in a class in alphabetical order
- 6What is a form?Used to make data entry more attractive and secure rather than entering data into raw tables
- 7What is a calculated field?Not all data is needed in a report may be present in a database e.g. a person's age is never included because it changes. If want to use a person's age, it must be calculated called a calculated field. The database calculates by subtracting the DOB from the date of the report
- 8Uses of databasesAdd, change, delete records
Search for a particular record
Sort the records into a given order
Print reports about some aspects of the database - 9What is updating records?Records do not always stay the same, they can be updated by
Adding a new record
Editing existing records
Deleting an old record - 10What is a simple query search?(Keyword search) Looks for data in one field
- 11What is a complex query search?Looks at data with multiple criteria
- 12Meaning of operator: =Equals
- 13Meaning of operator: <Less than
- 14Meaning of operator: >Greater than
- 15Meaning of operator: <>Not equal to
- 16Meaning of operator: ANDData is only listed where both conditions are true
- 17Meaning of operator: ORData is only listed where either or both conditions are true
- 18Meaning of operator: LIKEWhere a perfect match is not needed
- 19Meaning of wildcard: *Any number of characters eg. s* finds smith, sarah and sandler
- 20Meaning of wildcard: ?Any character eg Ca? Finds cat and cot
Ca?? Finds cart - 21Meaning of wildcard: !Any character not in the brackets eg 10[!TW]
- 22What is sorting data?Data can be organised in sorted order eg alphabetical or numerical in ascending or descending order
- 23Why sort data?Easier if lists are presented as reports
Can identify best customer by amount they have spent - sort them according to total amount spent - 24Consequences for business if data is not secureLoss of customers- unhappy customers go elsewhere
Payments for goods not being received
Bad publicity- all business rely on a good reputation
Management unable to make decisions due to lack of information - 25Physicals security methods to keep data secureLocks on doors, alarms, ID cards, biometric systems
- 26Software methods for keeping data securePasswords - Method of authentication, authorised users given a username w/ pw
Access rights (file attributes) - can be placed on files to give no rights to access, read access, write access
Back-ups - a second copy of data - 27Benefits of using a databaseFast access - than paper in filing cabinet
Easy to edit - easily updated/changed
Validation - Can set checks
Reports - Results may help make decisions
Sharing - Shared with any number of users on a netword
Security - passwords - 28Give examples of data typesInteger, Real, string, date/time, currency, Boolean, lists, picture, video, sound, video
- 29What is a database?An organised collection of related data. It's possible to add, edit, manage and retrieve data. The structure allows data to be found and used quickly
- 30Examples of validation methodsRange check, type check, format check, length check, presence check, lookup list
Informationen
- Beschreibung
- GCSE ICT (Topic 8: Databases) Karteikarten am Database MLF , erstellt von Bonnie Liang am 13/02/2015.
- Erstellt von
- Bonnie Liang
- Aufrufe
- 0
- Bewertung