Student ID Number
Family Name
Given Name

Assessment 4: In Class Practical Test

Select Year:

Select a Semester:

Subject:

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.

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; to use PostgreSQL shell (psql) to complete this Practical Test; and to copy, paste and save all of your SQL queries and outputs into .txt or .sql file.

Please copy or screenshot the query you have typed and its output in psql, then paste 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.

For late submission, marks will be reduced by 10% -20%.

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, and who were born after 1930, Order by age of year of death. With the given data, the result of the correct query will be:

Question 2.

List the missions (projectname, missionno), craftname of all missions launched that lasted less than an hour. Also show the hours and minutes of those missions order by craftname. 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:

The post Assessment 4: In Class Practical Test appeared first on My Assignment Online.