Please complete and submit your lab work here.

We have the following tables of Student, Course, and Registeration in the databas. Your job is to create all three tables, define aproperiate data type for each attribute, and speceify all constarints that might be exist in our database. Then, you have to insert all data to the tables.

The data we need to insert in the tables is as below: Note: Use SQL

STD_ID STD_NAME GENDER DOB 1111 Ahmed M 23-DEC-86 2222 ALi M . 01-JAN-01 3333 Huda F 02-JAN-10 4444 Noor F 01-JAN-11 COURSEID CNAME CREDITS DPT_ID 340CIS-3 Database 3 IS 380CIS-3 Information Systems 3 IS 410CIS-3 Operating Systems 3 CS 101 Math-3 Math 3 SC STD_ID COURSEID SEC_NO START_DATE 1111 340CIS-3 90 02-JAN-21 1111 380CIS-3 101 04-JUN-21 1111 101 Math-3 8 04-JUN-20 2222 340CIS-3 90 02-JAN-21 2222 380CIS-3 101 04-JUN-21 3333 340CIS-3 90 02-JAN-21 1111 380CIS-3 8 04-AUG-21