Question: Oracle SQL Developer HELP I'm attempting to input some values into two tables. However, this error keeps appearing: Here are the logical model and relational
Oracle SQL Developer HELP
I'm attempting to input some values into two tables.
However, this error keeps appearing:

Here are the logical model and relational model for context:


NOTE: ALL of the tables coloured blue have been populated with the correct data, my task is to now populate the yellow coloured tables.
INSERT INTO team. VALUES (1, "Vultures', TO DATE ('01/FEB/2019', 'DD/MON/YYYY'), 3, 'RSPCA', 1); 'HH24:MI'), INSERT INTO entry VALUES (1, TO DATE ('13:00', HH24:MI'), TO DATE ('13:30', 'RSPCA', 1, TO_DATE ('01/FEB/2019', DD/MON/YYYY'), '10K', 1); Error starting at line : 16 in command INSERT INTO team VALUES (1, 'Vultures',TO_DATE ('01/FEB/2019', 'DD/MON/YYYY'), 3, 'RSPCA', 1) Error report ORA-02291: integrity constraint (YABD0001.TEAM_ENTRY_FK) violated parent key not found Error starting at line : 19 in cormand INSERT INTO entry VALUES (1, TO_DATE('13:00', 'HH24:MI'), TO_DATE('13:30', 'HH24: MI'), 'RSPCA', I, TO_DATE ('01/FEB/2019', 'DD/MON/YYYY'), '10K', 1) Error report ORA-02291: integrity constraint (YABD0001.ENTRY_TEAM_FK) violated parent key not found TEAM P. TeamlD U * TeamName UF* CarnDate * TeamNoMembers F CharName F * EntryID CARNIVAL has P* CarnDate TU * CarnName * CarnDirector * CarnLocation made up of 1 1 has members 1 EVENT 1 PF * CarnDate PF - EventTypeCode 1 has 1 lead by 1 1 # ENTRY P EntryID EntryStart Time * EntryFinishTime CharName CompNo CarnDate IF * Event TypeCode TeamID I 1 supported by CHARITY P* CharName CharContact * CharPhone supported by HO classifies EVENTTYPE P - Event TypeCode * Event Type Desc I registers for EMERCONTACT P - EmerConPhone * EmerConFName * EmerConLName contact for HI- COMPETITOR P* CompNo CompFName ComplName * CompGender * CompDOB CompEmail * CompUniOpt * CompPhone * CompECRelation F EmerConPhone From this logical model the following relational model has been created: TEAM P TeamlD NUMBER (3) U TeamName VARCHAR2 (30) UF CarnDate DATE TeamNoMembers NUMBER (2) F CharName VARCHAR2 (30) F. EntryID NUMBER (5) TEAM_PK (TeamID) TEAM_UN (CarnDate, TeamName) TEAM CARNIVAL_FK (CarnDate) 3 TEAM_CHARITY_FK (CharName) TEAM_ENTRY_FK (EntryID) TEAM_IDX (EntryID) CARNIVAL P" CarnDate DATE U * CarnName VARCHAR2 (50) * CarnDirector VARCHAR2 (50) CarnLocation VARCHAR2 (50) ) CARNIVAL_PK (CarnDate) CARNIVAL_UN (CarnName) 1 DATE ENTRY PEntryID NUMBER (5) EntryStart Time EntryFinishTime DATE CharName VARCHAR2 (30) F . CompNo NUMBER (4) F. CarnDate DATE F. Event TypeCode CHAR (3) TeamlD NUMBER (3) ENTRY_PK (EntryID) ENTRY_CHARITY_FK (CharName) ENTRY_COMPETITOR_FK (CompNo) ENTRY_EVENT_FK (CarnDate, EventTypeCode) ENTRY_TEAM_FK (TeamID) EVENT PF CarnDate DATE PF Event TypeCode CHAR (3) EVENT_PK (CarnDate, Event TypeCode) EVENT_CARNIVAL_FK (CarnDate) EVENT_EVENTTYPE_FK (Event TypeCode) IF CHARITY P* CharName VARCHAR2 (30) * CharContact VARCHAR2 (50) + CharPhone CHAR (10) CHARITY_PK (CharName) dididi EVENTTYPE P* Event TypeCode CHAR (3) Event Type Desc VARCHAR2 (50) EVENTTYPE_PK (Event TypeCode) EMERCONTACT P* EmerConPhone CHAR (10) * EmerConFName VARCHAR2 (30) * EmerConLName VARCHAR2 (30) EMERCONTACT_PK (EmerConPhone) COMPETITOR * CompNo NUMBER (4) CompFName VARCHAR2 (30) ComplName VARCHAR2 (30) * CompGender CHAR (1) * CompDOB DATE * CompEmail VARCHAR2 (50) * CompUniOpt CHAR (1) * CompPhone CHAR (10) - CompECRelation CHAR (1) F * EmerConPhone CHAR (10) > COMPETITOR_PK (CompNo) COMPETITOR EMERCONTACT_FK (EmerConPhone)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
