Databases Flashcards

(20 cards)

0
Q

What’s a database management system?

A

A database management system is a software system that enables the management of a database. E.g access, SQL, ORACLE

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

Define the word database

A

A database is a structured collection of data

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

What’s a data model

A

A method of describing the data, it’s stucture.

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

What’s an entity

A

An entity is an object/person/event about which data is recorded

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

What’s a relationship?

A

A relationship is an association or link between two entities

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

What are names for a row?

A

A record or a tuple

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

What are other names for a column

A

Field and attribute

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

What is entity occurrence

A

The details of one instance of the entity

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

What’s a primary key

A

An unique attribute which uniquely identify a tuple

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

Relational database is?

A

A collection of tables

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

What’s composite key

A

A combination of attributes that uniquely identify a tuple

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

What’s a foreign key?

A

An attribute in one table that is a primary key in another table

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

What is meant by normalised entities

A

A set of entities that contain no useless/redundant data

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

What’s normalisation

A

A technique used to produce a set of normalised entities

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

What’s 1NF

A

Table have primary key and there’s no repeating groups of attributes (atomic values)

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

What’s 2NF

A

Must be 1NF and contain no partial key dependencies - where the values of the attributes are all independent on the primary key

16
Q

What’s 3NF

A

Table is in third normal from if it is in 2NF and where no attributes are predictable because of any other attributes

17
Q

What does SQL stands for?

A

Structured query language

18
Q

Why is 3NF important?

A

It improves consistency
No unnecessarily repeated data
Eliminate update/insertion/deletion anomalies

19
Q

What does 3NF means

A

Every attribute is dependent on the key, the whole key and nothing but the key.