University of California, Berkeley Data Management Class Set 3 (1)
pdf
keyboard_arrow_up
School
University of California, Berkeley *
*We aren’t endorsed by this school
Course
140
Subject
Information Systems
Date
Apr 3, 2024
Type
Pages
3
Uploaded by UltraSnowBear26
University of California, Berkeley
Set 4
1. Database Design and Modeling
Short Answer:
●
Explain the difference between a primary key and a foreign key in a database.
Why is each type of key important?
Essay:
●
Describe the process of normalization in database design. Why is normalization
important, and what problems does it solve? Provide examples of first, second,
and third normal forms.
2. SQL Queries
Practical:
●
Given a database table
students
with columns
student_id
,
name
,
major
, and
graduation_year
, write an SQL query to find all students majoring in Computer
Science who are set to graduate in the year 2024.
Multiple Choice:
Which of the following SQL statements is used to remove rows from a table without
deleting the table itself?
A) DELETE
B) DROP
C) TRUNCATE
●
D) REMOVE
3. Data Governance
Short Answer:
●
What is data governance, and why is it critical for organizations?
Essay:
●
Discuss the role of a data steward in an organization. How does a data steward
contribute to data quality and regulatory compliance?
4. Data Privacy and Security
Multiple Choice:
Which of the following is a principle of the General Data Protection Regulation (GDPR)?
A) Right to be forgotten
B) Data minimization
C) Transparency
●
D) All of the above
Essay:
●
Explain the importance of encryption in protecting data at rest and data in transit.
Discuss the differences between symmetric and asymmetric encryption,
providing examples of when each type is used.
5. Big Data and NoSQL Databases
Short Answer:
●
What distinguishes NoSQL databases from traditional relational databases, and
in what scenarios are NoSQL databases preferred?
Practical:
●
Given a NoSQL document-based database structure where each document
represents a product with fields for
product_id
,
name
,
category
, and
price
, write
a pseudo-query to find all products in the "electronics" category that are priced
over $100.
These questions are designed to test a range of competencies, from understanding
basic database concepts and the ability to write SQL queries to deeper knowledge of
data governance, privacy principles, and the use of NoSQL databases in managing big
data.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help