Error Handling and Integrity Constraints

The provided assignment content is a series of SQL commands that attempt to insert data into two tables, Project_Hardware and Project_Software, which have foreign key relationships with another table, Project. The inserts fail due to the lack of matching primary keys in the Project table. The error messages indicate that the integrity constraint (ABM0721.PSW_FK2) is violated because the parent key was not found. This suggests that the software IDs being inserted do not match any existing project IDs.

Error starting at line : 1 in command -
create table Project_Type
(
ptype_id integer primary key,
ptype_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 11 in command -
insert into project_type(ptype_id, ptype_name) values (1, 'Web')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 13 in command -
insert into project_type(ptype_id, ptype_name) values (2, 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 15 in command -
insert into project_type(ptype_id, ptype_name) values (3, 'App')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 17 in command -
insert into project_type(ptype_id, ptype_name) values (4, 'Testing')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 19 in command -

create table project
(
Project_id varchar(10) primary key,
Project_Name varchar(100),
Project_Type_id integer,
Start_Date date,
End_Date date,
expect_finish_date date,
constraint p_fk foreign key(Project_Type_id) references Project_Type(ptype_id)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 39 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1049', 'Health System', 1, '2016-06- 01', '2016-09- 01',
'39;2016-09- 02')
Error report -
SQL Error: ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as literals in
the format string (with the exception of leading whitespace). If the
"FX" modifier has been toggled on, the literal must match exactly,
with no extra whitespace.
*Action: Correct the format string to match the literal.
Error starting at line : 43 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1050&#39', 'insurance System', 2, '39;2016-01- 01', '2016-03-
03', '2016-03- 06')
Error report -
SQL Error: ORA-01847: day of month must be between 1 and last day of month
01847. 00000 - "day of month must be between 1 and last day of month"
*Cause:
*Action:
Error starting at line : 49 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1051', 'university System', 3, '2016-05- 01', '2016-06- 01',
'2016-06- 05')
Error report -
SQL Error: ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as literals in
the format string (with the exception of leading whitespace). If the
"FX" modifier has been toggled on, the literal must match exactly,
with no extra whitespace.
*Action: Correct the format string to match the literal.

Error starting at line : 53 in command -
create table Job_type
(
type_id varchar(5) primary key,
type_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 63 in command -
insert into job_type(type_id, type_name) values ('JT1', 'Imaging')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 65 in command -
insert into job_type(type_id, type_name) values ('JT2', 'Web Developer')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 67 in command -
insert into job_type(type_id, type_name) values ('JT3', 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 69 in command -
insert into job_type(type_id, type_name) values ('JT4', 'Training')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 71 in command -

create table Staff
(
Staff_ID varchar(10) primary key,
Name varchar(50),
Job_Type_id varchar(5),
Job_Grade integer,
constraint s_fk foreign key(job_type_id) references Job_type(type_id)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 87 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('1014E', 'John Baker',
'JT1', 3)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 89 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('230R1', 'Marian Dowd',
'JT2', 1)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 91 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('0P625', 'Jennifer Tuff',
'JT3', 2)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 93 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('4T371', 'Paul Downing',
'JT4', 3
)
Error report -

SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 97 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('1044E', '39;Johnny
Woods', 'JT1',
3)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 101 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('233R1', 'Mia S.', 'JT2', 1)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 105 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('0Q625', '39;Jenny Duff',
'JT3', 2)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 107 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('6T371', '39;Pal Sterling',
'JT4', 3 )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 109 in command -
create table Staff_skill

(
Staff_ID varchar(10),
skill_name varchar(50),
primary key(staff_id, skill_name),
constraint ss_fk foreign key(Staff_ID) references staff(Staff_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 123 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('1014E', 'DATA IMAGING' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 125 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('230R1', 'WEB
DEVELOPMENT' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 127 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('0P625', 'OFFLINE
DEVELOPMENT' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 129 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('4T371', 'C++' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.

*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 131 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('1044E', 'BLACK BOX' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 133 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('233R1', 'HTML' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 135 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('0Q625', 'SQL' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 137 in command -
INSERT INTO Staff_skill(STAFF_ID, SKILL_NAME) VALUES('6T371', 'NOSQL' )
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024808) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 139 in command -
create table Project_Staff
(
Staff_ID varchar(10),
Project_id varchar(10),
primary key(staff_id, project_id),
constraint ps_fk1 foreign key(Staff_ID) references staff(Staff_ID),
constraint ps_fk2 foreign key(project_ID) references project(project_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object

00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 157 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('1014E','B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 159 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('230R1', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 161 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('0P625', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 163 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('4T371', 'B1049' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 165 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('1044E', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 167 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('233R1', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found

02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 169 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('0Q625', 'B1051' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 171 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('6T371', 'B1050' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 173 in command -
INSERT INTO PROJECT_STAFF(STAFF_ID, PROJECT_ID) VALUES('6T371', 'B1051' )
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PS_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 175 in command -
create table Software
(
Software_ID integer primary key,
Software_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 185 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1001,
'Encryption Protocol
Suite')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.

*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 189 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES
(1002,'Autodesk Maya')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 191 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1003,
'Rational rose')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 193 in command -
INSERT INTO SOFTWARE(SOFTWARE_ID, SOFTWARE_NAME) VALUES (1004, 'Sql
Server')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024813) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 195 in command -
create table Hardware
(
Hardware_ID integer primary key,
Hardware_name varchar(50)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 205 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (101, 'Games
Monitor')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"

*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 209 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (102, 'Web
Cam')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 211 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (103,
'Scanner')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 213 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (104,
'External Drive')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 215 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (105, 'Hard
Disk 5GB')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 217 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (106, 'Flat
Screen Monitor')
Error report -

SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 219 in command -
INSERT INTO HARDWARE(HARDWARE_ID, HARDWARE_NAME) VALUES (107,
'Imagines tool')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024814) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
Error starting at line : 221 in command -
create table Project_hware
(
Project_id varchar(10),
Hardware_ID integer,
primary key(project_id, hardware_id),
constraint ph_fk1 foreign key(hardware_ID) references hardware(hardware_ID),
constraint ph_fk2 foreign key(project_ID) references project(project_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 237 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 101)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 239 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 102)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 241 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 103)

Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 243 in command -
insert into Project_hware(project_id, hardware_id) values('B1049', 104)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 245 in command -
insert into Project_hware(project_id, hardware_id) values('B1050', 101)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 247 in command -
insert into Project_hware(project_id, hardware_id) values('B1050', 102)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 249 in command -
insert into Project_hware(project_id, hardware_id) values('B1051', 101)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 251 in command -
insert into Project_hware(project_id, hardware_id) values('B1051', 104)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 253 in command -
insert into Project_hware(project_id, hardware_id) values('B1051', 102)

Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 255 in command -
insert into Project_hware(project_id, hardware_id) values('B1051', 103)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 257 in command -
insert into Project_hware(project_id, hardware_id) values('B1050', 107)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 259 in command -
insert into Project_hware(project_id, hardware_id) values('B1051', 106)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PH_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 261 in command -
create table Project_sware
(
Project_id varchar(10),
Software_ID integer,
primary key(project_id, software_id),
constraint psw_fk1 foreign key(software_ID) references software(software_ID),
constraint psw_fk2 foreign key(project_ID) references project(project_ID)
)
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 279 in command -
insert into Project_sware(project_id, software_id) values('B1049', 1001)
Error report -

SQL Error: ORA-02291: integrity constraint (ABM0721.PSW_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 281 in command -
insert into Project_sware(project_id, software_id) values('B1049', 1002)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PSW_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 283 in command -
insert into Project_sware(project_id, software_id) values('B1049', 1003)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PSW_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 285 in command -
insert into Project_sware(project_id, software_id) values('B1051', 1001)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PSW_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 287 in command -
insert into Project_sware(project_id, software_id) values('B1051', 1002)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PSW_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 289 in command -
insert into Project_sware(project_id, software_id) values('B1050', 1001)
Error report -
SQL Error: ORA-02291: integrity constraint (ABM0721.PSW_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.
Error starting at line : 291 in command -
insert into Project_sware(project_id, software_id) values('B1050', 1004)
Error report -

SQL Error: ORA-02291: integrity constraint (ABM0721.PSW_FK2) violated - parent key not
found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.