Fundamentals of Database
|
Pg. 03 |
|
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