13 Pages
...
Task Learning Outcomes Covered in this Assignment: This assignment contributes to obtaining the following LOs: L01: discuss and critically apply the basic principles to data visualisation techniq ...
7BUIS009W
Programming
Database
University of Westminster
Fall
DATA2001 Assessment 2Report Page 1 SOUTHERN CROSS UNIVERSITY ASSIGNMENT COVER SHEET For use with online submission of assignments Please complete all of the following details and then make this s ...
Task: Instructions The SQL in answer to the questions are to be submitted via Moodle by the deadline given in the unit outline and TurnItIn assessment. Use this template document for your submission ...
COMPSCI5076
Programming
Database
University of Glasgow
spring
Task NOTES This assignment requires you to use SQLite to complete the tasks listed below. For guidance on how to install SQLite .read a5.txt [to create the tables you will use to answer this assignment’s questions] At the SQLite Command Line type .headers on At the SQLite Command Line type .mode column Write and run SQL statements to complete the following tasks Show sums of line totals for each invoice. Locate the record in the vendor table that does not have a value for the attribute V_STATE Find the customers whose balance is greater than 200 but less than 300. Using natural join and having, list the customers whose invoice total is greater than 200 Show the names of the customers for whom we have invoices. Using natural join and having, list the customers whose invoice total is greater than the average Show the names of the customers for whom we DO NOT have invoices. Using natural join and having, list the customers whose invoice total is the maximum. List the first name and last name of the customers and how many times a customer has generated an invoice. List all purchases by customer 10018. List the names of the vendors who provided products. Using inner join, list the details of the products which sold more than 10 units. You are required to submit: 1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file. If you type .echo on at the SQLite3 Command Line, SQLite will output your SQL statement with the results of the query making it easy to copy and paste both. 2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file. Rationale This assessment aligns with the following subject outcomes: be able to critically analyse and modify an existing database design to meet new business requirements; Marking criteria Each task is worth 1.25 marks. The marking criteria for this assignment is: Criteria HD DI CR PS be able to critically analyse and modify an existing database design to meet new business requirements; SQL syntax returns all attributes that meet the business requirement from the tables that hold the data and applies the correct restrictions to retrieve the required information. SQL syntax returns all attributes that meet the business requirement from the tables that hold the data with minor omissions and applies appropriate restrictions to retrieve the required information. SQL syntax returns key attributes that meet the business requirement from the tables that hold the data and applies relevant restrictions to retrieve the required information. SQL syntax returns key attributes that meet the business requirement from the tables that hold the data but the restrictions applied to retrieve the required information contain minor errors. Requirements Either submit your assignment as a PDF or a Word document. Don't use any other file formats. Please include your student ID, name and subject code in your submission.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
MyAssignmenthelp.com has gained the stature of being the most successful marketing assignment help providers in the USA. Other than marketing assignment, we also provide an array of expert quality engineering assignment help. Like our mechanical and electrical assignment help assist thousands of students every year. Wide ranges of affordable services contribute in making us one of the most popular websites. Some of our on demand services are English assignment help and taxation assignment help.
We aren't endorsed by this University
Task Learning Outcomes Covered in this Assignment: This assignment contributes to obtaining the following LOs: L01: discuss and critically apply the basic principles to data visualisation techniques; L02: select and justify appropriate tools for data visualisation and Dashboarding; L03: evalu ...
View Answer
We aren't endorsed by this University
DATA2001 Assessment 2Report Page 1 SOUTHERN CROSS UNIVERSITY ASSIGNMENT COVER SHEET For use with online submission of assignments Please complete all of the following details and then make this sheet the first page of each file of your assignment –do not send itas aseparate document. Your a ...
View Answer
We aren't endorsed by this University
Task: Instructions The SQL in answer to the questions are to be submitted via Moodle by the deadline given in the unit outline and TurnItIn assessment. Use this template document for your submission. Copy and paste your code in the boxes provided, save the document as MP_UP123456.docx (your studen ...
View AnswerIf you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.
On APP - grab it while it lasts!
*Offer eligible for first 3 orders ordered through app!
