[Solved] CS313 Assignment 2

Rate this product

Q1. Use the link below :

https://www.db-book.com/db7/university-lab-dir/sqljs.htmland 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. Dont 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 :

a)

b) c)

get students (ID and names) from xxx department who has done courses from a room in building yyyget students who have some A grade as well as a C gradeget 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