INF60009 Task 3 Database Analysis and Design INF60009 Task 3 - Pass and Credit Requirements Overview · We're getting into the heart of DAD this week: ERDs and SQL. To help us learn, we'll be making use of the iSQLJunior tool (a web interface for interacting with an Oracle DB). Details on how to use and how to connect are provided in the lecture and on Canvas. · For submission, it's same process as the other weeks: complete tasks, document them (usually by asking for screen grabs), and submit online. Getting Started · Download the files TO3P.DOCX and T03C.DOCX from Canvas · Paste the required screen captures from the tasks below into these files · When complete, use the File / Export menu option to generate the files TO3P.PDF and T03C.PDF . Finally submit file TO3P.PDF to Canvas -> Assignments -> Pass Task 3, and file TO3C.PDF to Canvas > Assignments > Credit Task 3. Note: When you submit the screenshots for tasks that include SQL statements, please make sure you submit the following (including SQL Textbox and Results): Enter Statements: select * from movie1982; Execute Clear select * from movie1982 MOVIENO TITLE 604 The Matrix Reloaded 211672 Minions 155 The Dark Knight 2008 101299 The Hunger Games: Catching Fire 2013 146 245 About a Boy 2002 101 242582 Nightcrawler 2014 117 544 There's Something About Mary 7446 Tropic Thunder 11665 Get Smart 744 Top Gun RELYEAR RUNTIME RATINGCODE COLOURCODE TMDB_SCORE TMDB_VOTES TMDB_ID 2003 138 2015 1998 119 2008 107 2008 1986 110 MA 91 PG 152 M M M MA C MA MA 110 PG PG C 6.5 C 6.6 C 7.7 C 7.7 C 6.3 7.7 C 6.3 C 6.2 C 5.8 C 6.3 1317 tt0234215 263 tt2293640 4843 tt0468569 890 tt1951264 89 tt0276751 583 tt2872718 223 tt0129387 273 tt0942385 228 tt0425061 446 tt0092099
INF60009 Task 3 Pass Level Tasks · ALL tasks in this section MUST be completed for you to successfully complete the Pass Level Tasks · Download the file named movie_only.txt from Canvas. . Edit the script. · Perform a find and replace. Change all occurrences of movieXXXX to movie9999 (where 9999 is the last 4 digits of your student ID) · Save the changes. Pass 3a · Go to https://feenix-isqljr.swin.edu.au and select iSQLJr from top left menu. · The username id 's' + your student id. (e.g. s123456789) The password is your birthdate (6 digits ddmmyy format). The database is DAD. · Execute the script that you modified earlier named movie_only.txt. SELECT " FROM TEVIS MOVIENO TITLE RELYEAR RUNTIVE RATING CODE · This will create the movie table and populate it with data. HaEgy Fr . Write and execute the SQL statement to list only the TITLE and RELYEAR columns of every row in the movie table. No specific sequence is required. M · Screen Capture the SQL text box plus the first 8 rows of the result set · Paste the screen captures in the appropriate position in the document named TO3P.DOCX Pass