December 15, 2016
SQL | 代写 | INFO 6250: Web APPLICATION FINAL PROJECT BREAKDOWN

INFO 6250: Web APPLICATION FINAL PROJECT BREAKDOWN

1. Submission
A. Where to submit: Bitbucket and Blackboard
i. Blackboard: Zip Project, Bitbucket: GIT COMMIT and GIT PUSH
B. What to submit
i. Entire Eclipse Project (Angular and REST)
ii. SQL File (Export SQL from MySQLWorkbench)
1. Table Structure
2. Default Data.
iii. PowerPoint Presentation. (No submission needed. Bring for demo)
2. Demo (Duration: 25 MINS)
A. Setup: 2 mins.
i. Download from Blackboard.
ii. Import Project into Eclipse
iii. Create Database via Scripts.
iv. Insert Default Data (Admin or Any Data required for Setup) – via Scripts.

May 19, 2016
SQL | SQLite | INTRODUCTION

INTRODUCTION
The purpose of this assignment is to assess the level of knowledge and ability to use SQL to query a relational database.
It is a mandatory requirement to use SQLite to answer all the questions in this assignment, no other alternative database software is accepted. The questions in this assignment are based on the database of a trading company called Chinook (Figure 1) which has a database system managing the online purchase of album tracks by customers.
Figure 1 : ERD for Chinook
Students need to download a copy of the database script file (i.e. chinook.sql) from CANVAS and create their database instances (e.g. chinook.db) before they can start working on the questions.
This assignment is marked out of 100 in total, which is worth 15% towards the internal coursework. It is an individual assessment and so students are absolutely forbidden to work with or copy directly from others in answering the questions. The staff members of the course reserve the right to call upon any student to demonstrate their knowledge of this assignment as part of the marking process if that is required.