Appendix 1 – CET341 Assignment 2 Structure Template
Task One:
Include the UML class diagram here
Task Two:
Include screenshots to demonstrate that ALL of your SQL code works.
Task Three:
Include screenshots to demonstrate that ALL of your MongoDB code works.
Task Four
Provide discussion of no more than 500 words. Include appropriate citations.
Tasks Five and Six
Complete the following tables:
| Query a: A join of three or more tables – you should consider various types of join in this query (e.g. inner join, left/right/full outer joins, etc.) and the query must include a restriction on the rows selected Provide a brief description of your query here | |
| SQL code | MongoDB code |
| Insert the SQL query code here | Insert the MongoDB query code here |
| Screenshots | |
| Insert a screenshot of the output from your SQL query here | |
| Insert a screenshot of the output from your MongoDB query here | |
| Query b: A query which uses one (or more) of the UNION, DIFFERENCE or INTERSECT operators. Provide a brief description of your query here | |
| SQL code | MongoDB code |
| Insert the SQL query code here | Insert the MongoDB query code here |
| Screenshots | |
| Insert a screenshot of the output from your SQL query here | |
| Insert a screenshot of the output from your MongoDB query here | |
| Query c: A query which requires use of either a nested table or subtypes Provide a brief description of your query here | |
| SQL code | MongoDB code |
| Insert the SQL query code here | Insert the MongoDB query code here |
| Screenshots | |
| Insert a screenshot of the output from your SQL query here | |
| Insert a screenshot of the output from your MongoDB query here | |
| Query d: A query using temporal features (e.g., timestamps, intervals, etc.) of Oracle SQL Provide a brief description of your query here | |
| SQL code | MongoDB code |
| Insert the SQL query code here | Insert the MongoDB query code here |
| Screenshots | |
| Insert a screenshot of the output from your SQL query here | |
| Insert a screenshot of the output from your MongoDB query here | |
| Query e: A query using OLAP (e.g., ROLLUP, CUBE, PARTITION) features of Oracle SQL Provide a brief description of your query here | |
| SQL code | MongoDB code |
| Insert the SQL query code here | Insert the MongoDB query code here |
| Screenshots | |
| Insert a screenshot of the output from your SQL query here | |
| Insert a screenshot of the output from your MongoDB query here | |
References
Provide your reference list in Harvard format.
