Lab3.docx - Directions Perform the following activity by...

Directions : Perform the following activity by Applying Database constraints.
: In each number add the PL/SQL used in order.
: Answer the questions ask in each number.
1. Create a table named as: SUBJECT_1 with the used of the following
structure as listed below.
Column
name
Data
type
Constr
aint
Null
Subjectco
de
Varchar(
20)
Not
null
Subjecttitl
e
Varchar(
40)
Not
null
Units NUMBER
(6)
Prerequisit
e
Varchar(
20)
Add PL/SQL used here:
2. Insert the following values into Table SUBJECT_1
2.
1
Subjectc
ode Subjecttitle
Uni
ts
Prerequ
isite
Math01 Mathematics 1 3 null
2.
2 Pyed02
Physical education with
rhythmic activities 2 Pyed01
2.
3 Philippine history 3 Null
2.
4 Null Null 4 Chem.
Are Values from number 2.1 up to 2.4 successfully inserted to
SUBJECTS table? Why and why not?
.
Add PL/SQL used here:
2.1 Successful - it met the requirement of the table created.

3. Create a table named as SUBJECT_2 with the used of the following
structure as listed below.
Column
name
Data
type
Constr
aint
Null
Subjectco
de
Varchar(
20)
Primary
key
Not
null
Subjecttitl
e
Varchar(
40)
Unique
Units NUMBER
(6)
Prerequisit
e
Varchar(
20)
Add PL/SQL used here:

4. Add the following values in SUBJECT_2 .
4.
1
Subjectc
ode
Subjecttitle Uni
ts
Prerequisite
CX102 Computer
programming 1
3 CX101
4.
2
CX102 Object oriented
programming
3 CX102
4.
3
Data structures and
algorithm
3 Null
4.
4
FREELEC
T1
Data mining and data
warehouse
3 None
4.
5
CX102 Computer
programming 1
3 COMPO1
4.
6
NULL On the job training 6 Captone1 and
capstone2
Are values from 4.1 and 4.2 successfully inserted? Why and why
not?
Add PL/SQL used here:
4.1 Successful – values have met the requirement of the table.
4.2 Not successful – UNIQUE CONSTRAINT violated.
SUBJECTCODE value CX102 cannot be repeated.

4.3
4.4
4.5
4.6
5 Populate the table SUBJECT_2 , add an additional unique constraint in
column: prerequisite
Add PL/SQL used here: