DBMS: Exercises based on Relational Model – Part 1
Topics discussed:
A solved problem based on the Relational Model concept:
Suppose that each of the following update operations is applied directly to the database state shown in the figure. Discuss all integrity constraints violated by each operation, if any, and the different ways of enforcing these constraints.
(i) Insert (1004, ‘Peter’, ‘Weston’, 2) into STUDENT.
(ii) Insert (004, ‘Mark’, ‘Stevens’, 28000, 5) into INSTRUCTOR.
(iii) Insert (4, ‘EEE’, B4) into DEPARTMENT.
(iv) Insert (null, ‘Anna’, ‘Smith’, 7) into STUDENT.
(v) Delete the INSTRUCTOR tuples with TID = 002.
(vi) Delete the DEPARTMENT tuple with DNo = 1.
(vii) Modify the DNo of STUDENT tuple with RegNo = 1002 to 3.
(viii) Modify the DNo attribute of the INSTRUCTOR tuple with TID = 003 to 8.

Follow Neso Academy on Instagram: @nesoacademy(https://bit.ly/2XP63OE)

Contribute: http://www.nesoacademy.org/donate

Memberships: https://bit.ly/2U7YSPI

Books: http://www.nesoacademy.org/recommended-books

Website ► http://www.nesoacademy.org/
Forum ► http://forum.nesoacademy.org/
Facebook ► https://goo.gl/Nt0PmB
Twitter ► https://twitter.com/nesoacademy

Music:
Axol x Alex Skrindo - You [NCS Release]

#DBMSByNeso #DBMS #RelationalDataModel