search

max-elixir / MovieManager

Movie Manager is a web and/or android-based application that assists movie theater staff in maintaining and building a movie schedule. Group project for a Database Systems class.
0 stars 0 forks source link

Load Data to Your Database #2

Closed sftwre closed 5 years ago

sftwre commented 5 years ago

Use Oracle SQL*LOADER to populate tables with your application data. Provide enough data so that complex queries will not always result in empty answers. For tables that are likely to be involved in multi-table SQL queries, insert tuples that will actually join.

Jason-Kha commented 5 years ago

Mostly working, just need to extend the limit for some char values. ad_schedule does not seem to work, though.

Record 1: Rejected - Error on table AD_SCHEDULE.
ORA-02291: integrity constraint (ZKI628.SYS_C0019190) violated - parent key not found

Record 2: Rejected - Error on table AD_SCHEDULE.
ORA-02291: integrity constraint (ZKI628.SYS_C0019190) violated - parent key not found

Record 3: Rejected - Error on table AD_SCHEDULE.
ORA-02291: integrity constraint (ZKI628.SYS_C0019190) violated - parent key not found
Jason-Kha commented 5 years ago

Fixed. Primary key was suppose to be screenId, and ad_schedule.txt did not have the primary keys matched with the screenId in movie_schedule.txt.