In a CREATE TABLE command address each of the following: (a) Explain what the NOT NULL specification for a column means and when you might apply this specification. (b) Explain what the UNIQUE specification for a column means and when you might want to apply this specification. (c) Explain what the DEFAULT specification means and when you might want to apply this specification.

Task 1: The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENACE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team.

Need some help understanding this Python program that creates a new database named DSUCollege.db and calls 4 functions. The function named create_table will create a table in the DSUCollege.db database called students that has five fields: student_id, first_name, last_name, major, and gpa.  The first_name, last_name, and major columns should be TEXT data types, the student_id column should be an INTEGER datatype and gpa should be a REAL datatype (link to SQLite Data typesLinks to an external site.). Before creating the table, add code to drop the table.  After the table has been created, display a message that the table has been created successfully. The function named populate_table populates the students table with the following values: student_id first_name last_name major gpa 1111 Dave Grohl Music 4.0 2222 Belinda Carlisle Accounting 3.5 3333 Joe Elliot Computer Science 2.8 4444 Angus Young Accounting 2.1 5555 Susanna Hoffs Music 3.1 6666 Debbie Harry Computer…