SMS - Use of SMS on imparting Technical Education

Click here to access the form

Summary of responses:

1. The SMS service is active since a year and all students of 6th sem (Now in Final Year - 2007-2011 Batch) have subscribed to it .
	Yes 66 99% No 1 1%

2. Was this kind of service used earlier, before it was initiated by Me (Mayur Patil) ?
	Yes 12 18% No 55 82%

3. Has the SMS service been effective and useful to you ?
	Yes 67 100% No 0 0%

4. Which were the techniques used earlier to communicate any important and relavant information during and after college hours , if it were required ?
	Notice Boards 50 75% Rumours 8 12% Websites 7 10% Others 2 3%

5. In what all ways the SMS service has been effective and useful ?

Teaching Aid 44 66% Communicating - conduction of extra classes or cancellation of classes 64 96% Sending important website links as message 61 91% Alerting, if any important mail was sent to your inbox 65 97% Added as a supplementary tool in teaching 38 57% Sending class lecture summary, after the classes (Although done for a very short period) 42 63% People may select more than one checkbox, so percentages may add up to more than 100%.

6. Bottom Line: Should the SMS service be continued ?
	Yes 67 100% No 0 0%

7. Do you feel this SMS service could still have been used in much more effective way ?
	Yes 34 51% No 33 49%

8. If you choose yes, to the above question, write in what way(s) it could be improved ?

1.Alerting when results are out, because many of the students will b out of station during holidays by that will not get to know about the results... they'll depend on local students. instead if u send SMS that results are out on website n so. That will be helpful...!! ..no improvementit is good as it issome msgs r recieved very slowly....so it has to be decided wen it has to be delievered....The sms service is good and it should be continued.no..Not Aplicable as i haven chosen it as No...We could not receive some messages (which may be fault of network ) but I felt it worth mentionin...

9. Your comments on use of SMS service as a supplementary tool in imparting education:

1. Actually its very good idea. 2. very helpful for us. 3. It should continue. 4. great job sir.Sir it is really a good idea..sir, Its very useful and also it enhances the standard of teaching..continue it...thank you sir, it is a wonderful initiative.Yes SMS service has been a very good tool in imparting education ......it is one way of communicating a msg or sending some important notices.....its really helpfulit is a very good way to communicate important messages.it was helpful for all students. Thanks for implementing this service. It should be continued...It is really a very good ini...

Some of My Other Message Services

Actually, soon after this initiative of SMS service to you and its success, I started with SDM_Alerts - SMS alert service for all faculty of our college (which is still being used) and a separate alert service for MBA Department and SDMite_Alerts - for all students of our college and SDMite_Alumni - For all alumni of our college (Although it still needs publicity) Hmmm,All said and done, your suggestions/opinions in this regard would help me to take many more initiatives in future in this direction.

Number of daily responses

DBMS - CAT (IA)

PFA the IA-1 and IA-2 solutions.

IA-3 will be mailed in the evening...

Please remember - all 3 ia papers are very important.

CAT - 1 - Scheme

CAT - 2 - Scheme:

DBMS Slides

For Your Information:

DB2 CERTIFICATION Training scheduled on Sep 2,3 and 4th  2010.

Certification on 13th September.

DB2,RAD and other IBM Certification have lot of value in IT industry.

Training wil be provided by IBM and it is free.

It has been made compulsory for u all.

Some reading material related to DB2 will be mailed to u , before u leave for vacation.

HAPPY STUDY HOLIDAYS!!!

All Best for ur Upcoming Semester End Exams.

 

Theory Study Materials:

 

Slides on - The Relational Data Model and Relational Database Constraints Elmari Navathe (5th Ed) - 5.1-5.3

 

The Relational Algebra and Relational Calculus 6.1 to 6.5

Functional Dependencies and Normalization for Relational Database

Use of SMS on imparting Technical Education

Form - Use of SMS on imparting Technical Education

Responses are stored here

 

Self Learning - FOSS

!Self Learning!

Hello friends. Since this semester, we have some extra time we can do a bit of self learning. Only thing is you have to is, fill this form with topics/anything which you want to learn and are not a part of our academics. If we have more than 10 learners in a topic, we will post the topic open for anybody who wants to teach the topic. Once done, we will request department to provide us with classroom/other nessecities and proceed.

 

Click here to access the form

Here are the responses

Project Report Format

Click here to access the Project Report Format Files

DBMS - Mini Project . Synopsis Submission Form

The Synopsis reflects your understanding of the problem domain as of now i.e before implementation of the project. You are allowed to change it during and after implementation of your project, as, you will be having a better understanding of the project then. In the form given below for synopsis submission, if any field is irrelevant or Not Applicable, then you can leave it blank or write N / A.

 

Click here to access the form

DBMS - Mini Project - Synopsis Submission Form - Entries Filled

Assignment of DBMS - Mini Project

 

Please find the excel sheet containing DBMS Mini Projects.

 

For any clarification regarding any project, meet me in the DBMS lab tomorrow [ Both 6 - A and  B, Batch wise].

 

Do remember that you have to submit the synopsis before 19th of this month.

 

Also find the End Users / Remarks column against your assigned project.Now your next step is to collect the requirements from the ACTUAL END-USERS of the software being developed by YOU.

 

Go through the list and come prepared tomorrow with your understanding of the software [mini-project] on pen and paper.

 

[This phase is known as SOFTWARE REQUIREMENTS COLLECTION phase.]

DBMS Mini Project

DBMS Mini-project has 2 phases. 1.PART - A for 1 month , to get familiar with SQL basics. 2.PART - B ,actual mini-project implementation [Related work to be done in parallel in PART - A, refer deadlines given below.] ---------------------------------------------------------------------------------- PART - A CODE: CS353 DATABASE MANAGEMENT SYSTEMS LAB / MINI PROJECT COMPUTER SCIENCE DEPARTMENT, SDMCET, Dharwad All PART - A,term-works are based on the below problem domain or SRS. [From Navathe] The COMPANY database keeps track of a company's employee, departments and projects. Suppose that after the requirements collection and analysis phase, the database designers provided the following description of the 'miniworld' - the part of the company to be represented in the database. 1. A company is organized into departments. Each department has a unique name, unique number and a particular employee who manages the department. We keep track of the start date when that employee began managing the department. A department may have several locations. 2. A department controls a number of projects, each of which has a unique name, a unique number and a single location. 3. We store each employee's name, social security number, address, salary, sex and birth date. An employee is assigned to one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee works on each project. We also keep track of the direct supervisor of each employee. 4. We want to keep track of the dependents of each employee for insurance purposes. We keep each dependent's first name, sex, birth date and relationship to the employee. ------------------------------------------------------------------------------------ TERM WORKS [FOR A DIV ONLY] ------------------------------------------------------------------------------------ Week Term Work Date 1 Lab -1 : Feb 1st-6th A. Introduction and getting familiar with Oracle software. B. CREATE table Employee,Department & Dept_Location. C. Use INSERT,DELETE,SELECT,DROP table queries. Lab -2: A. CREATE all the required tables . B. INSERT at least 5 rows into each table. C. Use DEFAULT,PRIMARY KEY,FOREIGN KEY,ALIASES etc wherever required. D. Use ALTER table,UPDATE table,DROP Column,SELECT, FROM, WHERE clause wherever required. 2 2 Lab -1 : Feb 8th-13th A. Use GROUP BY,HAVING, ORDER BY etc wherever required B. Renaming,Commenting table/Column etc Lab -2: A. Use SQL Operators:AND, OR,NOT,ANY,UNION,MINUS, INTERSECTION,<,>,<>,=,IN,BETWEEN,NOT IN,EXIST, NOT EXIST, LIKE , NULL etc 3 Lab -1 : Feb 15th-20th A. Use of Built in Functions: ABS,CEIL,FLOOR, MOD,POWER,ROUND,SIGN,SQRT,TRUNC,CHAR,INITCAP, LOWER,SOUNDEX,COUNT(*),DATE related functions. Lab -2 : A. Co-Related Sub Query,JOIN (Inner,Outer,Left,Right etc), Writing queries for user search requirements. 4 A. PL-SQL,Triggers,Cursors,Stored procedures Feb 22nd-27th -------------------------------------------------------------------------------- PART - B ------------------------------------------------------------------------------ PLEASE NOTE: 1. MINIMUM 1 and MAXIMUM 4 studnets per team. 2. Team members should belong to the same batch. 3. Team once formed will not be allowed to change. 4. No TEAM is alowed do the same project. 5. In the below form, just write down names of your team members and the 2 preferences of your project, from the below given list.[In case of any clashes,it will be resolved by me.] 6. Teams of A & B divisons will have to do different projects. 7. Ultimately all projects will be finalized by us[MBP/UPK]. STICK TO THE DEADLINES MENTIONED BELOW. ------------------------------------------------------------------- Sl.No | Activity | Last Date | ------------------------------------------------------------------- 1 | SYNOPSYS SUBMISSION* | 19 / Feb / 2010 | 2 | SUBMISSION OF DESIGN (ER Diagram) | 26 / Feb / 2010 | 3 | IMPLEMENTATION | 26 / Mar / 2010 | 4 | TESTING | 09 / Apr / 2010 | 5 | REPORT & PPT | 16 / Apr / 2010 | 6 | DEMONSTRATION | 23 / Apr / 2010 | ------------------------------------------------------------------- *Regarding SYNOPSYS SUBMISSION: Soon after the finalizing your project problem domain, you have to collect the requirements from the end-users of the software[mini-preoject],[Will be expalined to you by me] which you have to submit as the SYNOPSYS or SRS [Software Requirements Sepcification]. CHOOSE one among the following as your preference [to be mention in the form below]. 1.Leave Application System for faculty 2.Blood Group Tracker for students 3.Library Management Software 4.Inter-communication Software for college 5.Final Year Projects List Managements 6.Generalized event registration software for students 7.Digital Work Dairy for staff at College level – Activity Tracker 8.Hobby Management for students 9.Dynamic Website for Industrial Estate – Gokul Road 10.Hospital Management Software 11.Shop Management Software 12.Simulating tally, and then modifying it according to client's name. 13.Alumni Block Booking, Seminar Hall, CCF Booking etc 14.Automated Birth day wisher thru mail,SMS 15.Placement Details Tracker 16.Alumni Data Bank – Highly Complicated 17.Buy-Sell Electronic goods within SDM 18.Buy-Sell Property within Hubli-Dharwad 19.Social Networking site only for SDMCET students, Alumni-Highly Complicated. 20.Career Launcher – For students, Keep all last date of all competitive exams 21.Insurance reminder – For students, faculty 22.All forms of all application , B.E , M-Tech, MBA, MCA , QIP, Alumni Block booking form, etc etc – Scan it, store it – With different templates 23.Book my show in Hubli, Dharwad, 24.Tours- Travels Network in Hubli Dharwad 25.Kalyan Mantap booking(Marriage Hall,Decorates,Caters etc) in Hubli – Dharwad 26.Provide mobile medical services for Senior Citizens, by storing health infmtn 27.Second hand computer peripherals sale in Hubli-Dharwad 28.Showroom Database System - Project 29.Time-Table Scheduler 30.Retail Management System 

Click here for the form

DBMS Lesson Plan

Click here to access DBMS Lesson Plan

DBMS Mini-Project

Each student is required to post at-least one project idea. Ex: Leave Application,Blood group Tracker etc. Please Note: 1.Team Size MINIMUM 1 and MAXIMUM 4 students per team. 2.TEAM MEMBERS SHOULD BELONG TO THE SAME LAB BATCH. Ex: 1 student from A1 and 2 students from A2 and 1 from A3 are not allowed.

Click here to access the form

DBMS Lab

Click here to access DBMS Lab File