SLR23 Databases Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

Entity relationship diagram

A

“A data modelling technique that graphically illustrates an information system’s entities and the relationships between those entities. An ERD is a conceptual and representational model of data used to represent the entity framework infrastructure.”

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

Attribute

A

“A single bit of data within a record.”

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

Primary key

A

“A field that uniquely identifies a record in a table.”

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

Composite primary key

A

“When more than one field is added together to form a unique primary key for a table.”

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

Foreign key

A

“The linking field in the foreign table formed when a relationship is made. The FK becomes by default the PK of the new table.”

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

Normalisation

A

“The process of arranging data in tables and setting their relationships to move them through normal forms.”

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

0NF

A

“A table with no normalisation. All data and all fields in one table.”

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

1NF

A

“A relationship with repeating groups removed; a relation in which the intersection of each tuple and attribute contains one and only one value.”

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

2NF

A

“A relation that is in 1NF; every non-primary key attribute is fully dependant on the primary key and all the incomplete dependencies have been removed”

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

3NF

A

“A relation that is in 1NF and 2NF; no non-primary key attribute is transitively dependant on the primary key and all non-key elements are fully dependant on the primary key.”

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

Structured Query Language

A

“The language and syntax used to write and run database queries.”

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

Relational database

A

“Allows the user to specify information about multiple tables and the relationship between those tables.”

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

“A data modelling technique that graphically illustrates an information system’s entities and the relationships between those entities. An ERD is a conceptual and representational model of data used to represent the entity framework infrastructure.”

A

Entity relationship diagram

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

“A single bit of data within a record.”

A

Attribute

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

“A field that uniquely identifies a record in a table.”

A

Primary key

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

“When more than one field is added together to form a unique primary key for a table.”

A

Composite primary key

17
Q

“The linking field in the foreign table formed when a relationship is made. The FK becomes by default the PK of the new table.”

A

Foreign key

18
Q

“The process of arranging data in tables and setting their relationships to move them through normal forms.”

A

Normalisation

19
Q

“A table with no normalisation. All data and all fields in one table.”

A

0NF

20
Q

“A relationship with repeating groups removed; a relation in which the intersection of each tuple and attribute contains one and only one value.”

A

1NF

21
Q

“A relation that is in 1NF; every non-primary key attribute is fully dependant on the primary key and all the incomplete dependencies have been removed”

A

2NF

22
Q

“A relation that is in 1NF and 2NF; no non-primary key attribute is transitively dependant on the primary key and all non-key elements are fully dependant on the primary key.”

A

3NF

23
Q

“The language and syntax used to write and run database queries.”

A

Structured Query Language

24
Q

“Allows the user to specify information about multiple tables and the relationship between those tables.”

A

Relational database