University of Jeddah

College of Computer Science & Engineering IST Dept.

Universitu or Jeddai

Academic Year $2021/2022$

CCDS$-222$ Database II

Lab # $1$

Review of Basic SQL command

Statement purpose

To review the basic of SQL statements $($create and load data$)$

Activity Outcomes

Students will be able to use SQL statement to create tables, insert, delete, update, and select statements.

Instructor Note

Implement all the questions below and submit, for each question, the code and its execution result $($as a readable screenshot$)$ displayed by Oracle. The contents of the screenshot MUST be in a readable font size.

Answer the following questions.

Create the following tables from the COMPANY database specified in Figures $5\mathrm{.}7$: EMPLOYEE, DEPARTMENT, PROJECT, WORKS$\_$ON$,$ DEPT$\_$LOCATIONS, DEPENDENT using SQLPLUS or MySQL workbench. Write your CREATE TABLE statements to create the tables. You should capture the execution in a spool file that will be turned in$.$ Specify appropriate key and referential integrity constraints. Choose appropriate data types for each attribute. $($Important Note: Because there are circular references in the referential integrity constraints, you may have to add some referential integrity constraints later, after the tables are first created without these constraints$).$