18CS53 DBMS Exam Paper Pattern

Firstly, regarding any questions you need help, DM me on insta (@_afuu) If you choose to regret later, skip the video parts in between. These are not most important questions, there are a lot in PYQs. These are just model qp problems to give you an idea of how to solve those questions. 0:00 DBMS: CAKEWALK (40+ marks) strategy 5:25 Module 2&3 (SQL queries) Model QP-1 18CS53 (CS) 5:30 Q. 4c (Works_on table) 13:41 Q. 5c (Company table) Model QP-2 18CS53 (CS) 22:40 Q. 5a (Employee-Project table) 30:00 Module 4 (3 algo + problems & Normalization questions) 30:17 Non-additive join property algo 30:32 Finding minimal cover algo 30:38 Finding closure algo 30:47 Minimal cover problem (repeated 2 times) 38:48 Closure property problem (repeated 4 times) 40:52 Find primary key. What is highest normal form? Normalize into 3NF 46:47 Normalize the following table to 3NF (Employee-Project table) 48:18 Lossless join property problem (repeated 2 times) - can skip if hard 54:36 Module 5 (Serializable or not) algo + 4 questions SQL queries, Minimal Cover problems, Serializability PDF link: https://drive.google.com/file/d/1NSC0SRZX6dPx_x4aDgzyxx30i93GWflQ/view?usp=sharing If I have helped you in anyway, please do like and subscribe! Thank you ;)