CompSci - Databases

Question 1

Database

Answer 1

Contains individual attributes about entities structued in various data structures.

Question 2

Data Consistency

Answer 2

Ensures data is correct by controlling all occurences of the same data item to be updated dynamically.

Question 3

Referential Integrity

Answer 3

Ensuring that foreign keys in tables refer to valid records/tables.

Question 4

Data Redundancy

Answer 4

Ensures that data isn’t duplicated, wasting storage

Question 5

Data Independence

Answer 5

Ensures the database is a separate system from its application so that changes are simpler to make.

Question 6

Atomic Data

Answer 6

Attributes that are broken down into their fundamental parts to maximise flexibility.

Question 7

DBMS

Answer 7

Database Management System

Question 8

DBMS Tools

Answer 8

IQRAMS DUM

Integrity
Queries
Report generation
Access levels
Maintenance
Security

Dictionaires
User interface
Manipulation

Question 9

Primary Key

Answer 9

Unique identifier for an entity

Question 10

Compound Key

Answer 10

Unique identifier with >1 fields for an entity

Question 11

Candidate Key

Answer 11

Any field other than a dedicated ID that can be used as a primary key.

Question 12

Foreign Key

Answer 12

A primary key from another table to represent a relationship between the objects

Question 13

Secondary Key

Answer 13

A second primary key, allowing users to access the data in some other order

Question 14

Validation Techniques

Answer 14

Presence
Format
Length
Range
Lookup
Type

Question 15

Verification Techniques

Answer 15

Double-Entry
Proof-reading

Question 16

Big Data

Answer 16

A large & complex set of data collected from various sources that can be analysed using dedicated systems to find trends and patterns.

Question 17

Predictive Analysis

Answer 17

An active process that relates past patterns and trends with potential future behaviour using modelling and machine learning to inform business risks or opportunities.

Question 18

Data Warehousing

Answer 18

Storing big data sets in a centralised location from several sources that support analysis.

Question 19

Data Mining

Answer 19

A passive process that uses automated software to find patterns and relationships in large data sets.

Question 20

Distributed Systems

Answer 20

Using a local connected network of devices to harness their collective processing power and storage capacity to more efficiently analyse / store data.

Question 21

0NF

Answer 21

Flat file (contains a number of single tables w no links between them)

Question 22

1NF

Answer 22

• Primary Key
• Fields are atomic
• No repeating rows / columns

Question 23

2NF

Answer 23

Attributes are dependent on only one primary key (split into tables).

Question 24

3NF

Answer 24

No transitive partial dependency (no composite keys).

Question 25

SQL - TABLE

Answer 25

CREATE TABLE [name] ( [var1] Int PRIMARY KEY [var2] Varchar(n) [var3] Varchar(n) NOT NULL )

Question 26

SQL - SELECT

Answer 26

SELECT */### FROM [table_name] WHERE [condition]

Question 27

SQL - INSERT

Answer 27

INSERT INTO [table_name] VALUES [vars]

Question 28

SQL - DELETE

Answer 28

DELETE FROM [table_name] WHERE [condition]

Question 29

Purpose of SQL (Data Operations)

Answer 29

CSS TRIM but on databases Copying Searching Sorting Traversing Removing Inserting Merging

Question 30

Normalisation Format

Answer 30

TABLE_NAME ([underscore]PK[underscore], extras, [overscore]FK[overscore])

Question 31

IQRAMS DUM - Integrity

Answer 31

If any data is updated, linked data in other tables is updated

Question 32

IQRAMS DUM - Queries

Answer 32

Can use code to perform commands to manipulate the database

Question 33

IQRAMS DUM - Report gen.

Answer 33

Generate a visual represntation of database contents

Question 34

IQRAMS DUM - Access lvls.

Answer 34

Users can only view the data they are granted to see

Question 35

IQRAMS DUM - Maintenance

Answer 35

Ensures that data is stored properly in memory

Question 36

IQRAMS DUM - Security

Answer 36

Data is protected with passwords or other methods

Question 37

IQRAMS DUM - Dictionaries

Answer 37

Allows users to specify the structure of data and the metadata of each attribute (length, type...)

Question 38

IQRAMS DUM - User Interface

Answer 38

Provides a visual representation of the database that users can interact with

Question 39

IQRAMS DUM - Manipulation

Answer 39

CSS TRIM Copying Searching Sorting Traversing Removing Inserting Merging

Question 40

Distributed Database Benefits

Answer 40

Problem in one site doesn't stop the rest Staff access can be limited to sections Scaling is simplified No network bottleneck as it's local Cost High performance

Question 41

SQL - UPDATE

Answer 41

UPDATE [table_name] SET [table_var = var]

Question 42

SQL - JOIN

Answer 42

SELECT */### FROM [table_name] WHERE [condition]

Question 43

Data Normalisation

Answer 43

Reorganising data in a database to make it more convenient, simple and flexible.