Interview Question in SQL Server Performance Tuning
Interview Question :: Create a relational database for student information system with E-R Diagrame
student information system should contain the information about student,class,room,teacher,time-table,se...
Design the ER Diagrame with all relationships.
Give an SQL DDL defination of the database.Identify referencial integrity constraints that shoule hold,and includethem in DDL defination.
Write the SQL statements which illustrates the use of cartesian product','RESTRICT' and JOIN operations on the above database.
Show the normilazation of tables with proper justification.
Get the names of students who have secured B grade in a computer science coursr csi-14 in the autumn semester.

Loading ...