Answered You can hire a professional tutor to get the answer.

QUESTION

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.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question