Computer Science
What is an 'Attribute'
Attribute - Describes the details/characteristics of an object or person
Define a 'Database'
An organised collection of data
Give 3 benefits of using electronic databases
- Easier to retrieve, add, delete and modify data
- Easier to backup
- Can be accessed by multiple people at the same time
What is a 'Flat File' database
A simple database structure which is uses one table to hold all data/info
What is a 'primary key'
A field that uniquely identifies each record
What is a 'foreign key'
An attribute that joins two tables together
Define 'Querying'
Finding data within a database
What is a DBMS and what does it do
DBMS(Database Management System) provides a layer of abstraction for the user and programmer
Give 2 ways a DBMS hide the underlying structure of data
- Prevents duplicate primary keys being made
- Enforces validation rules
Give 3 manual methods of exchanging data between databases
- Memory stick
- Optical media
- Emaiil
- Paper based
Give a disadvantage of capturing data as a paper based form
- Humans can make errors
- It is slower
Give 2 automated ways of capturing data and state their advantages
OCR (Optical Character Recognition)
OMR( Optical Mark Recognition)
Captures data much quicker
Reduces human error
Manual methods of capturing data is slow, give anoher form of capturing data
EDI (Electronic Data Interchange)
What conditions must be met for a database to be in first normal form
- All field names must be unique
- Values in the same field must have the same domain(have the same value)
- Values in fields must be atomic(one value per field)
- No records can be identical
- Each table needs a primary key
What conditions must be met for a database to be in second normal form
- The data must be in 1NF
- There must be no partial dependencies (where one/more fields depend on part of the primary key)
What conditions must be met for a database to be in third normal form
- Must be in 2NF
- Transitive dependencies must be removed (Where a value depends on another field that isn't the primary key)
Give 3 formats of storing and transferring data
- JSON
- XML
- CSV
Name 2 query languages and what they allow you to do
SQL(Structured Query Language) | QBE(Query By Example)
- Allows you to Specify tables
- Allows you to Specify criteria
- Allows you to Specify fields
- Use boolean expressions
Give benefits of organising data into a database
Makes in easy to:
- Add data
- Modify data
- Delete data
- Search data
Define 'Transaction Processing'
Any information processing that's divided into individual, indivisible operations called transactions
In each transaction, what must you ensure?
The transaction must succeed or fail, it should never be partially complete
What must each transaction do to ensure data integrity (complete data)
The transactions processing must follow a set of rules known as ACID. ATOMICITY CONSISTENCY ISOLATION DURABILITY.
Define 'Atomicity' (IN ACID)
Where a change to a database must be completely done or not done at all. Half changes must not be saved
Define 'Consistency' (IN ACID)
Any change in the database must retain the overal state of the database
Define 'Isolation' (IN ACID)
Where a transaction mustn't be interrupted by another transaction. It must occur in isolation so that other processes/other users can't access the data concerned.
How is Isolation implemented
The DBMS enforces Isolation via record locking. This locks any records that are affected via transactions. Putting them in a read only state.
Define 'Record Locking'
A technique that's used to prevent multiple users accessing the same object/record in a database at the same time. This prevents data inconsistencies
Define 'Durability' (IN ACID)
Where once a change is made to a database, it mustn't get lost due to system/power failure
How is durability implemented
The DBMS writes the effects of the transactions immediately back to the secondary storage rather than holding any changes in any form of volatile memory
What does 'Referental Integrity' do
Ensures consistency between related tables in a relational database
| Cuestionario |
|---|
| Romarriket |
| verbos ingles - copia |
| familia romana vocab |
| 1930-1980 |
| Antika grekland & Romarriket |
| Filtración glomerular |
| HP3 Livre |
| STS 2 |
| Math true or false or fill in the blanks |
| Math 2nd test |
| SHIELA MAE QUIZ |
| physiqueeffet Doppler |
| verbos ingles |
| citologia |
| consolidation español 2 |
| Sistemas alternativos y aumentativos de la comunicacion |
| conjugaciones ruso |
| LO6 |
| toolbox 2 |
| VB ANGAIS nov 14 |
| ingles |
| La Euroa feudal |
| plugga ekologi |
| STATISTICA |
| economia |
| religionreligion |
| DanielG.E |
| spansk vocab |
| tema 10 |
| CHAP 34 BLED |
| I frutta |
| illiade |
| chap 21 BLED |
| hemijq |
| sistema digestivom |
| cavidad bucal , boca , lengua , mejilla, labios paladar , arteria y irrigaciónl |
| cavidad bucal labios mejilla paladar y lengua arterias y irrigacióng |
| cavidad bucal con arteriasz |
| sistema tegumentarios |
| 2 Parcial |
| contribuciones indirectas y seguridad social - copia |
| contribuciones indirectas y seguridad socialescribe la respuesta correcta |
| ima fail rq |
| francais |
| platon |
| le scale |
| bio 30 dec exam |
| ASDM Final |
| Talumpati, posisyong papel, replektibong sanaysay |
| vocabulaire la ville |
| phrased |
| vecka 46 |
| Lesson 2: Political and leadership Structure |
| Terminologie (Radicaux) (A) |
| EMC frise et date introduction |
| mobility (emily) |
| histora |
| Espagnol interro voc.ch2quiz sur voc.chp2 espagnol |
| Economie semestre 1 L1 |
| historia |
| L'OvinicolturaL'Ovinicoltura, allevamento degli ovini |
| lekrion 2 |
| unit 3 |
| Inglês |
| casse cou 5 module 3 |
| casse cou 5 module 2 |
| manzoni |
| Déchets - copie |
| genetics bio 2 |
| Pragmatica e comunicazione |
| geografia |
| Physics HT1 |
| L'Ovinicoltura |
| past simple |
| material clothes |
| cuidados auxiliares de enfermería |
| técnicas básicas de enfermería |
| INF & vertaling |
| pattern |
| saúde |
| Voc cours d'espagol secondeBecause my teacher scares the hell out of me |
| De voetbeenderen.Benamingen. |
| casse cou 5 module 1 |
| Lesson 1: Kinship, Marriage, and the Household |
| le prarticipe passe des verbes irreguliersfrans |
| Darija 3 |
| allemand tâche finale chapitre 1 vocabulaire |
| xgbxfg |
| Gui |
| istologia animale |
| allemand tâche finale chapitre 1 |
| La Consitución Española de 1978 |
| vocabulario temporal |
| HCA_resumo_do_teste_(catedrais) |
| Histoire contemporaine |
| vocabulario de lugares |
| vocabulari tema 1 |
| Begrepp |
| FRASES FETES |
| vocabulario general 2 |
| vocabulario general 1 |
| PanFil |
| stylistique de la poesie CM |
| Déchets |
| glosor verb |
| Spagnolo |
| cellula |
| Sprecheafufgaben swei. swei - copy |
| Sprecheafufgaben swei. swei |
| phlebotomy practice test |
| les gaz |
| biology |
| Vocabulario1. Inglés
2. Francés
3. Alemán
4. Portugués
5. Italiano
6. Catalán |
| Test 3 - In Class Review |
| Texte argumentative |
| scienze naturali le molecole i legami |
| Physical Science Final Exam |
| Capacitors |
| Preguntas y respuestas |
| Anglais |
| lagar blir till |
| biology 🧫🧬. |
| Unidad 2 Inglés |
| Skudde |
| Vocabolario ucraino |
| inglés |
| grundlagar |
| FRJ |
| Biology - 1.4.2 - many proteins are enzymes |
| Arabe A1 S1Exercices pour mémoriser le vocabulaire |
| Riksdag och regering |
| Grade 9 cath studies test 1 |
| musica |
| för poems |
| friendship collocation |
| adjectives ed ing |
| begrepp |
| feeling and emotion |
| statistics |
| Historia |
| cells' |
| economía |
| hinduism grepp |
| Il sistema scheletricocompito in classe |
| sanne |
| Expressiones y frases en japones |
| elasticity |
| storia politica francia |
| biology 🧬 |
| NGO 6.3 Samenleven |
| Biology - 1.4.1 - general properties of proteins |
| Biochemical tests |
| TCMTécnicas de caracterização de materiais |
| INFORMATICA |
| celtiquela periode celtiques |
| ses c2 |
| philo voca |
| spanska muntlig |
| style |
| matchfit |
| Modyul 1-3 |
| RPH FINALS |
| TFN FINALS |
| ak |
| segunda guerra mundial |
| barcelona |
| investigacion comercial |
| Hay |
| Graphs & Charts |
| Teaching Literacy Final Exam |
| indiapractice |
| Parcial 2 |
| rod wave rap songs/ songs |
| rap songs |
| science |
| addition math |
| math multipilcation |
| math/algebra |
| perifrasis verbales |
| theme words hoofdstuk 2 havo 2 engels |
| sym chemie |
| stat kommun och region |
| habilitation |
| anglais |
| 2a guerra mundial |
| Phrasal verbs - copia |
| histoire geo 2 😤 |
| 2546 Midterm 2 |
| Reinos moneras, protoctsta y fungi |
| språkhistoria |
| ARTO SUPERIORE articolazioni |
| Tabla periódica |
| sistema solare |
| HidrosferaEl agua y los seres vivos, disolicion del agua, 4 propiedades principales del agua... |
| teknik prov årtionden |
| Bio chemistry notes |
| Chinois |
| svalovka |
| Teknik prov begrepp |
| TD 1 à 5 - personnes |
| frans |
| candela |
| acndela |
| Grammatik |
| DANA |
| Mots et exprssions du texte |
| Etapa 3 |
| chemie |
| istorija |
| Terminologie médicaletermino |
| VERBS FOLLOWED BY THE -ING OR THE INFINITIVE FORM |
| Phrasal verbsboh studia |
| Guilherme |
| lektion 1 |
| Abruzzo: regione italiana con patrimoni geografici, storici e naturali |
| Gcse poems |
| chinois |
| olimpiadi |
| olimpiadi |
| el mio cid |
| tedesco 107tedesco |
| LEY DE EXTRANJERIApreguntas ley extranjería |
| photos |
| TD 1 à 5 |
| ARNIS |
| Test 1 anglais L2 S1 |
| Fysik |
| Théories de la personnalité |
| animali |
| Semaine 4 |
| 6. Viajes de negocios |
| Guilherme |
| Lo5 |
| Diritto processuale penale |
| ARTO SUPERIORE ossa |
| Anglaisanglais |
| GitHub |
| Maven |
| Junit |
| Pattern Creazionali |
| Design Patterns |
| Architettura |
| Contratti Operazioni |
| Modello di dominio |
| Diagrammi di sistema |
| Casi d'uso |
| だいひょうてきなしょくちゅうどくきんとそのしょうじょう |
| Prácticas de histología - copia |
| ingles vocabulario |
| 2535 week 7- pharma |
| macbeth act 1 8/15 |
| microbiology |
| Parcial 2 |
| Sistema Reprodutor |
| plantes |
| 5. Por la ciudad |
| yasmin |
| Etapa 2 |
| PARTO (NACIMIENTO) |
| biologia1 |
| woordjes 379-393 |
| barocco |
| 4. Comida de negocios |
| Terminologie (Suffixes)Termino |
| Trajet 2 voc |
| Exchange sunstances with their environment |
| Bio systeme cardiovascualaire |
| vocab 3 |
| vocab 2 |
| funções sintáticas |
