1. Introduction Flashcards

1
Q

What do we want to do with data?

A

Add files
Removes files
Add data
Retreive data
Alter data
Remove data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Database System

A

Computerised record-keeping system

Databases are centralised sources of data in an organization

Components:
-Hardware
-Software (DBMS)
-Users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Database Concepts

A

Databases are integrated and shared

Databases store persistent data = entities + relationships

Transactions

Data independence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Benefits of using databases

A

-Data is shared easily
-Reduces redundancy
-Avoids inconsistencies
-Supports transactions
-Maintains integry
Enforces security
-Enforces standards

How well did you know this?
1
Not at all
2
3
4
5
Perfectly