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.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Thanks for sharing. I read many of your blog posts, cool, your blog is very good. https://accounts.binance.com/ro/register-person?ref=W0BCQMF1