CREATE TABLE Courses 
(
   courseID INT AUTO_INCREMENT,
   courseNum VARCHAR(10),
   courseName VARCHAR(40),
   courseDescription VARCHAR(80),
   creditHours FLOAT DEFAULT 3.0,
      CHECK (creditHours BETWEEN 0.0 AND 6.0),
   PRIMARY KEY(courseID)
);