5. Data And Databases Flashcards
(33 cards)
Data can be one of two different structural forms; What are they
structured data or
unstructured data.
Define data
text, values, symbols, images or sound that have not been given any meaning.
Define information
data that has been processed by giving it context and meaning
Define machine learning
a type of artificial intelliqence that uses data and algorithms to learn and adapt its processes
Define structured data
data that has a specific format
eg:- machine learning
define qualitative data:
data that cannot be easily measured, such as written descriptions
define quantitative data:
data that can be measured, such as a set of numeric values
What is unstructured data:
data that has no specific format
What is the main benefit of using a structured format to collect data?
It is easy to analyse and helps inform marketing decisions.
eg: quickly access customer details, track inventory, or generate reports
What is a major drawback of using an structured format?
limited detail — customers can only choose from the options provided, which might not fully capture their opinions or emerging preferences.
Features of structured data
- Organized Format
- Easily Searchable
- Clearly Defined Data Types
- High Data Quality
- Limited Flexibility
What is the main benefit of using an unstructured format to collect data?
It allows customers the freedom to provide any information they want.
What is a major drawback of using an unstructured format?
It is very difficult to analyse due to the lack of a set format.
Features of unstructured data
- No Fixed Format or Schema
- Free-Form Input
- Difficult to Search and Analyze
- Harder to Organize
What is data extraction?
the process of collecting data from various sources and processing it to retrieve meaningful information
How can meaningful information from data extraction help organisations?
improve daily actions and procedure
increase sales
enhance services.
What is data mining
A process where a large amount of data is collected for analysis.
What is relational database.
a database that has multiple tables that are linked together using certain fields as keys
What are three different types of keys that links databases together
primary key
foreign key
composite key.
What is a primary key in a database?
a field in a database that is used as a unique identifier for a record:
this is because the data stored in the field is
unique for each record
Why is a primary key important in a database?
It ensures that each record can be uniquely identified.
The benefits of having a primary key in a database
- helps prevent duplicate records being created in a database
- helps with updating or deleting a specific record
- helps set up relationship links between different tables in a database.
What is foreign key:
a primary key that appears in another table in the database to create a link between the
two tables
Define a composite key:
two fields in a table that are combined to create a unique identifier for the table
