Decompose the above relation into 2NF and 3NF, explaining each step clearly.

Explain the following concepts with respect to the relational data model, giving one data-science–
oriented example for each:
 Candidate Key
 Functional Dependency
 Referential Integrity
 Selection Operation
 Projection Operation

Consider the following schedule involving two transactions T1 and T2 operating on a dataset table
storing aggregate metrics:

Compute the final value of X (assume initial X = 100).
(ii) Determine whether the schedule is serializable.
(iii) Identify the concurrency issue involved and explain its impact on analytics accuracy.

Consider the relation:
Dataset(DatasetID, DatasetName, Source, CollectionDate, Domain, OwnerName, OwnerEmail,
UpdateFrequency)
 Identify the primary key

 List meaningful functional dependencies

Perform the following using SQL:
 Create tables with appropriate primary and foreign keys
 Insert sample data (minimum 5 researchers, 6 publications)
 List publications by a given researcher
 Find researchers who have not authored any publication
 Find the publication with the highest number of authors
 List venues that have more than two publication

Centralized vs Distributed Databases in Large-Scale Analytics