Information Technology IT – 10 Database and file concepts | e-Consult
10 Database and file concepts (1 questions)
Login to see all questions.
Click on a question to view the answer
| Column | Data Type & Justification |
| StudentID | Integer (Primary Key) - Unique identifier for each student. Integer is efficient for indexing and comparisons. |
| FirstName | Text (VARCHAR) - Variable-length string to store the first name. VARCHAR is efficient for storing names of varying lengths. |
| LastName | Text (VARCHAR) - Variable-length string to store the last name. VARCHAR is efficient for storing names of varying lengths. |
| DateOfBirth | Date - Specifically designed to store dates. Allows for date-related calculations and comparisons. |
| IsActive | Boolean - Represents whether the student is currently active. Boolean data type is ideal for storing true/false values. |