write my assignment 12636

I need help with this  assignment  but there isn’t any way to submit the work that I have done so far,  I have the file created but having some trouble finishing

Create a table named STUDENTS with the following fields. If a field is marked as not required, it needs to be a part of the table, but the user does not have to enter data into that particular field. Do not change the field names, data types or data sizes – follow directions as specified below):

StudentId – autonumber – unique id/primary key

StudentFirstName – text(20)

StudentMiddleName – text(20-not required)

StudentLastName – text(30)

BirthDate – date

Major – text(50)

Minor – text(50-not required)

CertificateProgram – text(50-not required)

ClassLevel – Freshman, Sophomore, Junior, Senior, Graduate

GPA – decimal number with 3 decimal points between 0 & 4.000 (for example 3. 456)

SemesterHoursCompleted – number between 0 & 180

AdmissionDate – date

GraduationDate – date (not required)

Creat at least 5 records in the STUDENTS table created above. All values must be meaningful and within the data type  and range as specified in the table.

 
"Not answered?"
Get the Answer