Mohammed Yassine Labib Dr. Assem Nasser Database LAB

LAB Assignement 3

B-

1)

2)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

I notice that the constraint created at the level of GPA data type prevented the value 4.3 from

being added

EXTRA WORK DURING THE LAB:

C)

1)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

2)

I notice that the values where added to the table Student in the new column added.

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

D-

1) I already created the data type thats why the DB announce its existence

2) 3) and 4)

I notice that the new data type created round the GPA value to the one given (3,2)

E-

1) And 2)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

Here I used the statement UPDATE to put 2 in the p_salecode for p_code 23109-HB,

then I tried to see if it will change the p_salecode for the whole column without

specifying using WHERE.

3)

a) b) and c)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

4)

5)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

F-

1)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

G-

1) A)

b)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

c)

d)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

2)

a)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

b)

c)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

3)

a)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

b)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

4)

5)

Mohammed Yassine Labib Dr. Assem Nasser Database LAB

a)

b)