Part 2: Alering the Tables Overview - Alter the tables to set the constraints - Specity a delault value for a column - Set a table to a read-only status Assumptions: The primary and foreign key constraints are based on the ERD shown in the previous exercise and the unique constraints are based on the following: The following fieids should have unique values: - Course Name in AD_COURSES - Department Name in AD_DEPARTMENTS - Student Email in AD_STUDENTS - Faculty Email in AD.FACULTY - Session Name in AD_ACADEMIC_SESSIONS Tasks 1. Alter the tables in the Academic Database to define the primary key, foreign key and unique constraints. 2. Alter the table AD_FACULTY_LOGIN_DETALS and specify a defaill value for the column LOGN_DATE_TIME of SYSDATE. 3. Set the AD_PARENT INFORMATION table to a read-only status. NOTE: You can execute the INSERT / ALTER TABLE statements in Oracle Applicatian Express in one of the two ways: Method 1: a. Open Oraclo Application Express and paste the commands into the SOL Commands screen one at a time and run. Method 2 : b. Open Oracle Application Express and use the same script upload method as you did with the DDL commands above. Part 3: Creating Composite Primary, Foreign and Unique Keys Overview - Composite Primary Key - Composite Foreign Key - Composite Unique Key *" Note - these tables are not a part of the Academic Database Tasks 1. Create the DEPT table with the following structure: The primary key for this table needs to be defined as a composite comprising of the dept id and loc_id