Database Design Flashcards

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

GDPR Implications

A
  1. Processed Lawfully
  2. Used for intended purpose
  3. Limited to data needed
  4. Accurate
  5. Not kept longer than necessary
  6. Held securely
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

GDPR Stands for…

A

General Data Protection Regulation

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

What does a data dicionary describe

A

The structure of a database

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

Data dictionary shows

A

Entity Names,
Attribute Names,
PK, FK
Attribute sizes
Validation

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

What is boolean

A

Yes/No

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

Attribute types

A

Number
Text
Boolean
Date
Time

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

Validation types

A

Prescence check
Restricted Choice
Field Length
Range

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

What is a Entity Relationship Diagram

A

It is an illustration that shows the relationship that exists between entities

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

SQL Stands for

A

Structured Query Language

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

SQL insert into
code

A

INSERT INTO (table_name)
VALUES (value1, value2, …)

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

SQL Update
Code

A

UPDATE table_name
SET column1 = value1, column2 =value2
WHERE (condition)

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

SQL DELETE
Code

A

DELETE FROM table_name
WHERE condition

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

SQL SELECT
CODE

A

SELECT
FROM
WHERE
ORDER BY

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

SQL EQUI-JOIN

A

SELECT
FROM (Both tables)
WHERE condition AND
table1.column1 = table2.column1
ORDER BY

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

What does prescence check mean

A

Cannot leave space blank

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

What does restricted choice mean

A

Can only choose from given list

17
Q

What does field length mean

A

Restricts number of characters typed

18
Q

What does range mean

A

Makes sure the data is within a certain limit

19
Q

What is a foreign key

A

A foreign key links 2 tables together

20
Q

What is a PK

A

Primary keys are used to uniquely identify a set of information

21
Q

What is referential integrity

A

The relationship between 2 or more tables
It ensures data will not be duplicated

22
Q

What is the end user requirement

A

The tasks that the end users need to be carried out

23
Q

What is the functional requirements

A

Features that developers must implement to enable users to accomplish their task