Answered You can hire a professional tutor to get the answer.
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
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.