Landing : Athabascau University

COMP 602 - Week 5: Reflection

The tasks for this week took some time to complete mainly due to the amount of work and the schedule conflict I have at work. This is the reason for the late reflection.

The main task was to submit scripts in both DDL and DML for the proposal DB system scenario. Creating tables need to account for cardinality, keeping the creation of tables in a correct order, creating parent table before child table, etc. Inserting records get a bit tricky as you have to reference back and forth between parent row PK and use it over at the child table FK, as well as keeping count of records that satisfy a number of scenarios in mind. I.e. provide enough diversity in apartment sizes and features. This part took the most time for me. Next, generating queries that covers the different business scenarios. I had 12 queries each covering the required style, using function, subquery, etc.

All the scripts can be found at:
https://landing.athabascau.ca/pg/forum/topic/125411/apartment-rental-db-diagram-and-scripts/
Dickson