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.
Answers to "Create a relational database for student information system with E-R Diagrame"
RE: Create a relational database for student information system with E-R Diagrame?

Just so you know I have over 40 years of experience in the IT field. And SQL is one of my favorite DBMS's.



So, how much are you willing to pay me for this?



Have fun but be safe.
 
Vote for this answer ::  
RE: Create a relational database for student information system with E-R Diagrame?

How do you expect someone to answer this on the internet.....

As it is time consuming and also needs the diagram...

and if you are doing this as a college example i will advise you to look up s good book on Database concepts and do the designing all by yourself,this way you will learn things also......
 
Vote for this answer ::  
RE: Create a relational database for student information system with E-R Diagrame?

Refer the book DATABASE SYSTEM CONCEPTS



SILBERSCHATZ · KORTH · SUDARSHAN



and below links

http://66.102.7.104/search?q=cache:54_DJ...



http://www.infocom.cqu.edu.au/Courses/sp...
 
Vote for this answer ::  
Update Alert Setting