Lecture slides , class notes of module 3 posted in the site. visit this page
0 Comments
Physical Database Design and Tuning (20 marks)
Explain about views in SQL (5 mark) Thank you dear students for active participation in online sql quiz conducted at this week. Average performance is 70%.
Now you can see the answers you marked and the correct answers and review it. For getting it pls login to the system using the students login menu. with your university number as user name and password(new password if you changed) If you dont remember password, contact me, i will reset password (i wont be able to recover passwords) After logging in select Database management systems Select SQL Quiz In that your mark and grade of 100 will be displayed as link Follow that link to know the answers If you see any mistake in the answer key pls inform me by this weekend I found this site a useful one where in u can download many IT and Compute Science related text books for free. Access this site : http://it-ebooks.info/
Thanks to Alin Sir for Introducing this website to me Have you visited the site: http://www.loremate.com/ It contains a collection of notes for many engineering subjects which may help in passing exams. The notes on Database Management System can be accessed at this link
Thanks to Havinash Sir for introducing this website to me I Have created an online sql quiz for 6th CS students (2010 admission). Click on the link Students Login under subjects menu.
If you do not see students login in the menu you can directly access at this link http://sankarpn.in/moodle Login with the user name: your university number in small letters password: sahrdaya Time: 25 min Number of Questions: 35 Cut off mark: 80% No negative marking Only one attempt is allowed per user For the first time logging in, you many be asked to change password After logging select the course Database Management Systems then select SQL Quiz Click Attempt Quiz now Contact me if you face technical difficulty during attempt you can go to any questions click save without submitting in between to save your answers once you finish all questions only click submit all and finish After finishing test you can view your score Comment about the experience after finishing test Wish you all the best I have created a oracle appliction express login
there you can experiment all sql statements you studied use the following details for logging in use the follwing url http://apex.oracle.com/pls/apex/f?p=4550:1:::::F4550_P1_COMPANY:SANKAR enter the following details: Workspace: SANKAR Username: [email protected] Password: sahrdaya Pls not this is just for educational purpose only. You cannot use it for commercial application development 1. Briefly explain about specifying constraints on Create Table Statement in SQL (Discuss the constraints which are not discussed in class) (12 marks)
2. What is CREATE DOMAIN . Give one example (2 marks) 3. Briefly discuss about secondary storage devices (11 marks) I have entered the marks for first series test for cs09604 dbms. Pls verify the mark by logging to intellinet. Inform me if any corrections
Recently I have gone through an article by Dr. Achuth Sankar. It is 108 Questions for young teachers. Answers are not given. But still we can go through the questions and think about it. It will definitely help to improve as a teacher. Access the document at here
|
SankaranarayananMyself, Sankaranarayanan, Working as Assistant Professor in Department of Computer Science and Engineering, Sahrdaya College of Engineering and Technology Archives
December 2014
Categories
All
|