Answer the following questions:

q1:

1. What does the Atomicity of Transaction feature mean in the context of Databases? Which component of the DBMS internals handles the atomicity?
2. What is the role of DBA (Database Administrator)? In your answer list five functions handled by a DBA.

q2:

Consider the following expression, which uses the result of a relational algebra operation as the input to another operation. Explain in words what the expression does.

year2019(sell) salesman

q3:

Consider the database of authors, papers, citations. With the following relation

Author (AID, name, address, phoneNo)

Paper (PID, title, year)

AuthorPaper (AuthorID, PaperID)

a) What are the appropriate Primary Keys for the schema?

b) Define the following terms: Primary Key, Foreign Key, an atomic value