Manipulating data: Practice Questions

Big Data is often characterized by the '5 Vs'. Which 'V' refers specifically to the uncertainty or trustworthiness of the data being collected?

A company is moving from a flat file system to a relational database to improve data integrity. During the process of normalisation, which of the following is the primary goal when moving data into the Third Normal Form (3NF)?

Which of the following is a primary problem associated with data redundancy in a relational database?

In the context of database management and data integrity, which validation rule would be most effective at ensuring that a field for a student's 'Examination Score' only accepts values between 0 and 100?

A database designer needs to ensure that a 'Social Security Number' field always follows the pattern of three digits, a hyphen, two digits, a hyphen, and four digits (e.g., \(000-00-0000\)).
Which validation technique should be used?

Manipulating Data: Big Data and Integrity
Big Data is often characterised by several 'Vs'.

a. Explain the terms Velocity and Veracity as they relate to Big Data. (2 points)
b. A database stores employee IDs in the format EMP followed by five digits (e.g., EMP00123). Design two specific validation rules that could be used for this field to ensure data integrity and explain how each ensures the data is accurate. (3 points)