Yahoo Interview Question: You are given a database tabl... | Glassdoor

Interview Question

Software Developer Interview(Student Candidate) Sunnyvale, CA

You are given a database table that keeps track of student

  data. The fields contain id, name, major, current year. How would you improve this table to be more efficient?

Interview Answer

3 Answers


The actual question was more general in how you would you improve this table. It was pretty open ended and seemed to be testing on database concepts. The answer that my interview was looking for was to change the field current year to the date that the student started at the college. This makes it more efficient since current year has to be updated every year whereas the start date is more persistent.

Interview Candidate on Mar 31, 2013

Split name into first and last name -- would be useful for schools since they could order by last name, Also make major its own table -- students can have multiple majors.

TheDude on Apr 24, 2013

This post has been removed.
Please see our Community Guidelines or Terms of Service for more information.

Add Answers or Comments

To comment on this, Sign In or Sign Up.