Fundamentals of Database

Pg. 03 Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper	Question Three

Assignment 1

Deadline: Day 16/02/2021 @ 23:59
[Total Mark for this Assignment is 5]

Fundamentals of Database

IT 403

Question One
2 Marks

Learning Outcome(s):LO1

Describe fundamental data and database concepts

Answer the following questions:
a. What does the Atomicity of Transaction feature mean in the context of Databases? Which component of the DBMS internals handles the atomicity?

b. What is the role of DBA (Database Administrator)? In your answer list five functions handled by a DBA.

Question Two
1 Marks

Learning Outcome(s): LO3
Explain the concepts and processes involved in database development

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.
σyear≥2019(sell) ⨝ salesman
Question Three
2 Marks

Learning Outcome(s):LO3
Explain the concepts and processes involved in database development.

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