Rajwinder Singh

DBMS LAB - for University Data base schema

2011-09-21T22:14:00.000-07:00

create table classroom
(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
);

CAT Scores for MBA Admission in IITs and IISc

2011-08-30T05:41:00.000-07:00

The Indian Institutes of Technology (IITs) and the Indian Institute of Science (IISc) have decided to use CAT 2011 as part of the selection process of their MBA and management programmes from the academic year 2012-13.

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.

To succeed ; one needs luck and character : Mr N. R. Narayana Murthy

2011-08-19T23:51:00.000-07:00

On the last day in office, Mr N. R. Narayana Murthy, who is transitioning from the Chairman of Infosys Ltd to its Chairman Emeritus, advised his colleagues to work hard.

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

Next Generation Operating System - Windows 8

2011-08-18T18:49:00.000-07:00

Microsoft has released a new blog to the public for showing the stages of developing the next generation of its operating system, Windows 8. Also known as B8, is a way for the company to create a channel of dialogue with users about the project’s design choices and new opportunities that Windows 8 will provide.

Getting Placed Off Campus: A Guide

2011-08-02T02:06:00.000-07:00

One million students try their luck with Infosys/ Wipro/Accenture/ but only a fraction makes it. How to get the edge.

There are two ways of getting a entry in the above . One is the campus hiring. The second is off campus recruitment which takes place on a need basis.

On-campus hiring: Starting a Year in Advance
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.

Learnability is crucial as it demonstrates the potential employee's ability to keep pace with the fast-changing technologies in the dynamic IT industry. Recognizing patterns, ability to gain conceptual understanding and decision making in uncertainty are some of the aspects assessed.

Shortlisted candidates then proceed for the interview. The interviews are behavioral in nature and try to assess students on aspects such as oral communication, problem-solving, analytical ability, soft skills, and conceptual knowledge.

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.

Most of the companies have a well-defined career path for employees with clear detailing of responsibilities. Join the organization as software engineers, the system provides the flexibility for them to switch over to multiple career streams once they have attained the requisite experience, competency levels and proficiency.

Follow these to stand apart from the rest:

1. You must know Company profile e.g. Infosys

Revenue: US$ 4.8 billion +

Market capitalisation: US$ 33 billion +

Employee strength: Over 113,000 +

Global presence: Infosys has presence in 30 countries +

2.      You must know your job description.

3.      Self-confidence is the key to crack.

4.      Discipline and punctuality.

5.      Decision making ability and Honesty

6.      Commitment and dedication.

7.      The ability to work in teams.

8.      In-depth functional knowledge

9.      Ready to take risk and innovation.

10.   Make Projects list ……….

The interviews are rigorous but are not overly tough to crack.

Finding Security Flaws in Facebook , Get $ 500 By Facebook

2011-07-31T03:35:00.000-07:00

Facebook is rewarding $500 or more to computer security experts to identify vulnerabilities in social networking. To show appreciation to the security researchers, the company has came forward to offer them monetary rewards and recognition, said the Facebook Official blog. The person who finds a flaw first and responsibly discloses the loophole to the company is sure to get rewarded. The company will only award for the unknown flaws

New Format for CAT 2011- IIMs

2011-07-29T20:43:00.000-07:00

The Indian Institutes of Management (IIMs) have announces a new format for CAT 2011. With the same number of questions, this year’s CAT will have two sections instead of three and an extra five minutes to take the test.

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

Email Intervention from Google

2011-07-28T05:23:00.000-07:00

Google has started an exclusive service known as Email Intervention to help you, me and all to help others to switch to Gmail who are with other outdated, may be, email service provider.
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.”

A Mobile OS from Mozilla

2011-07-26T20:46:00.000-07:00

The organisation whose Firefox browser many of us are currently using, Mozilla, is currently working on a "complete, stand-alone operating system for the Web." The system is being called by the name of Boot to Gecko, or B2G, and it is being designed solely for mobile devices.

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. ..........

Features that makes Google+ more interesting ... Do not miss it ...... but use it

2011-07-21T18:35:00.000-07:00

Google has come up with a very novel idea of offering a substitute for Facebook to world around. It has inaugurated the service named Google+ that is said to provide a much private and secure medium for subscribers which Facebook failed to serve. Google+ is the tech giant's latest attempt to crack the social network market.

1. Circles - The “Circles” concept of the Google is far more comparable to our real life friend circles than the “ad hoc” group concept of the Facebook. Everyday, we interact with hundreds of people but not always in the same way. The Google+ lets you create different circles to which you can add different people you want. For example, you can create one circle for your family, one circle for your work people, one for your old classmates and as many as you want. The biggest touted perk is that you can share the things with the circle that you want and the other circles won’t ever know of it.

2. Using the '+' One of the key features of Google+ is its streamlined approach to online sharing. Google has described the process as "awkward, even broken" and their new network aims to fix that.

Google+ is integrated into the navigation bar at the top of almost all Google products, which allows users to keep track of their Google+ notifications without doubling back to the main Google+ homepage.

3. Integration : Integration is one of the biggest feature that Google has in its hands to win over the audience. It's nothing but all of Google's existing online services like Gmail, Docs, search features are combined on to a single platform in Google+ and you can do everything on the same site.

4. Sparks : Google has done something that Facebook will not be able to do, with Google+ Spark.

When you are networking on Facebook, you often have to leave the site for finding shareable information with your friends. Google+'s Spark is an instant solution to that problem. Google has optimised its search engine to provide instant search for finding stuff you wanna share. Since Facebook doesn't have a search engine, it is obvious that this feature can't be provided by Facebook.

5. Hangouts - The feature allows users to pull groups together for a simultaneous video chat. You can chat with up to ten people in the group video chat option. Forming ad hoc groups to have a little chat with people you know seems a little too fun.

6. Better mobile apps Google+ has a lot better apps for Android users, rather than Facebook. You will find that it's a lot more easier to get stuff on your Google+ profile than it ever was on Facebook.

Google Plus provides alternative to many of the problems seen with Facebook.

Thanks to Satish Kumar and Gordon Macrae , Technicnal Blogger for providing the information. Acknowlegment to differnet URL for accessing the information.

Cloud computing to create one lakh jobs in India

2011-07-21T06:01:00.000-07:00

As the next technology wave, cloud computing by enterprises has the potential to create about 100,000 new jobs in India, a study said Tuesday.
'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.

Hey ! Hi, Welcome to new Entrant in new College……. Make it big from now onwards, ……..

2011-07-19T04:07:00.000-07:00

New to College atmosphere....

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.

Marketing tools/methods for Admissions in Engineering+Management

2011-07-15T03:39:00.001-07:00

Objective : To increase the Admissions in Engineering+Management ...... Do the following in advance .

a>

Rajwinder Singh
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

Engineering discipline advertised by IndianOil	Corresponding GATE –2011 paper	Corresponding GATE –2011 paper code
Chemical Engineering(Incl. Petrochemicals)	Chemical Engineering	CH
Civil Engineering	Civil Engineering	CE
Electrical Engineering	Electrical Engineering	EE
Instrumentation Engineering	Instrumentation Engineering	IN
Mechanical Engineering (excluding Production/ Manufacturing/ Industrial)	Mechanical Engineering	ME
Metallurgical Engineering	Metallurgical Engineering	MT

Rajwinder Singh

DBMS LAB - for University Data base schema

CAT Scores for MBA Admission in IITs and IISc

To succeed ; one needs luck and character : Mr N. R. Narayana Murthy

Next Generation Operating System - Windows 8

Getting Placed Off Campus: A Guide

Finding Security Flaws in Facebook , Get $ 500 By Facebook

New Format for CAT 2011- IIMs

Email Intervention from Google

A Mobile OS from Mozilla

Features that makes Google+ more interesting ... Do not miss it ...... but use it

Cloud computing to create one lakh jobs in India

Hey ! Hi, Welcome to new Entrant in new College……. Make it big from now onwards, ……..

Marketing tools/methods for Admissions in Engineering+Management

10 reasons why Google+ can never vanquish Facebook

Infosys to hire 45,000 this fiscal

Business Line : Today's Paper / INVESTMENT WORLD : A secure wallet for plastic money

IMPORTANT : REG. IDEATION FEST

Freshers for the role of Systems Engineer - Infosys Hiring

'Society for IT Engineers' (SITE) @ DTU

Fulbright –Nehru fellowships for teachers, lecturers announced

simple tips to give your house a fresh look without any additional expenses

Government revises PhD scholarship

Happy New Year 2011

Interesting article written by an Indian Economist - Do not Save

Admit card for PTU exam Dec 2010

Panel Starts Skills Test For Management Students

Online filling of PTU examination form

URGENT!!!!!

Track your PNR Status, Track your Train Timing

Infosys is hiring Freshers of 2010 batch

Panjab University Results To Be Computed Online

Unique Identification To Track Fake Degrees

14 Tips To Build A University

Indian Oil Corporation Limited ( IOCL ) is recruiting through GATE 2010

Cisco Certified Architect (CCA)

C++ queries

Joint campus Placement by Qwest at Amritsar College of Engineering & Technology, Amritsar 28 August 2010

Fwd: Invitation of Final year Project by TECPEDIA for Awards

General Instructions for students for campus placements

SELECTION FOR QUALIFIED / FINAL YEAR ENGINEERS (MEN & WOMEN)

TCS Hiring

hi