Font size
WorksheetsN5 DDD - Analysis, GDPR and Data Dictionary
Total questions: 62
Worksheet time: 31mins
What is the main purpose of the GDPR act?
To protect personal data and privacy of individuals in the European Union
To regulate internet access for students in schools
To provide guidelines for software development
To control the use of social media platforms
The GDPR affects individuals by:
Protecting their personal data and privacy
Increasing the number of advertisements they see online
Allowing companies to share data without consent
Reducing the speed of internet connections
What is the main purpose of the General Data Protection Regulation (GDPR)?
To give EU citizens greater control over their personal data
To allow companies to collect data without restrictions
To prevent the use of the internet for data collection
To eliminate all data protection laws in the EU
According to the General Data Protection Regulation (GDPR), what must organizations do when they hold personal data?
Be transparent about how they gather and use that data
Keep data collection methods secret from users
Share personal data with third parties without consent
Delete all data after one year regardless of its use
Why does the General Data Protection Regulation (GDPR) strengthen or replace existing data protection laws?
To ensure data protection laws are relevant in the internet age
To reduce the number of regulations for businesses
To make data protection less strict for companies
To allow unlimited data sharing across countries
Which of the following best describes a Data Subject under GDPR?
The individual whose personal data is being collected.
The company responsible for managing data.
A third-party entity that processes data.
A document outlining data collection purposes.
Select the option that lists only examples of personal data as defined by GDPR.
Name, address, device ID, email address.
Company name, server location, website URL.
Data controller, privacy notice, analytics report.
Cloud storage provider, phone manufacturer, software license.
Fill in the blank: The organisation or company that determines the 'why' and 'how' of processing personal data is called the (a) .
Which statement accurately distinguishes a Data Processor from a Data Controller under GDPR?
A Data Processor acts on the instructions of the Data Controller and does not determine the purpose for processing the data.
A Data Processor is responsible for compliance with regulations and manages how data is processed.
A Data Processor is the individual whose data is being collected.
A Data Processor provides mandatory documents to inform individuals about data processing.
A Privacy Notice must specify certain details to the Data Subject. Which of the following is NOT required in a Privacy Notice according to GDPR?
The purpose for data collection.
How long the data will be kept.
The Data Subject's rights.
The name of the software used for data processing.
Which of the following is a right of a data subject under data protection laws?
Right to be informed
Right to sell data without consent
Right to ignore data breaches
Right to restrict government access
Which right enables a data subject to request the deletion of their personal data?
Right to erasure
Right to restrict processing
Right to object
Right to data portability
What is the purpose of the right to data portability for a data subject?
To allow the transfer of personal data between service providers
To prevent any data sharing
To restrict data processing by companies
To erase all personal data from the internet
Which right is specifically related to decisions made by automated systems and profiling?
Rights related to automated decision making and profiling
Right to be informed
Right to access
Right to rectification
Which of the following is NOT listed as a right of a data subject in the context of data protection?
Right to restrict processing
Right to data portability
Right to receive marketing emails
Right to erasure
Which regulation sets out requirements for the lawful processing of personal data in the European Union?
General Data Protection Regulation (GDPR)
Data Retention Directive with additional privacy rules
Freedom of Information Act for EU citizens
European Data Security Regulation (EDSR)
According to the General Data Protection Regulation (GDPR), which of the following is a requirement for processing personal data?
Data must be processed lawfully, fairly, and in a transparent manner in relation to individuals.
Data can be processed for any purpose as long as it is secure.
Data must be kept indefinitely regardless of its purpose.
Data accuracy is optional if the data is held securely.
Under the GDPR, personal data must be limited to the data needed for the declared purpose. What is the implication of this requirement for businesses?
Businesses should only collect and process data that is necessary for the specific purpose they have declared.
Businesses can collect as much data as possible to use for future, undeclared purposes.
Businesses must share all collected data with third parties to ensure transparency.
Businesses are required to keep data for as long as possible to avoid loss.
Which of the following is NOT a requirement under the General Data Protection Regulation (GDPR)?
Personal data must be held securely.
Personal data must be used for the declared purpose only.
Personal data must be kept for longer than necessary.
Personal data must be accurate.
Fill in the blank: According to the GDPR, personal data must be (a) in relation to individuals.
A company collects customer data for a marketing campaign. According to GDPR, what should the company do once the campaign is over?
Delete or anonymize the data if it is no longer needed for the declared purpose.
Keep the data for future campaigns regardless of customer consent.
Share the data with other companies to maximize its use.
Retain the data indefinitely to avoid losing valuable information.
What is the main purpose of a data dictionary in database design?
To define and describe the structure, fields, and relationships within a database
To store actual data records for future retrieval
To provide a graphical user interface for database users
To manage network connections between databases
Fill in the blank: A data dictionary is used to (a) the structure and details of a database.
What is the primary purpose of a data dictionary in database design?
To define the structure of a database by listing entities, attributes, data types, keys, sizes, and validation rules.
To store the actual data records for each entity in the database.
To provide user access controls and permissions for the database.
To generate reports and visualizations from the database.
Which of the following is NOT typically included in a data dictionary?
Entity name
Attribute size
Sample data values
Validation rules for attributes
In the data dictionary example, what is the data type and validation rule for the 'starRating' attribute in the Hotel entity?
Number; Range: >=1 and <=5
Text; Restricted choice: RO, BB, HB, FB
Boolean; Presence check
Date; Range: >=14:00 and <=16:00
Fill in the blank: In a data dictionary, the abbreviation 'PK' stands for (a) .
What is the purpose of a foreign key (FK) in a data dictionary?
To uniquely identify each record within its own table
To link records in one table to records in another table
To specify the data type of an attribute
To validate the length of a text field
A presence check validation in a data dictionary ensures that:
A value must be entered for the attribute
The value must be within a specific range
The value must match one of a set of allowed choices
The value must be a specific length
Which attribute data type is best suited for storing a person's last name in a database?
Text
Number with a character limit
Date in YYYY/MM/DD format
Boolean
Fill in the blank: In SQL software, date data is commonly displayed as (a) .
Which of the following statements about the Boolean data type is correct?
Boolean attributes can only be True or False, 1 or 0, Yes or No.
Boolean attributes can store any string value.
Boolean attributes are used to store decimal numbers.
Boolean attributes are used to store dates in the format DD/MM/YYYY.
A database needs to store the duration of an event, such as 561 hours, 1 minute, and 2 seconds. Which attribute data type should be used?
Time
Date
Text
Boolean
Which attribute data type allows for both integer and decimal values?
Number
Text
Date
Boolean
What does the attribute size in a database field determine?
It shows how long the data can be for a particular field and prevents entry of data that is too long.
It decides the color of the text in the database field and allows unlimited data entry.
It determines the type of data that can be stored, such as text or number, but does not limit the length.
It sets the password protection level for the database field.
If a database field for 'FirstName' has an attribute size of 20, what happens if someone tries to enter a name with 25 characters?
The name will be cut off after 20 characters and only the first 20 will be stored.
The database will automatically expand the field to fit the longer name.
The entire name will be stored without any changes.
The database will reject the entry and delete all data in the field.
Why is it important to set appropriate attribute sizes for fields in a database?
It helps reduce the overall database file size so that the computer system does not waste storage space.
It makes the database look more attractive to users.
It allows users to enter any amount of data without restrictions.
It increases the speed of internet connectivity for the database.
Which of the following best describes the purpose of validation in data entry?
Validation helps check that the data being entered is within the correct limits.
Validation completely prevents all incorrect data from being entered, including user errors.
Validation automatically corrects any mistakes made by users during data entry.
Validation only allows data to be entered if it is perfect and error-free.
True or False: Validation can stop all incorrect data from being entered, including those caused by user error.
True
False
Which type of validation ensures that a user cannot leave a required field empty when entering data into a database?
Presence check
Range check with specific limits for each field
Field length check to restrict characters
Restricted choice from a menu
A database designer wants to prevent users from entering more than nine characters in a National Insurance number field. Which validation method should be used?
Field length validation
Presence check to ensure the field is not blank
Range check to limit the value
Restricted choice to select from a list
Why might a database use a restricted choice validation method?
To reduce mistakes by only allowing selection from a menu or list
To ensure the field is never left blank by the user
To limit the number of characters typed in a field
To make sure numbers entered are within a certain range
A school database requires that the age of pupils entered must be between 11 and 16. Which validation method is most appropriate for this requirement?
Range check
Presence check
Field length check
Restricted choice
What does referential integrity ensure in a database?
The relationship between two tables is always consistent.
Data in a table is always encrypted.
All tables have the same number of records.
Every table has a unique primary key.
Fill in the blank: Referential integrity can be achieved by only allowing data that already exists as a (a) value to be entered as a FK value in the related table.
What is the main purpose of validating a foreign key in a database?
To ensure referential integrity by checking that the data links to a record in the linked entity
To increase the speed of database queries by reducing the number of records
To allow users to enter any value without restrictions
To automatically delete unrelated records from the database
In a school database, why is it important that the form class a pupil is linked to exists in the formclass entity?
To prevent orphaned records in the database
To allow pupils to be linked to multiple form classes
To make the database easier to search
To reduce the size of the database
Refer to the diagram showing a primary table and a related table. What does an orphaned record in the related table indicate?
A record in the related table does not have a corresponding record in the primary table
A record in the primary table is missing a value
All records are correctly linked between tables
The related table contains duplicate records
What is the main learning intention when studying database requirements?
Learning how to identify the requirements of a database.
Learning how to create a database from scratch with advanced features.
Learning how to program a database using SQL only.
Learning how to manage network security for databases.
Which of the following is an example of an end user requirement for a database?
The database must allow users to search for records easily.
The database must use a specific programming language.
The database must be stored on a cloud server.
The database must have a backup every hour.
Which of the following best describes a functional requirement for a database?
The database must be able to generate monthly reports automatically.
The database must be visually appealing to users.
The database must be accessible from mobile devices only.
The database must have a user manual.
A school wants a database that allows teachers to enter grades and students to view their own grades. Is this an end user requirement or a functional requirement?
End user requirement
Functional requirement
Neither
Both
What is the main purpose of the analysis stage when creating a database?
To identify the end user and functional requirements of a database.
To design the database tables and relationships in detail.
To implement security measures for data protection.
To test the database for errors and bugs.
Name one method that can be used to gather information during the analysis stage of database creation.
(a)
Which statement best describes an end user requirement in the context of database design?
A statement that clearly states the tasks users wish to perform.
A list of all possible database errors and solutions, including technical details.
A summary of the database's hardware requirements and network setup.
A description of the programming languages used to build the database.
When describing an end user requirement, what phrase should you begin your sentence with?
(a)
In a school database, which of the following is an example of an end user requirement for office staff?
Insert new records for new pupils.
Design the database tables and relationships.
Configure the school's network security protocols.
Write code to automate data backups.
A school wants to allow office staff to monitor student attendance. Which end user requirement best fits this need?
The end user would like to check the attendance record of a pupil.
The end user would like to update pupil information if they move house.
The end user would like to find the timetable for a specific pupil.
The end user would like to insert new records for new pupils.
Which phrase should you use to begin a sentence when describing a functional requirement for a database system?
The database must…
The database should…
The database could…
The database may…
What does the word 'must' indicate when describing a database requirement?
A mandatory or essential requirement
A recommended feature
An optional feature
A possible improvement
Fill in the blank: In a school database, one database is used to store pupil information and another is used to store (a) information.
Which of the following is NOT listed as a functional requirement for a school database?
Generate random passwords for users
Store pupil data such as name, address, and medical information
Produce sorted lists of information
Create forms to add data
