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
The Landing is a social site for Athabasca University staff, students and invited guests. It is a space where they can share, communicate and connect with anyone or everyone.
Unless you are logged in, you will only be able to see the fraction of posts on the site that have been made public. Right now you are not logged in.
If you have an Athabasca University login ID, use your standard username and password to access this site.
We welcome comments on public posts from members of the public. Please note, however, that all comments made on public posts must be moderated by their owners before they become visible on the site. The owner of the post (and no one else) has to do that.
If you want the full range of features and you have a login ID, log in using the links at the top of the page or at https://landing.athabascau.ca/login (logins are secure and encrypted)
Posts made here are the responsibility of their owners and may not reflect the views of Athabasca University.