Classroom Exercise:  A Single Entity Database

Objective:  Use a relational database management system to create and do simple
   querys (selectS) on a single table. 
0. For a localhost database, the table definition below could be typed or 
   retrieved from a source file (source pathname) or copied to the 
   command line/window. Data for inserts or the load utility may be obtained
   from:  http://faculty.tamu-commerce.edu/tombrown/data/student.csv

1.  Elementary querys(doing the relational operation "project"):
    a.  Select the column called sName from the Student table.


    b.  Select sId, sName, and major from Student.


    c.  Select all attributes from Student.


    d.  Project major from Student with duplicates removed.


    e.  List sId and sName for students in order by sName.


    f.  Retrieve student names in descending order by birthdate.


2.  Qualified Retrieval ("selection" or "restrict"):
    a.  Retrieve sName and birthdate from Student where major is equal to the 
        string 'MATH'.


    b.  Show sName and birthdate found in Student where major is 'MATH' and 
        classYear = 'Junior'.


    c.  Select sName from Student where major is 'MATH' or 'CSCI'.  Code this
        two ways: with an OR and also with the IN clause.



    d.  Query Student to find the names of students that do NOT major in 'MATH' 
        or 'CSCI'.


    e.  Make a list of student names beginning with the letter 'B'.

--------      
Student table definition:             
  create table student(                 
    sId       decimal(3) primary key,    
    sName     varchar(12)not null,               
    major     char(4),
    classYear char(8),
    birthdate date
  );       

  Load utility for csv file:   
    load data 
    local infile 'pathname' into table student fields terminated by ',';