Subject: Database Management System

2 Q.3. For the following relation: Street Street House Sector House Sector Address Address Roll TID City City First_name First_name TEACHER teaches STUDENT S_Name Middle_name Middle_name Name PROGRAM Last_Name Experience Age Date of Joining COURSE Last Name Course Date of Birth i. Create tables with the help of the above relation. ii. Apply normalization up to BCNF on each table. 111. Once normalization is completed, create final ERD again (reverse engineering). iv. Follow the scenario as indicated in the given relation. (hint: this ERD is NOT correct/stable, it will be totally different from what you will get in the end, if attempted correctly.)