Wednesday, September 21, 2011
DBMS LAB - for University Data base schema
(building varchar(15),
room_number varchar(7),
capacity numeric(4,0),
primary key (building, room_number)
);
create table department
(dept_name varchar(20),
building varchar(15),
budget numeric(12,2) check (budget > 0),
primary key (dept_name)
);
create table course
(course_id varchar(8),
title varchar(50),
dept_name varchar(20),
credits numeric(2,0) check (credits > 0),
primary key (course_id),
foreign key (dept_name) references department
on delete set null
);
create table instructor
(ID varchar(5),
name varchar(20) not null,
dept_name varchar(20),
salary numeric(8,2) check (salary > 29000),
primary key (ID),
foreign key (dept_name) references department
on delete set null
);
create table section
(course_id varchar(8),
sec_id varchar(8),
semester varchar(6)
check (semester in ('Fall', 'Winter', 'Spring', 'Summer')),
year numeric(4,0) check (year > 1701 and year < 2100),
building varchar(15),
room_number varchar(7),
time_slot_id varchar(4),
primary key (course_id, sec_id, semester, year),
foreign key (course_id) references course
on delete cascade,
foreign key (building, room_number) references classroom
on delete set null
);
create table teaches
(ID varchar(5),
course_id varchar(8),
sec_id varchar(8),
semester varchar(6),
year numeric(4,0),
primary key (ID, course_id, sec_id, semester, year),
foreign key (course_id,sec_id, semester, year) references section
on delete cascade,
foreign key (ID) references instructor
on delete cascade
);
create table student
(ID varchar(5),
name varchar(20) not null,
dept_name varchar(20),
tot_cred numeric(3,0) check (tot_cred >= 0),
primary key (ID),
foreign key (dept_name) references department
on delete set null
);
create table takes
(ID varchar(5),
course_id varchar(8),
sec_id varchar(8),
semester varchar(6),
year numeric(4,0),
grade varchar(2),
primary key (ID, course_id, sec_id, semester, year),
foreign key (course_id,sec_id, semester, year) references section
on delete cascade,
foreign key (ID) references student
on delete cascade
);
create table advisor
(s_ID varchar(5),
i_ID varchar(5),
primary key (s_ID),
foreign key (i_ID) references instructor (ID)
on delete set null,
foreign key (s_ID) references student (ID)
on delete cascade
);
create table time_slot
(time_slot_id varchar(4),
day varchar(1),
start_hr numeric(2) check (start_hr >= 0 and start_hr < 24),
start_min numeric(2) check (start_min >= 0 and start_min < 60),
end_hr numeric(2) check (end_hr >= 0 and end_hr < 24),
end_min numeric(2) check (end_min >= 0 and end_min < 60),
primary key (time_slot_id, day, start_hr, start_min)
);
create table prereq
(course_id varchar(8),
prereq_id varchar(8),
primary key (course_id, prereq_id),
foreign key (course_id) references course
on delete cascade,
foreign key (prereq_id) references course
);
Tuesday, August 30, 2011
CAT Scores for MBA Admission in IITs and IISc
The Joint Management Entrance Test (JMET) previously used for admission by the IITs and the IISc stands discontinued, according to an IIM press release.
The decision was taken after a recent review revealed that the relatively young JMET is not too dissimilar to CAT, and that the effort to organise JMET each year seemed enormous in relation to the approximately 40,000 candidates who took the test each year.
"The intersection of candidates who take both CAT and JMET in a single year is quite large. The decision to use CAT for admission into the IITs and IISc will minimise the test preparation and financial burden on candidates," said LS Ganesh, former head of the IIT-Madras management department.
The five original IITs - Kharagpur, Bombay, Madras, Kanpur and Delhi - as also IIT-Roorkee, are among India's earliest institutions to have offered postgraduate and research programmes in management since the 1960s.
"CAT is an ideal fit for IITs as it is a well-evolved, established, standardised and widely accepted entrance exam for admission into PG programmes in management in India," Ganesh said.
"This is a major initiative that brings two premier higher education systems together. We anticipate that this will result in closer tie-ups and collaborative research work that will provide both sets of institutions a competitive edge in the long run," CAT 2011 convenor Janakiraman Moorthy said.
CAT 2011 will be conducted over a 20-day window from October 22-November 18 across 36 cities.
Friday, August 19, 2011
To succeed ; one needs luck and character : Mr N. R. Narayana Murthy
He stressed that, to succeed, one needs luck and character. “But luck requires hard work and when you perform, you get recognition, respect, and power.” While talking about the importance of teamwork.
He highlighted the need to recognise and reward top performers. “If you don't identify the high performers and reward them, they will lose motivation. However, high performance should not make you arrogant because arrogance leads to hubris.”
But hard work alone would not help you if you cannot defeat your mindset, said Mr Murthy. “The mind is an engine of progress, while your mindset is a database of experience which holds you back. So, you must use your mind to defeat your mindset.”
Businees Line
Thursday, August 18, 2011
Next Generation Operating System - Windows 8
Tuesday, August 2, 2011
Getting Placed Off Campus: A Guide
Companies representatives visit these campuses to initiate the annual ritual of hiring. Eligible students (With Your TPO) appear for test ( Computer Based or Paper Based). The test is divided into two sections: Analytical Reasoning & Arithmetic Thinking and Verbal Ability. The first tests the candidate's learnability and problem-solving skills. The Verbal Ability test ascertains that the students have good communication skills, and have their fundamentals of English right.
Off Campus Hiring: The company conducts off campus selection from time to time depending on business needs. While campus hiring is focused on a particular set of colleges, the off campus hiring process enables students across the country to seek an opportunity with IT companies. This helps them to spread the hiring net farther into small towns to take students from colleges that otherwise do not feature on the campus-visiting list.
3. Self-confidence is the key to crack.
4. Discipline and punctuality.
6. Commitment and dedication.
7. The ability to work in teams.
10. Make Projects list ……….
Sunday, July 31, 2011
Finding Security Flaws in Facebook , Get $ 500 By Facebook
Friday, July 29, 2011
New Format for CAT 2011- IIMs
The two sections would be: Quantitative Ability and Data Interpretation and Verbal Ability and Logical Reasoning.
In the new method, the IIMs have clubbed the sections which were divided into three parts in the older method.
The candidates will also be provided 15 minutes tutorials before the examination starts, making the total time two hours and 35 minutes. The test will be conducted between October 22 and November 18, 2011. Candidates will have 70 minutes to answer 30 questions in each section which will have an on-screen countdown timer. Once the time ends for the first section, they will move to the second and will not be able to go back. Earlier, the three sections had 20 questions each.
Best of Luck
Thursday, July 28, 2011
Email Intervention from Google
On the Email Intervention home page Google has embedded a video to make us know how the email intervention works, and also Google explains why people now need to switch to Gmail. There are options to send email intervention message to one or to multiple. Google tags this service saying, “It’s time to make the switch.”
Tuesday, July 26, 2011
A Mobile OS from Mozilla
The beauty of the project, B2G, being envisaged by Mozilla is that it takes Chrome’s open source ideas to the mobile space. For instance, B2G will have ways for developers to get at phone functions like placing calls and taking pictures. The kernel is based on Android, at a very low level. ..........
Thursday, July 21, 2011
Features that makes Google+ more interesting ... Do not miss it ...... but use it
Cloud computing to create one lakh jobs in India
'Of the projected $4.5-billion total cloud computing market in India by 2015, private cloud will account for $3.5 billion, generate about 100,000 additional jobs and save about 50 percent of cost of IT operations for Indian enterprises,' the study 'Private Cloud Landscape in India', by Zinnov Management Consulting and global IT firm EMC Corporation, revealed.
In cloud computing, multiple servers are used as a single platform through a digital network (website) under secured environment with access to a range of applications and tools for reducing the cost of IT operations.
Read the complete article http://in.finance.yahoo.com/news/Cloud-computing-create-one-ians-946279741.html.
Tuesday, July 19, 2011
Hey ! Hi, Welcome to new Entrant in new College……. Make it big from now onwards, ……..
It's a whole new chapter in your life. You leave behind the secure environment of your school and your childhood and embark upon an education that will have a direct impact upon your career.... So rock it till the time you are in college.
College is a new place full of challenges, right from making good friends to balancing study time and freedom .... freedom. so start it on right way with right direction...
A. Explore your new college campus. Explore the facilities provided the college .Come a little earlier than usual and walk around your campus before your classes begin and get familiar with the layout and various departments and places eg the library, canteen, gymkhana, auditorium etc.
B. Make new friends as you moving from one corner to another corner. Do not miss the orientation programme. Introduced yourself. Interact with seniors students of the college. Talk to them; seek their advice and learn more about your stream and course. You can use their experience and tackle freshman issues better. Choose your new friends wisely.
C. Find out who the best professors from your college are and take time off and introduce yourself to them after the class. You have to spend the rest of the semester under their guidance. How much you enjoy any course depends to some extent upon your relationship with the professor. Don't be scared to raise your hand and ask your professors questions if you don't understand something. There is no such thing as a stupid question. Your question may be one that others may also have, but just haven't asked for the same reason as you. Remember, professors are there to help you. If they insist on meeting you after class, find time for the same. "Also ensure that you are not overdoing it. Keep your relations as brief and academic as possible .
D. Attend classes regularly. While it may be tempting to bunk college and indulge in a game of football with friends, do not do so at the cost of your attendance. Maintain 90-95 percent to appear for better understanding of the subject and marks in exams. Otherwise you are in the list of “Defaulter “in the College. .
E. Participate the Extra Curricular activities. Do not shy and hesitant to participate in extra-curricular activities as per your taste like in singing , dancing , debates, elocution, painting, organizing etc.
F. identifies the difficult subjects in your semester. Chalk out a timetable and allot yourself time to prepare for each subject. Always keep a copy of syllabus and do not wait till the last day to submit work on a subject . Attend Labs session more and more.
More information from Rediffmail.
Most students think that they can make more friends by bunking lectures. Wrong. In fact, they can make more friends by sitting in a class and sharing knowledge.
Friday, July 15, 2011
Marketing tools/methods for Admissions in Engineering+Management
a>
--
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext 216
+91-0172-3984216 (Direct)
+ 91- 9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp
Thursday, July 14, 2011
10 reasons why Google+ can never vanquish Facebook
Google's decision to try its luck one more time in the social market with its Google+ platform is somewhat surprising. Over the last several years, Google has attempted to vanquish top players in the social market with the help of Orkut and Google Buzz. In both cases, it failed, even though those services are still in operation.
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext 216
+91-0172-3984216 (Direct)
+ 91- 9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp
Tuesday, July 12, 2011
Infosys to hire 45,000 this fiscal
Keeping up the hiring momentum, the country's second largest software exporter Infosys today said it will hire about 12,000 people this quarter.
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext 216
+91-0172-3984216 (Direct)
+ 91- 9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp
Saturday, May 7, 2011
Thursday, April 21, 2011
IMPORTANT : REG. IDEATION FEST
It is for information of the students that the IDEATION FEST would be held at CGC, Landran on 5th MAY, 2011. Moreover All the members of I-Spark club are required to attend the meeting at office of HOD CSE on 22 APRIL at 10 am. Attendance is compulsary for all club members. The club members would be assigned duty and responsibilities for for the fest. Besides, all participants must note the following in regard to the Ideation Fest:
1. All participants will be given 2-3 minutes to present their ideas followed by questions/clarifications by the Steering Committee members.So,They are advise to sum up their ideas in 2-3 Power Point slides only. This is per the instructions from Microsoft just to see the actual innovative mind of the participant.
HOD CSE
Wednesday, April 20, 2011
Freshers for the role of Systems Engineer - Infosys Hiring
Candidates must have a consistently excellent academic track record.
Only Candidates who are graduating in the year 2011 are eligible to apply.
Candidates should not have participated in the Infosys selection process in the last 9 months.
Please note that the resume should mandatorily carry date of birth, e-mail id, complete academic details starting from std. 10 / 12 / Graduation / Post graduation along with Year of passing, simple average aggregate Percentages/CGPA, Board / University. Also, mention the preferred location of test center in the subject line (Bangalore/Chennai/Delhi/ Hyderabad/ Kolkata/Mumbai/Pune/Trivandrum).
Students can mail their resumes to freshers2011@infosys.com on or before April 22, 2011. Only short listed candidates will be directly informed via e-mail about the selection process.
--
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext 216
+91-0172-3984216 (Direct)
+ 91- 9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp
Tuesday, February 8, 2011
'Society for IT Engineers' (SITE) @ DTU
With a view to make budding professionals of Information Technology (IT) aware about latest developments in the field of IT, the Department of Information Technology of Delhi Technological University (DTU), formerly Delhi College of Engineering, has established a students' body - 'Society for IT Engineers' (SITE).
SITE was formerly inaugurated today by Mr. Savitur Prasad, IAS, Secretary, Department of IT, Govt. of Delhi along with Prof. S.C. Dutta Roy, IIT Delhi, Prof. P.B. Sharma, Vice Chancellor, DTU, Prof. O.P. Verma, Head of IT Department, DTU and Dr. N.S. Raghava, Faculty Advisor, SITE among others. Welcoming the distinguished guests, Prof. Sharma said, "Technical societies in educational institutions play a crucial role in bridging the gap between what the course curriculum offers to the students and what the industry expects. I am hopeful that SITE would act as a connection between the world of academia and world of industry and aid us in transforming graduating engineers to professional engineers."
Stating that IT has made rapid strides in all areas of human activity, Prof Roy urged students to take IT to those sections of society that have not been benefited by IT. "Can you reverse 'Society for IT Engineers' to 'IT Engineers for Society' and do something for not just your own professional development but for the society at large," he asked the students.
Chief Guest at the occasion, Mr Prasad, complimented the University for establishing a Society for IT students. He even invited DTU students to work with them on live projects undertaken by the Department of IT, Govt. of Delhi. He said, "We are keen to provide efficient services and readdress grievances of residents of Delhi in a more effective way, by using IT, and I call upon the students to think about how we can achieve that. I would like DTU students to conceptualize and implement new projects in E-Governance and citizen services."
The inaugural function of SITE was followed by a technical session by Mr Tapan Paul, Regional Sales Head, Motorola India. SITE would be organizing several activities like workshops, seminars, projects etc. for students to nurture their technical skills and unleash their talent in areas like programming, designing, web development, image processing, robotics, hacking, animation and others.
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext 216
+91-0172-3984216 (Direct)
+ 91- 9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp
Fulbright –Nehru fellowships for teachers, lecturers announced
Outstanding Indian students, academics, teachers, policy planners, administrators and professionals in all disciplines can apply, an American embassy statement said.The scholarship program offers opportunities for teachers and lecturers to pursue courses in the US.
Some of the scholarships offered for faculty in India include Fulbright-Nehru Visiting Lecturer Fellowships, Fulbright-Nehru Environmental Leadership Program, Fulbright-Nehru Postdoctoral Research Fellowships, Fulbright Foreign Language Teaching Assistant Program and Fulbright Teacher Exchange Program among others.
The application forms are available on USIEF website. The academic/professional qualifications, date of birth, present position, and fellowship category should be mentioned in the request letter. Applicants are also advised to request three referees to send in their recommendations, either on the Reference Report Form or the referee's letterhead (as specified in the Preliminary Application Form).
The recommendations should be sent to the Executive Director, USIEF, 12 Hailey Road, New Delhi 110 001 by the application due date. In case of employed candidates, the employer's comments in the application form must indicate that leave will be granted for the fellowship.
More details are available on USIEF site or Fulbright scholarship site.
The India-US bilateral Fulbright agreement has resulted in a significant increase in the number of scholarships awarded each year. USIEF expects to offer approximately 120 Fulbright-Nehru fellowships for Indians in 2012. The Fulbright Program offers grants to U.S. citizens and nationals of other countries for teaching, advanced research, graduate study and professional development. Since its inception, approximately 300,000 scholars have participated in the Fulbright Program. Over 7,000 Fulbright grants were awarded to U.S. and foreign nationals in the academic year 2008-2009.
--
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext 216
+91-0172-3984216 (Direct)
+ 91- 9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp
Saturday, January 15, 2011
simple tips to give your house a fresh look without any additional expenses
Group aesthetics It's easy-do, and looks different. Rummage through your ancestral bell metal, copper or silver plates and holders. Arrange pots and jugs on a tray or plate and top up with twigs, berries and leaves, anything that catches your eye - no need for expensive flowers. It is the arrangement of unconventional vases, grouped together, that creates the USP.
Bottled up! Put together an attractive ensemble using bottles in various shapes and sizes, dress each bottle up with bits of lace and place similar blooms inside to lift them out of the ordinary and create a harmonious group. Tip: Don't overcrowd, try small flowers with long stems such as Pride of India or Baby's Breath. Change the water daily for a fresh, clean look.
Communication station Easy organising To keep track of the daily onslaught of slips, bills, and junk mail, set up this station in your study. A wall-mounted magazine rack gives each family member a slot for his or her papers, a look here calendar is for quick reference, along with flyers, invites, and such.
Things to keep and things to toss out-
Keep - an envelope tacked to the bulletin board to stash coupons, gift certificates, or other money-savers you might need to grab on your way out, saving you cash without costing you that other valuable asset - time.
Toss - one thing for every new item you bring in. When you've got this much coming in and out, it's easy to have everything pile up. So once something goes in your magazine or mail bin, something must go out.
Keep - a trash can or recycling bin for all the mail and papers you've dealt with - or already know are junk. When possible, sign up for online opt-outs such as electronic billing.
1. Sort smart: Stop mail clutter - use a tiered bin with three sections: In for important mail (bills, papers???), Out for outgoing mail, Read for materials to peruse later (magazines, books???). Have children place important paperwork for you in the 'In' box, once handled, move it to their slot (on previous page).
2. Make note: A sticky note on the door is the perfect can't-miss-it reminder. Tuck the notepad and pen in a bin (near your station) meant for holding outgoing items, say those library books that are due tomorrow.
3. Pen it in: A colour-coded calendar (with a different hue for each person) will keep the family on schedule. Just jot down events that involve multiple members (may be activities that require a driver...). Purge your bulletin board of no-longer-needed papers when you change the calendar page.
Reproduced From Good Housekeeping. © 2011. LMIL. All rights reserved.--
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext 216
+91-0172-3984216 (Direct)
+ 91- 9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp
Government revises PhD scholarship
Government has revised the rates of Ph.D. Scholarship in AICTE funded and centrally funded technical institutions under the Ministry of Human Resource Development. All the students pursuing Ph.D. Programmes Junior Research Fellow or Senior Research Fellow are entitled to receive the revised amount of fellowships.
Scholars with graduate Degree in Professional Courses (BE/ B. Tech or equivalent) and GATE or equivalent qualification 1st & 2nd year will receive Rs. 16, 000 per month as stipend. Those with Post Graduate Degree in Basic Sciences (MSc or equivalent) and NET qualified will now get Rs. 18, 000 per month till 5th year. Earlier, it was 14,000 for third and fourth year. While for fifth year it was 15,000. While, students who hold M.E. / M. Tech degree or equivalent will get Rs. 18, 000 instead of Rs. 14, 000 for the first and second year. While the third and fourth year candidates will get Rs. 20, 000 in place of the 15, 000. The revised fellowship is also applicable to government aided Institutions funded by AICTE & UGC.
However, no salary grant or any other salary grant would be given to any of the institutes implementing this scheme. The fellowship will not be granted to sponsored and self- financed category of students including those in receipt of any other similar assistantships/ scholarship/ fellowship. The fellowship applies to scholars on the basis of GATE scores above the prescribed cut-off level. B.Tech graduates from the IITs getting a CGPA score of 8 or above (on scale of 10) would also be entitled to the assistantship without having to appear in GATE.
The local institution should review the performance of the fellow after two years through an appropriate review Committee constituted by the Head of the Institution. The fellowship in the slab after 2 years of research experience may be provided after successful assessment by this review Committee.
--
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext 216
+91-0172-3984216 (Direct)
+ 91- 9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp
--