Lecture 4

Question 1

What is a data dictionary

Answer 1

• reference doc that records the properties of all data stored by an org.
• Built after logical model but before physical implementation
• Contains metadata = data about data
  Helps understand and correctly interpret system data

Question 2

What does each table and attribute contain at a minimum

Answer 2

1. Name
2. Definition
3. Data type
4. Size
5. Status (primary key or foreign key)

Question 3

In Airtable, what is an auto number

Answer 3

field type that automatically assign a sequential number to each new record (row).
- Unique identification
- Every table need primary key, auto number is perfect bc unique, mandatory simple
- Can be used as foreign keys in other tables to link records together

Question 4

Why would we use an auto number for Primary key

Answer 4

• Automatically generated  prevents duplicates
• Always present  prevents NULL values
• Keeps referential integrity for relationships
• Makes table management easier in no-code databases like aitable

Question 5

What is the main field

Answer 5

• Main filed is the label column (always first column)

Question 6

What is the bill-25

Answer 6

Information considered personal as soon as it can be used to identify someone. Cannot be communicated without consent of the person concerned

Question 7

What are some of the things that the Bill-25 does

Answer 7

• Enhanced consent: obtain clear, free informed consent to collect data
• Proactive privacy integration: anticipating risks rather than reacting after
• Mandatory impact assessments: Privacy impact decision tree to determine where PIA is required
• Incident notifications: notify both person concerned and CAI in the event of a leak
• Right to portability: provide data in a standardized format to those requesting it
• Right to be forgotten: Delete personal data of person requesting it
• Transparency in use of automation: notify customers as soon as algorithms is used to support decision
• Data governance: appointed data protection officer and implement internal gov. policy

Question 8

What are the benefits of Bill 25 for citizens

Answer 8

1. Enhances information received when collecting personal info
2. Information concerning the use of personal information
3. Have right to erasure and de-indexing
4. Give consent in plain and clear terms
5. Be notified in event of a leak