A. Create the following table: DEPARTMENT Column Name Sie Constraints Data Type DeptlD Varchar 4 Primary key DeptName Not mull 40 Varchar StudentAllotted Number 4 Not mull B. Display the structure of...

Extracted text: A. Create the following table: DEPARTMENT Column Name Sie Constraints Data Type DeptlD Varchar 4 Primary key DeptName Not mull 40 Varchar StudentAllotted Number 4 Not mull B. Display the structure of the table Department C. Insert data into table D. Drop table E. Create the following table: STUDENT Column Name Student No FName LName Data Type Number Varchar Varchar Sie Constraints Primary Key 25 Not null 25 Not null PhoneNo Number Number 10 Null Not null Not null YearOfaccepted 4 DeptCode Semester Varchar2 Varchar2 Date 4 Not null DOB Not null F. Display the structure of the table Student. G. Insert data into the table. DEPTID DEPTNAME STUDENTALLOTTED Computer Science and Engineering information System CSE 120 IS 240 Information Technology Electrical Engineering IT 100 EE 60100 Table: STUDENT Year Dept Rell Na Name PhoneNo Semester Birthate Code ANKIT DAS K0675221 2017 SEMS 10-02-1999 1001 CSE MOINAK 7988822201 2015 CSE SEMS 01.05.1998 GIOSH PARIMAL S099922211 CSE SEMS 17.03.2001 KLMAR SANCHITA 2001 9999 100I 2017 ECE SEMS 20.10.2000 SINGH ANANYA 2002 7667880010 2017 ECE SEMS 06.11.2001 BISWAS ASHISH 2101 6544332121 2017 ECE SEMS 17.09.2001 KLMAR NAITIK 29 2018 CSE SEM3 OK. 10.2003 PRASAD SATNAM 93322125 2018 IT SEMB 21.09200 JYOI 3002 SALRAV ROY 2017 EE SEMS 23.08. 2000 MOHAMMAD 3005 79100006 2017 EE SEMS 20.05.2001 AZIB NIKHIL 2004 2016 ECE SEMS 21.06. 1999 SINGH SAMPRIKTA 8877565643 2018 CSE SEMI 13.12.2000 BISWAS 星|