The interview process with Yahoo began with a simple chat with a recruiter at my college career fair. Afterwards, I received an email asking me to apply online.

What was different from most other companies is I didn't get a phone screen. Instead, Yahoo simply set up an on-site interview and flew me into their headquarters as part of a program known as "Yahoo Days."

When I arrived at the on-site, there were many other candidates there for the program. After signing in, we were all escorted to a large room where we were given an introduction to Yahoo and the program. It seemed that this program was especially targeted at university graduates.

After that, we took a quick tour of the campus, followed by lunch. Afterwards, we were all taken into separate rooms by our first interviewer.

There were a total of four interviews, and it seemed each interview was focused on a specific area, including:

• Data structures & algorithms
• C/C++ or C/Java programming
• Object-oriented/system design
• Database/debugging/misc

The interviewers seemed to have freedom to conduct the interview however they pleased. In general, all of the interviewers asked me questions about my resume and then led into the more specific area targeted by the interview.

You are given a database table that keeps track of student data.

The fields contain id, name, major, and current year.

How would you improve this table to be more efficient?