HIT326 - Database-Driven Web Applications - Computer Science Assignment Help

Assignment Task

Exercise 1
 

1. What happens to your table if you run the ‘load’ script over and over again (i.e. without running ‘create’)? You’ll have to ‘test’ it along the way to see what happens.
 

2. Re-create and load the original data again.
 

3. Comment out the SELECT statement in the ‘test script’. Now write (or copy and modify) the following SELECT statements, and observe the ‘tests’. Note what happens each time.
 

• SELECT name FROM users;
• SELECT user_id, name FROM users; SELECT name, user_id FROM users;
• SELECT name FROM users WHERE user_id='1';
• SELECT name FROM users WHERE user_id='2' AND name='Alice';
• SELECT name FROM users WHERE user_id='1' AND name='Alice';
• SELECT name FROM users WHERE user_id='1' OR name='Alice';

4. Before you proceed to the next exercise make sure you retain a copy of the previous load files, especially the ‘test’ script. You may find these useful for future workshops and your project. You are about to do another download and extract. If you don’t move the current files they will be overwritten with new load files.

Exercise 2
 

1. Download, extract, create, load and test ‘example_2.zip’ (Week 1) in the same way you did in Part 2 in workshop 1.
 

2. Examine the CREATE TABLE statement in the ‘create’ script. Note that it now has an extra field (or column) as follows:

• created_at DATE DEFAULT(datetime('now','localtime'))
• Also note the modification made to the ‘name’ field. It now has UNIQUE included like this:
• name TEXT UNIQUE NOT NULL

This (HIT326) Computer Science Assignment has been solved by our Computer Science experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.