Student ID Number Family Name Given Name Assessment 4: In Class Practical Test Select Year:2020 Select a Semester:1 Subject:ISY1002/ISY103 Database Management for Business Length of Exam:1 hours...

is it possible to do the assignment in 1 hour?/


Student ID Number Family Name Given Name Assessment 4: In Class Practical Test Select Year:2020 Select a Semester:1 Subject:ISY1002/ISY103 Database Management for Business Length of Exam:1 hours Instruction Time:Additional 10 minutes Total Marks:20 READ THE FOLLOWING INSTRUCTIONS BEFORE COMMENCING THE EXAMINATION 1. No writing during instruction time. 2. The question paper and answer booklet are to be handed in on completion of the examination. No calculators are allowed. 3. This is an open book exam. No electronic devices are allowed. Section Question Type Number of Questions Number of Marks per question TOTAL MARKS A Simple SQL Query 1 6 6 B Natural Join SQL Query 1 7 7 C Cross Product SQL Query 1 7 7 TOTAL / 20 Assessment 4: In Class Practical Test (20 Marks) Answer all these 3 types questions. It is required to use nasa.sql file; and to use PostgreSQL shell (psql) to complete this Practical Test. Please copy or screenshot the query you have typed and its output in psql, then past it into your answer sheet. Students need to submit their answers to Moodle. If you don’t write your student no and student name, your paper will not be checked. SECTION A: Questions Question 1. List the astronauts names, year of birth, year of death, and age at year of death (astroname, birth, death, death - birth) of all astronauts who have died after 1960 before 1990, Order by year of birth. With the given data, the result of the correct query will be: Question 2. List the missions (projectname, missionno), craftname, and launchYear of all missions launched after 1960 by any projectname called “Mercury”. Order by the mission no. With the given data, the result of the (correct) query will be: Question 3. Re-express the above natural join query as a cross product. SECTION B: Answers Answer 1: Answer 2: Answer 3: 3