Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 1 (a) Define the terms below: i. Attribute ii. Domain iii. Entity iv. Relationship v. Entity set vi. Relationship set vii. One-to-many relationship viii.
Question 1 (a) Define the terms below: i. Attribute ii. Domain iii. Entity iv. Relationship v. Entity set vi. Relationship set vii. One-to-many relationship viii. Many-to-many relationship (16 marks) (b) Explain the term transaction and identify FOUR (4) characteristics of a DBMS transaction? (3 marks) (c) Why does a DBMS interleave the actions of dierent transactions instead of executing transactions one after the other? (3 marks) (d) Explain the strict two-phase locking protocol. (3 marks) (Total: 25 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started