Assignment 1 Desc-Thursday

docx

School

Toronto Metropolitan University *

*We aren’t endorsed by this school

Course

500

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by MegaFlyPerson237

Report
ITM-500 Winter 2024 Dr. Zeinab Noorian Assignment 1 Due on Tuesday March 12, 2024 at 11:59pm This assignment could be done as a group or individually . The maximum size of a group is 4 (smaller groups of size 2 and 3 are accepted, but there is no exception for group sizes larger than 4). Your group members must be from the same section (Thursday Class). While it is understood that groups and individuals may share their expertise and communicate with each other, each group’s work must reflect sufficient individual group effort to merit its grade. Providing solutions to other groups is not acceptable. Such blatant collusion will result in a grade reduction and in extreme cases could result in a zero and a charge of academic misconduct. Using the Assignment 1 database, populate the database with sufficient data to test your queries . Develop and write the SQL queries necessary to satisfy the queries. The queries are in Assignment1Queries.sql ” file. Only show in the output the details required by the specifics of the query. No unnecessary or debug columns. Total mark is 100 and each question is worth 10 points. General Notes: i) Make sure to populate your database so that it returns sufficient data. All queries must generate some output (at least one row). ii) Use column aliases where appropriate to increase the readability of your queries. iii) Suppress duplicate rows where appropriate for output based on your actual data even if not specifically requested in the question. What to hand in: 1) A file that contains your answers in SQL to the questions (similar format to lab solutions). Include the questions in your file too (again, the same format as labs). You can submit .txt, .sql, .pdf or .docx files. 2) If you work on the project in a group, a text file containing names and email addresses of the group members.
How to hand in: One of the group members should email the above two files (the file with SQL queries and the file that contains the name of the group members) before the deadline to Parya Abadeh pabadeh@ryerson.ca If you work on the project in a group, you should copy (CC) your team members in the email. Important Note: You do not have to email the populated database as part of the assignment. You populate the database and fill it up with some data so that you can test your queries against the database and see the results. We have our own populated database to test your SQL answers. Late Submission Penalty: Here is the penalty for late submission: Within 24 hours: You will lose 25% of your mark. Within 48 hours: You will lose 50% of your mark. Within 72 hours: You will lose 75% of your mark. After 72 hours: You will get the mark of 0 for Assignment 1.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help