Flashcards
databases
Cards in this deck (32)
- 1DatabasesIs a structured collection of data.
- 2Tablestores a set of data eg details of students in a school.
- 3fieldare columns in a table eg forename surname gender DOB
- 4Recordis one row that stores data about a single item eg students details
- 5Primary keyuniquely identifies someones eg student id
- 6Foreign keyLinks things together
- 7RelationshipsTables are normally linked together because of lots of data
- 8data types and usesa
- 9Textany kinds of characters including numbers and letter
- 10NumericOnly numbers allowed
- 11Date/TimeDates and time
- 12Booleanone of two values such as yes/no or true/false
- 13Online data bases featuresUsed normally with larger organisations can be accessed anywhere with internet. Normally less secure than local databases because anyone can access them.
- 14Local databasesNormally used by smaller organisations in one building more secure than online because the internet isn't involved
- 15database management systemis a software that allows you to create and use your own database. Handles security to prevent unauthorized access. Allows different people to have different levels of access
- 16SQLis the language used by DBMS to create and search a database. it has data definition language to create tables
- 17—
- 18—
- 19threat. Opportunist.Protection Physical barriers.
- 20Threat. Virus.Protection. Anti virus software. Firewall
- 21Threat MalwareAntivirus Firewall.
- 22Threat Phishingprotection. keep software up to date. and dont give away personal data personal settings
- 23Threat accidental damageBackup and recovery and access levels
- 24Hackers.Password control, Encryption anti virus firewall backups
- 25Data protection actProvides 8 principles that govern the way data about individuals is stored and used.
- 26Computer misuse act 1990introduced to protect from hackers and malicious use of viruses
- 27Copyright designs and patents act 1988Protects creators of original works
- 28Freedom of info act 2000Provides individual the right to see info stored about them. Data can also be accessed about public bodies.
- 29Technology used for monitoringMovement
CCTV
GPS devices
Airport passenger lists - 30Communications Monitoring emails. Monitoring web sites visited. Logging keywords typed into search engines.Which key is used to identify a record in a database? The primary key
- 31Smart phones are a duplexRemote controls are a simplex
- 32Two components of a web page are banner and menu
Information
- Description
- Flashcards on databases, created by Jakk Rogers on 21/01/2019.
- Created by
- Jakk Rogers
- Views
- 0
- Rating