Programming 2- module 12) Flashcards

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

What does ‘SQL’ stand for?

A

Structured Query Language.

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

What do relational databases hold data in?

A

A structured format.

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

What does ‘DBMS’ stand for?

A

Database Management System.

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

What are relationships in a relational database?

A

One-to-one.
One-to-many.
Many-to-many.

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

What is the One-to-one relationship within a relational database?

A

When each entry in our student table has only one relationship in another table.

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

Why is the One-to-one relationship in a relational database not used much?

A

If there is only one link, that data could often by held on the single table.

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

What is the One-to-many relationship within a relational database?

A

Most common type of relationship: each record in one table links to one of more tables in another table, but each record in second table links to only one record in first table.

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

What is the Many-to-many relationship within a relational database?

A

When each record in one table links to one or more in the second, and vice versa.

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

What is the definition of a relational database?

A

A database that holds data in structured format identifying links between fields.

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

What is the definition of ‘Field’?

A

A single unit of data stored about an entity, stored with other fields to create a record.

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

What is the definition of a ‘primary key’?

A

Field with contents unique to each record enabling otherwise identical data records to still be separated and processed accurately.

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

What is the definition of a ‘foreign key’?

A

Primary key in one table, and included in another linked table.

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

What is the definition of ‘decomposition’?

A

Decompose data into multiple tables, to limit duplication of data entry and storage as far as possible.

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

What is the definition of ‘unstructured’?

A

No clear method of organising to the level of structured data.

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