Databases Flashcards
1
Q
What is an entity
A
an object about which, data will be stored
2
Q
what is an attribute?
A
a characteristic or piece of information about an entity
3
Q
What is first normal form 1NF
A
ensuring a table does not contain repeat attributes, and all data is atomic
4
Q
What is second normal form 2NF
A
Removing data that relies upon part, but not all of the primary key.
4
Q
What is 3NF
A
removing non key attributes that depend on other non-key attributes.
5
Q
What is structured data
A
data that fits into a standard database structure
5
Q
What is Big data
A
a generic term for large or complex databases.
5
Q
What is unstructured data
A
data that does not fit into a standard database layout.
6
Q
What are issues with big data
A
- difficult to store and analyse
- Difficult to automate analysis
- specialised software is needed to manage it
- massive storage is needed
- data is constantly changing
- Concurrency