DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed, The underlined attributes are the respective primary keys. Schema I: Registration(rollno, courses) Field ‘courses’ is a set-valued attribute containing the set of courses a student has registered for. Non-trivial functional dependency rollno → courses Schema II: Registration (rollno, coursid, email) Non-trivial functional dependencies: rollno, courseid → email email → rollno Schema III: Registration (rollno, courseid, marks, grade) Non-trivial functional dependencies: rollno, courseid, → marks, grade marks → grade Schema IV: Registration (rollno, courseid, credit) Non-trivial functional dependencies: rollno, courseid → credit courseid → credit Which one of the relational schemas above is in 3NF but not in BCNF? (A) Schema I (B) Schema II (C) Schema III (D) Schema IV Other subject playlist Link -------------------------------------------------------------------------------------------------------------------------------------- ►Theory of Computation https://www.youtube.com/playlist?list=PLxCzCOWd7aiFM9Lj5G9G_76adtyb4ef7i ►Operating System: https://www.youtube.com/playlist?list=PLxCzCOWd7aiGz9donHRrE9I3Mwn6XdP8p ►Database Management System: https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y ►Computer Networks: https://www.youtube.com/playlist?list=PLxCzCOWd7aiGFBD2-2joCpWOLUrDLvVV_ ►Artificial Intelligence: https://www.youtube.com/playlist?list=PLxCzCOWd7aiHGhOHV-nwb0HR5US5GFKFI ►Computer Architecture: https://www.youtube.com/playlist?list=PLxCzCOWd7aiHMonh3G6QNKq53C6oNXGrX ►Design and Analysis of algorithms (DAA): https://www.youtube.com/playlist?list=PLxCzCOWd7aiHcmS4i14bI0VrMbZTUvlTa ►Structured Query Language (SQL): https://www.youtube.com/playlist?list=PLxCzCOWd7aiHqU4HKL7-SITyuSIcD93id --------------------------------------------------------------------------------------------------------------------------------------- Our Social Media: ► Subscribe us on YouTube-https://www.youtube.com/gatesmashers ► Like Our page on Facebook - https://www.facebook.com/gatesmashers ► Follow us on Instagram-https://www.instagram.com/gate.smashers -------------------------------------------------------------------------------------------------------------------------------------- ►A small donation would help us continue making GREAT Lectures for you. ►Be a Member & Give your Support on bellow link : https://www.youtube.com/channel/UCJihyK0A38SZ6SdJirEdIOw/join ►UPI: gatesmashers@apl ►Paypal Account: paypal.me/GSmashers ►For any other Contribution like notes pdfs,feedback ,suggestion etc [email protected] ►For Bussiness Query [email protected]