The task should be solved by sqldeveloper.

Create two tables with the following schemas:

C_Group (GroupNum,ClassRoom,C_Code,C_Name, Teacher)

Time_Table(StudentID,GroupNum,FirstName, LastName)

Since you will be using your own course schedule to populate the tables, use the following domains:

ClassRoom should be string of up to seven characters (e.g, A/3/054)

StudentID should be a nine-digit numbers (e.g. 435800800)

GroupNum should be up to five-digit number (e.g. 1048)

C_Code should be a string of up to six characters (e.g. 223ISM)

The various names should be strings of length up to thirty (e.g. Mohammad Almohammad)

In order to avoid conflicts, remember to start your script file with DROP TABLE commands for both tables (since Time_Table will ultimately contain a foreign key linked to C_Group, drop Time_Table before you drop C_Group.) Look at the columns of each table to see that they have been created correctly.

Using a sequence of INSERT commands, put all of the courses that you and two of your friends are taking this semester into the C_Group table. Put yourself and each of your courses and your two friends and each of their courses into the Time_Tabletable. Look at the data in each table to see if they have been populated correctly.

Declare GroupNum as the primary key in C_Group, and (StudentID, GroupNum ) as the primary key in Time_Table .

Declare as a foreign key in Time_Table, linking this table to C_Group. Look at the constraints for each table to see if they have been created correctly. (Note that you must create the table C_Group and its primary key before you create the foreign key in Time_Table that links to it, and must populate C_Group with values before populating Time_Table as well.)

Display the contents of each table using SELECT * FROM Table_Name; (Clear the window before running the script so that only the output of the last run of the script is displayed).

eator Pro Wolfram Mathemati... tlab2018 sqldeveloper Shortcut SA licrosoft Arena