CET341 Assignment 2 Structure Template

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.

63 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *