NO handwritten submission will be accepted!
Read Chapters 6.1-6.5 to refresh your knowledge about SQL.
Assignment #1 Download Assignment #1 course.txt
Download course.txtdept.txt
Download dept.txtenroll.txt
Download enroll.txtmajor.txt
Download major.txtprof.txt
Download prof.txtsection.txt
Download section.txtstudent.txt
Download student.txt
Note: for Part B you need to insert your own test data.
How to use copy command (a psql command):
PostgreSQL-practice-2023.ppt Download PostgreSQL-practice-2023.ppt (slides 3-5)
File Transfer between your local file directory and your CS student directory File Transfer (Windows&MacOS) (1).pdf Download File Transfer (Windows&MacOS) (1).pdf
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|
