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. Oracle SQL Developer HELP I'm attempting to input some values into twoHowever, this error keeps appearing:

tables. However, this error keeps appearing: Here are the logical model and

Here are the logical model and relational model for context:

relational model for context: NOTE: ALL of the tables coloured blue have

been populated with the correct data, my task is to now populate

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!