CodeStar1403-SE-Phase07-Team06

[rajabi-m]

• [x] Read the introduction to SQL
• [x] Understand basic concepts
• [x] Install required softwares
  • [x] Download PostgreSQL
  • [x] Download Azure Data Studio
  • [x] Install PostgreSQL with default configs
  • [x] Install ADS
  • [x] Run and configure ADS to work with Postgres
  • [x] Create connection to the Postgres instance
• [x] Create your own database
• [x] Get familiar with different data types in Postgres
  • [x] Write a suitable data type for each of the fields below:
    • TIMESTAMP for flight time
    • VARCHAR(255) for email address
    • BOOLEAN for a boolean variable
    • NUMERIC(5,2) for stature
• [x] Store some data
  • [x] Create a table with arbitrary columns with data types you learned in the previous section
  • [x] Insert some sample data into your table
  • [x] Retrieve your data with different SELECT statements and different conditions
  • [x] Try to change at least one of your table columns attributes using ALTER statement
• [x] Perceive the importance and usage of each key
  • [x] Add primary key constraint to your table
  • [x] Try inserting different values for primary key and check whether it produces error or not
    • Try inserting duplicate primary key. Error duplicate key value violates unique constraint "studentpk"
    • Try inserting NULL primary key. Error null value in column "studentnumber" of relation "student" violates not-null constraint
  • [x] Create a new table which is related to your existing table with a foreign key
  • [x] Try inserting different values for foreign key to produce different errors
    • Try inserting none existing foreign key. Error insert or update on table "enrollment" violates foreign key constraint "studentnumberfk"
    • Try inserting duplicate foreign key. Error No Error
    • Try inserting NULL foreign key. Error No Error
• [x] Perceive different types of joins
  • [x] Write the corresponding set operation for each join like the given example
    • A Inner Join B : A ∩ B
    • A Left Outer Join B : A
    • A Right Outer Join B : B
    • A Full Outer Join B : A ∪ B
  • [x] Test different joins on you tables
• [x] Work with functions
  • [x] Write a query for each present function in the document