Multiple values in one table; need them to be in separate columns
What you need is


a "student" table
a "major" table 
a linking table (also known variously as an "intersection" or "association" or "joining" table). The fancy name for this is "Associative Entity" (if you read nothing else, read this!).


1 row per "student" in the student table - this is critical for good design - otherwise you are going to have to keep track of multiple copies of your student data. This will typically contain their student id, name(s), address, tel: &amp; - PRIMARY KEY student_id.

1 row per "major" - again, no multiple copies of data. Typically contains, id major name, department, prerequisites.... &amp;c. PRIMARY KEY - major_id.

The joining table will probably contain only 1 record per student - the brigher/more hardworking ones might have more than 1 record per student and will just simply contain (student_id, major_id) - the PRIMARY KEY in this case will just simply also be (student_id, major_id). So, a student with 2 majors will have 2 records &amp;c.

You will obviously then have a department table - possibly a joining table for department-major for multi-disciplinary majors? I imagine that most (all) majors will have a primary department?

NEVER have a .csv type arrangement where you have multiple "facts" stored in the same field of a database  - there are two reasons for this:

1) it makes SQL programming impossible and

2) it's a breach of Codd's rules (the second one) which states:


  Rule 2: The guaranteed access rule: 
  
  Each and every data (atomic value)
  in a relational data base is guaranteed to be logically accessible by
  resorting to a combination of table name, primary key value and column
  name.


Even if you don't understand them yet, there is a reason why Codd's rules are regarded as fundamental amongst database practicioners.

Start with this - break down the problem, determine your entities (or "objects", or just plain "things"). Have a table for each one. That and joining tables for "things" which are connected in a 1->n or m->n relationship and you'll at least have the basics right. Come back to us if you have more specific requirements after having done that.