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.