PostgreSQL relational database on Linux OS

Task 1 "query": Create relational database with records:

1. Install PostgreSQL on Linux Ubuntu OS
2. Login as 'postgres' user and create new database
3. Create tables with fields based on business diagram
4. Create logical relationship between tables (CONSTRAINT)
5. Insert test data
6. Write some test queries

Database shema

Task 2 "usersAndSecurity": Increase security by creating roles, users, manage schema privilegies:

1. Create Create Role and User with password
2. Asign Role, Database and Schema public to current user
3. Asign privilegies to the Role
4. Login with the user and check if Connect, Create, Select, Delete, Alter work correct
5. Try to select user by email and crypt password and update old password with new value by using crypt() function

Tools: PostgreSQL, Linux OS