Let's tackle those database questions. Task A: DATABASE 2) Create a table with the following fields using appropriate datatype: Adm No, FName, LName, Course, DOB, Completed. Save table as "Student Details" To create the "Student Details" table, here are the fields with their appropriate data types: Adm No: Number (or AutoNumber if automatically generated, but Number is suitable for manual entry) FName: Short Text LName: Short Text Course: Short Text DOB: Date/Time Completed: Yes/No (Boolean) 3) State the appropriate primary key that can be used in "Student Details" table The appropriate primary key for the "Student Details" table is Adm No.

We read your photo as:

Task A: DATABASE

May 5, 2026Computer Science

ScanSolve AI Answer

Let's tackle those database questions.

Task A: DATABASE

2) Create a table with the following fields using appropriate datatype: Adm No, FName, LName, Course, DOB, Completed. Save table as "Student Details"

To create the "Student Details" table, here are the fields with their appropriate data types:

Adm No: Number (or AutoNumber if automatically generated, but Number is suitable for manual entry)
FName: Short Text
LName: Short Text
Course: Short Text
DOB: Date/Time
Completed: Yes/No (Boolean)

3) State the appropriate primary key that can be used in "Student Details" table

The appropriate primary key for the "Student Details" table is Adm No.

Was this helpful?

Still stuck on this one?

Ask a follow-up, and the answer starts from this question.

Got a different question?Ask your own question

Task A: DATABASE

Still stuck on this one?

More Computer Science Questions