Part A
Q1. Use the link below : https://www.db-book.com/db7/university-lab-dir/sqljs.htm l and go through all the table definitions in the university schema. Make a note of all integrity constraints.
Q2. Take one student and get all his data from various table. Select a student who has some courses, grades, etc. Don’t take someone who has no data in other tables. Make a full profile of the student.
Q3. Try out the various queries we studied in the class.
Q.4 try out the following additional queries :
get students (ID and names) from xxx department who has done courses from a room in building yyy
get students who have some A grade as well as a C grade
get all buildings and rooms which have classes on Wednesday
Note : choose values in avowed queries (like xxx, yyy, Wednesday extra such that your queries give some result. Modify queries if required. For example, choose Monday if Wednesday gives an empty answer).
Part B
Install PostgreSQL database on your system. See the packages already downloaded and given to you and follow the instructions given in the lab worksheet also already given to you in the lab folder. Contact TAs on WhatsApp for any help (including a voice call if required)
