Database Design Flashcards
GDPR Implications
- Processed Lawfully
- Used for intended purpose
- Limited to data needed
- Accurate
- Not kept longer than necessary
- Held securely
GDPR Stands for…
General Data Protection Regulation
What does a data dicionary describe
The structure of a database
Data dictionary shows
Entity Names,
Attribute Names,
PK, FK
Attribute sizes
Validation
What is boolean
Yes/No
Attribute types
Number
Text
Boolean
Date
Time
Validation types
Prescence check
Restricted Choice
Field Length
Range
What is a Entity Relationship Diagram
It is an illustration that shows the relationship that exists between entities
SQL Stands for
Structured Query Language
SQL insert into
code
INSERT INTO (table_name)
VALUES (value1, value2, …)
SQL Update
Code
UPDATE table_name
SET column1 = value1, column2 =value2
WHERE (condition)
SQL DELETE
Code
DELETE FROM table_name
WHERE condition
SQL SELECT
CODE
SELECT
FROM
WHERE
ORDER BY
SQL EQUI-JOIN
SELECT
FROM (Both tables)
WHERE condition AND
table1.column1 = table2.column1
ORDER BY
What does prescence check mean
Cannot leave space blank