Unit MBIS$4002$ Database Management Systems

$1|$ P a g e

A$1$ Session $5$b $(3\%)$ Natural Join

Objectives:

$$ To use the installed software PostgreSQL & SQL Shell $($psql$)$ to complete tasks.

$$ To use SQL Natural Join Operator to retrieve data from two or more tables

Assessment Requirements:

$$ It is required to use the database script file, nasa.sql to complete this task;

$$ It is required to use the client, SQL Shell, psql to complete the task. Any

submissions only providing SQL query without its output from psql will not

be accepted.

$$ All submission files should be submitted through this submission link on

Moodle.

$$ The name of the submission file should be A$1$Session$5$b$\_$YourSID $.$txt$/.$sql$.$

$$ The submission file, $.$txt or $.$sql should include the copy of the whole output in the

psql$,$ including login$,$ using command $\backslash$i to upload the nasa.sql database script file

to PosgreSQL, and using simple SQL query to retrieve data through the client,

psql$.$

$$ If your submission with high similarity, you need to demonstrate it is your won

current work: $(1)$ by submitting additional screenshots, the output of psql with

your computer timestamp in Microsoft Word document; or $(2)$ by showing demo

to your lecturer$/$tutor during class session.

$$ You may also include screenshots with time stamp of the computer to

demonstrate your current work in Microsoft Word document, but any photos

taken by mobile phone or screenshots by computer will not be accepted as

student's solutions. If the student did not submit the $.$txt or $.$sql file, zero marks

would be given.

$$ For any Academic Misconducts, $0$ marks will be given and it will be reported as

Academic Misconducts. e$.$g$.$ If a student would share solution$/$files with other

students, those students would receive $0$ marks.

Activities

The following activities take you through the processes of:

$$ Start the SQL Shell $($psql$)$;

$$ Logon to the psql;

$$ Loading the script file, nasa.sql into PostgreSQL server;

$$ Use SQL Natural Join Operator to retrieve data from two or more tables;

Unit MBIS$4002$ Database Management Systems

$2|$ P a g e

Unit MBIS$4002$ Database Management Systems

$3|$ P a g e