Data base

Question 1

What is a table

Answer 1

when data is organised into files, each file is organised into a number of rows and columns this is referred as a table or ‘flat file ‘

Question 2

what makes up a table

Answer 2

rows and columns

Question 3

What is a record

Answer 3

A record is represented as a row in table

Question 4

What is a field?

Answer 4

A field is a part of a record that stores a single data item represented by a column

Question 5

What is a key field or primary field

Answer 5

A key field uniquely identifies one record

Question 6

What is a Query

Answer 6

A query searches and filters data in the database and satisfies the query criteria

Question 7

What are Forms?

Answer 7

Forms are used to collect data to create a new record, modify an existing record or view records already stored in a table

Question 8

What are Reports

Answer 8

Reports are used to present results from queries in an effective manner

Question 9

What are Macros

Answer 9

A small program written to perform a repetitive task automatically

Question 10

what are the 6 data types and what are they used for

Answer 10

Short Text/string
used for text fields such as names and addresses

Number
used for number fields

Data/Time
used for data fields such as DOB

Currency
used for monetary Valves

AutoNumber
used for ID’s or valves that generate automatically.

Lookup Wizard
used to Select fields from only a selected list.

Question 11

What is Data Validation

Answer 11

Ensures that the data is reasonable, Sensible and within acceptable limits. It guarantee that data is presented and the correct it will red will display type range or length is entered. in error message an if data is

Question 12

Data verification

Answer 12

a method of checking data is input correctly e.g. proofing

Question 13

Types of Data Validation

Answer 13

Data Type Check
Length Check
Range Check
Format Check
Presence Check

Question 14

Explain Range Check

Answer 14

Ensures that data entered is within a upper and lower limit

Question 15

Example of Range Check

Answer 15

A Persons month of birth should be in the range
1 Jan to 12 Dec
(lower limit) (Upper Limit)

Question 16

Explain Presence Check

Answer 16

Ensures that data is presented, it can’t be left blank or null

Question 17

Explain Data Type Check

Answer 17

This is used to check that all data is entered in the correct data type e.g. numeric, text and data

Question 18

Explain Format Check

Answer 18

a format check will determined that data entered matches a predetermined pattern.

Question 19

Explain Length Check

Answer 19

Ensures data is the Correct number of characters e.g. phone number should be 11 digits

Question 20

What are Database Relationships

Answer 20

Database relationships link two or more tables in a database using a relationship type

Question 21

What are the different types or relationships

Answer 21

One to One
One to Many
Many to Many

Question 22

What is a foreign key

Answer 22

The key field is a primary key or key field that has been taken from another table.

It connects the two tables by the foreign key using a relationship.

Question 23

Benefits of using forms

Answer 23

When data is entered into a form, it is automatically added into the Specified table and stored as part of the database.

The database designer can control the type and format of the data ensuring that it is Kept consistent and accurate.

They can be customised to include colour and the logo.

Question 24

What are queries (more in-depth)

Answer 24

Queries are a way of searching and extracting data from a database to find the answer to a question.

They queries searched each record and Produces a list of data that satisfies the queries Ceriteria.

Question 25

What is Big Data

Answer 25

refers to large amount of data that have the Potential to be minded for information.

Question 26

What does it mean to be minded

Answer 26

Data mining is the process of Sorting through large data sets to identify patterns and relationships that can help solve business problems through data analysis-

Question 27

What is the 3V’s

Answer 27

Volume
Variety
Velocity

Question 28

Explain Volume

Answer 28

refers to the amount of data stored by organisations

Data is raw figures and facts that is Unprocessed

Organisations now Store large amounts of data from different source, requiring large Storage Capacity hardware

Data Storage is now measured in terabytes.

Question 29

Explain Variety

Answer 29

refers to the different types and variables of data

Data is now stored in many formats e.g. video and images, not just text.

Data can be Structured Semi- Structured or unstructured.

Question 30

Explain Velocity

Answer 30

Refers to the speed at which data can be processed

Due to large volumes of data, there is a need to use more powerful computers to process data more quickly

Question 31

Distinguish between Volume, variety and velocity In the context of big data [6 Mack]

Answer 31

In the big data, The 3 v’s Volume, Variety and velocity are Crucial for the large Scale of data. Volume refers to the amount of data Stored by an organisations. Variety refers to the different types and variables of data. Velocity refers to the speed at which data can be processed at.

Question 32

What is data analytics?

Answer 32

Analysing large volumes of data to produce Useful information.

Beneficial to organisations for making decision and planning for future growth for

Specialised Software Such as for data mining and Statistical analysis are designed to process vast quantities of data

Question 33

Data analytics to Interpret big Data

Answer 33

When data is in different formats it make preparing and processing data more challenging for data analytics.