Computing - Databases

HideShow resource information
Database - Validation
The automatic checking of inputed data by a computer system to ensure it is sensible, no erroneous data is entered e.g. Range check 0-10, Presence check - "required"
1 of 15
Operating System
Memory management, User interface, Multitasking, Peripherals, Security. E.g. Windows, Android, Linux
2 of 15
Utility Programs
DO - Disk organisation tools - defragmenter (reorganise hard disk and puts all the free space together) SM - System maintenance tools, system clean up, auto updates, anti spyware S - Security - Firewalls, antivirus
3 of 15
Custom Written Software
Software written specifically for you. The company will get the exact software/system that you will need. The software will work exactly how you want it to work. Only has features that you specifically need in your business. But very expensive.
4 of 15
Off the Shelf Software
Relatively cheap. Easily available from most computer shops. Thoroughly tested so there won't be any serious bugs or problems. Lots of user support i.e. user guides, online help and forums
5 of 15
Open Source Software
Free to use, or little cost. If you have skilled programmers to hand, the source code can be adapted to suit your particular needs. Anyone can edit and use it. May not have as much bug fixing support and security patches as commercial versions
6 of 15
Proprietary Software
Proprietary software legally remains the property of the organisation, group, or individual. Stable product - reliable, lots of bug fixes. Support in timely manner - updates, help. Usability - standard interfaces, features
7 of 15
Database
POSD persistent, organised store of data in electronic form
8 of 15
DBMS
Database Management System, software used to create and mange databases
9 of 15
Entities and Tables
Entity - An object or thing of importance about which data is captured e.g. a customer, a car Table - A set of data elements organised in fields and records
10 of 15
Database - Key Files
Foreign key - A field used in one table to represent the value of a primary key in a related table. Primary key - A field in a table which uniquely identifies each record in that table
11 of 15
Database - Forms
User interface tool which allows a user to enter or change data in a table
12 of 15
Database - Queries
Database management tool used to retrieve information based on specified criteria e.g. SELECT * FROM PUPILS grade > C
13 of 15
Database - Reports
Database management tool used to present information to the user in a professional way
14 of 15
Database - Modules
Database software and languages contain modules - pre-written programs
15 of 15

Other cards in this set

Card 2

Front

Memory management, User interface, Multitasking, Peripherals, Security. E.g. Windows, Android, Linux

Back

Operating System

Card 3

Front

DO - Disk organisation tools - defragmenter (reorganise hard disk and puts all the free space together) SM - System maintenance tools, system clean up, auto updates, anti spyware S - Security - Firewalls, antivirus

Back

Preview of the back of card 3

Card 4

Front

Software written specifically for you. The company will get the exact software/system that you will need. The software will work exactly how you want it to work. Only has features that you specifically need in your business. But very expensive.

Back

Preview of the back of card 4

Card 5

Front

Relatively cheap. Easily available from most computer shops. Thoroughly tested so there won't be any serious bugs or problems. Lots of user support i.e. user guides, online help and forums

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Databases resources »