CSDA $5240$ Database Programming

Week $1$ Assignment

Working on the Oracle APEX Sample Database Application, add a new customer $($yourself or make

up one$)$ and, optionally, place an order on a few products. Provide screenshots for form and report of

the application. Provide screenshots of database table contents that are affected.

Working on the Oracle APEX Sample Database Application, use examples from the supporting

database tables to explain database characteristics.

Working on the Oracle APEX Sample Database Application, use the $4$ database tables, shown below,

to answer following questions.

a$.$ For each table, identify primary key and foreign key$($s$).$ If a table does not have a foreign key, write

None.

b$.$ Do data of the tables exhibit entity integrity and referential integrity? Explain your answer.