Database Management Systems - Exercises based on Relational Model (Part 1)

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://bit.ly/3EpZgBD Memberships: https://bit.ly/2U7YSPI Discord: https://bit.ly/3HiGtJr WhatsApp: https://whatsapp.com/channel/0029Va9B1Bq4tRru0nqgtx3h Books: https://bit.ly/4cZYQil Website ► https://www.nesoacademy.org/ App ► https://play.google.com/store/apps/details?id=org.nesoacademy Facebook ► https://www.facebook.com/nesoacademy Twitter [X] ► https://x.com/nesoacademy Music: Axol x Alex Skrindo - You [NCS Release] #DBMSByNeso #DBMS #RelationalDataModel