Data base Flashcards
What is a table
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 ‘
what makes up a table
rows and columns
What is a record
A record is represented as a row in table
What is a field?
A field is a part of a record that stores a single data item represented by a column
What is a key field or primary field
A key field uniquely identifies one record
What is a Query
A query searches and filters data in the database and satisfies the query criteria
What are Forms?
Forms are used to collect data to create a new record, modify an existing record or view records already stored in a table
What are Reports
Reports are used to present results from queries in an effective manner
What are Macros
A small program written to perform a repetitive task automatically
what are the 6 data types and what are they used for
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.
What is Data Validation
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
Data verification
a method of checking data is input correctly e.g. proofing
Types of Data Validation
Data Type Check
Length Check
Range Check
Format Check
Presence Check
Explain Range Check
Ensures that data entered is within a upper and lower limit
Example of Range Check
A Persons month of birth should be in the range
1 Jan to 12 Dec
(lower limit) (Upper Limit)
Explain Presence Check
Ensures that data is presented, it can’t be left blank or null
Explain Data Type Check
This is used to check that all data is entered in the correct data type e.g. numeric, text and data
Explain Format Check
a format check will determined that data entered matches a predetermined pattern.
Explain Length Check
Ensures data is the Correct number of characters e.g. phone number should be 11 digits
What are Database Relationships
Database relationships link two or more tables in a database using a relationship type
What are the different types or relationships
One to One
One to Many
Many to Many
What is a foreign key
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.
Benefits of using forms
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.
What are queries (more in-depth)
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.
What is Big Data
refers to large amount of data that have the Potential to be minded for information.
What does it mean to be minded
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-
What is the 3V’s
Volume
Variety
Velocity
Explain Volume
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.
Explain Variety
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.
Explain Velocity
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
Distinguish between Volume, variety and velocity In the context of big data [6 Mack]
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.
What is data analytics?
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
Data analytics to Interpret big Data
When data is in different formats it make preparing and processing data more challenging for data analytics.