Lab3.docx - Directions Perform the following activity by Applying Database constraints In each number add the PL\/SQL used in order Answer the questions

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

This preview shows page 1 - 5 out of 16 pages.

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_1with the used of the followingstructure as listed below.ColumnnameDatatypeConstraintNullSubjectcodeVarchar(20)NotnullSubjecttitleVarchar(40)NotnullUnitsNUMBER(6)PrerequisiteVarchar(20)Add PL/SQL used here:2.Insert the following values into Table SUBJECT_12.1SubjectcodeSubjecttitleUnitsPrerequisiteMath01Mathematics 13null2.2Pyed02Physical education with rhythmic activities2Pyed012.3Philippine history3Null2.4NullNull4Chem.Are Values from number 2.1 up to 2.4 successfully inserted toSUBJECTS table? Why and why not? . Add PL/SQL used here: 2.1 Successful - it met the requirement of the table created.
Image of page 1
3. Create a table named as SUBJECT_2 with the used of the followingstructure 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:
Image of page 2
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.
Image of page 3
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:
Image of page 4
Image of page 5

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture