BIT364 Semester 1: PostgreSQL Database Installation, CRUD & Sample

This practical assignment focuses on PostgreSQL, a non-relational database management system. It details the installation process, including system requirements and step-by-step instructions with screenshots. The document covers essential CRUD (Create, Read, Update, Delete) commands for PostgreSQL and provides a sample database implementation. Suitable use cases for non-relational databases, such as product catalogs, are also discussed. This document provides a comprehensive guide for setting up and using PostgreSQL, accompanied by a bibliography for further reading. Desklib offers a wealth of resources, including similar assignments and past papers, to support students in their learning journey.

Running head: POSTGRE SQL
Postgre SQL
Assignment Name:
Student ID:
Name of the Student:
Subject:

POSTGRE SQL
Name of Report:
Author Note
pg. 1 Student ID:

POSTGRE SQL
Table of Contents
Database Selection.....................................................................................................................3
Introduction................................................................................................................................3
Requirements of Installation......................................................................................................3
Steps of Installation....................................................................................................................4
Suitable Use Cases for the specified non-relational database..................................................21
CRUD Commands of the database..........................................................................................22
Sample Database......................................................................................................................23
Bibliography.............................................................................................................................28
pg. 2 Student ID:

POSTGRE SQL
Database Selection
The selected database for this topic is the PostgreSQL.
Introduction
The Postgre SQL is a object –oriented database management system which based on
the POSTGRE version 4.2 which was developed in the University of California at the
Berkeley Computers in the department of Science. The database had pioneered in various
type of database concepts which were realized much later in the other database concepts1. In
addition to this, the database supports the following part of the SQL Standards and features
such as the following:
 complex queries
 foreign keys
 triggers
 views
 transactional integrity
 multiversion concurrency control
Additonally the database also provides various type of features such as the Modification
and distribution by anyone at very low cost, be it private, public, commercial or
academic.
Requirements of Installation
The minimal requirements for the installation of the Postgre database is that the
operating system should be Windows 7, 8.1, or 10. Windows Server 2008 or later and 75 MB
of disk available for the installation of the database in the system. Additionally, a Unix
1 Obe, Regina O., and Leo S. Hsu. PostgreSQL: Up and Running: a Practical Guide to the Advanced Open
Source Database. " O'Reilly Media, Inc.", 2017.
pg. 3 Student ID:

POSTGRE SQL
compatible platform should also be able to run a database program such as this2. The
following packages would also be required for the installation of the Postgre SQL.:
 GNU make version 3.80 or newer is required
 ISO/ANSI C compiler (at least C89-compliant)
 The GNU Readline library
 The zlib compression library
Steps of Installation
After the Zip file has been downloaded from the online webpage of the database the
following steps as picturized below are to be followed:
2 Crestaz, E., N. Habashi, P. Ambrosini, P. Schätzl, and M. Gibin. "Advancements in concurrent native spatial
database technology for groundwater monitoring and modeling applications. A case study aimed at PostgreSQL-
PostGIS coupling with GIS and Feflow." In Proceedings of MODFLOW and More 2015 International
Conference, vol. 31. 2015.
pg. 4 Student ID:

POSTGRE SQL
pg. 5 Student ID:

POSTGRE SQL
pg. 6 Student ID:

POSTGRE SQL
pg. 7 Student ID:

POSTGRE SQL
pg. 8 Student ID:

POSTGRE SQL
pg. 9 Student ID:

POSTGRE SQL
pg. 10 Student ID:

POSTGRE SQL
pg. 11 Student ID: