Simple Case Study for Exercise CRUD in PostgreSQL Terminal

Case Study

• create a database for bootcamp registration

Flow main

• day-1 : open registration bootcamp

• day-2 : incoming registrants

• day-3 : assessment >= 60 = accepted, < 59-40 = reserve, <40 = rejected

• day-5 : remove those with lower scores and incomplete personal data

Data

• Fajar, test scores = 85, already paid the payment, complete personal data

• Rika, test scores = 58, have not paid the payment, personal data is incomplete

• Tono, test score = 35, have not paid the payment, complete personal data

CRUD

1. open terminal and login to postgres

   

2. Create table bootcamp —day-1

   

3. INSERT data INTO table —day-2

   

   

4. update data —day-3

   

5. update data and delete whose personal data is incomplete and have not paid —day-5

   

END!

Thanks and see you next time.