Question 1:

Consider the below tables with the related fields and type with length for each one

BranchYOURNAME(b_no _{Number PK} , b_name _{varchar2 60 UNIQUE} ,b_street _{varchar2 60}, b_city _{varchar2 60})

StaffYOURNAME(s_staffNo _{Number PK},s_fName _{varchar2 50},s_lName _{varchar2 50}, s_sex _{varchar2 1},s_salary _number, b_no _{Number FK})

ClientYOURNAME(c_clientNo _{Number PK}, c_fName _{varchar2 50}, c_lName _{varchar2 50}, c_telNo _{varchar2 10})

RegistrationYOURNAME(c_clientNo _{Number FK}, b_No _{Number FK}, s_staffNo _{Number FK}, dateJoined _Date) c_clientNo, b_No, s_staffNo are primary keys for the table

Create the related table with their related constraints (PK,FK and Unique) by replacing the sentence YOURNAME by your name ex: BranchToni

1-Upload the scripts of the tables creation and constraints

2-send the result by uploading a picture from your pc of the below query once the tables are created

select * from all_all_tables where table_name in (upper('BranchYOURNAME'),upper('StaffYOURNAME'),upper('ClientYOURNAME'),upper('RegistrationYOURNAME'))

Question 2

Your supervisor has asked you to modify the s_fName column in the StaffYOURNAME table.

He wants the column to be configured to accept a default value of 250. The table

contains data that you need to keep.

1-Upload the script of the modification

2-send me the result by uploading a picture from your pc of the below query after applying the script

select * from dba_tab_cols c where c.TABLE_NAME = upper('StaffYOURNAME');

Question 3

Create an index with name idx_YOURNAME_city related to the field b_city under table BranchYOURNAME

1-Upload your script here

2-send me the result of the below query by uploading a picture from your PC

select * from dba_indexes i where i.table_name = upper('BranchYOURNAME')

Question 4

Question text

Create a view with Name v_YOURNAME_branch that retrieve the data from the table branchYOURNAME for b_city equal to Beirut

1-upload the creation script

2- send me the result of the below query by uploading and image

select * from dba_views v where v.view_name = upper('v_YOURNAME_branch');