Week 2 Flashcards
1
Q
What is a data model
A
Establishes the set of principles for representing and organising the storage of data
2
Q
How can the syntax of a data model be described as a hirearchy
A
Data item
Data element
Data structure
3
Q
What does DBMS stand for
A
Database management system
4
Q
Give system examples of DBMS
A
Oracle, DB2 and MicrosoftSQLServer
5
Q
What is a relational database
A
A series of related tables, stored together with the minimum of duplication to achieve a consistent and controlled pool of data
6
Q
What are the characteristics of ‘big data’
A
Volume, velocity, variety and veracity
7
Q
What is data warehousing
A
Logical collection of data that has been extracted from internal operational databases from transactional systems of an organisation
