Sep 18: GP1 Feedback, PostgreSQL
Learning Objectives
After today's class, you should be able to:
- Identify next steps (and potential new directions) for your project.
- Connect to
data.cs.jmu.eduand execute queries using pgAdmin.
Lesson Outline¶
[5 min]How the group project will be graded[5 min]GP1 review process for today's class[35 min]Discuss, give, and receive feedback[30 min]PostgreSQL demo and pgAdmin lab
Project Grading¶
| Weight | Assignment | Criteria |
|---|---|---|
| 50 pts | GP1–GP5 deliverables (10 pts each) | Completeness, Correctness |
| 25 pts | GP1–GP5 FB = feedback (5 pts each) | Peer Assessment, Self Assessment |
| 25 pts | Performance evaluations (mid and end) | Communication, Dependability, Amount of Work, Quality of Work |
| 100 pts | Final project as a whole (end of course) | Database Design, Build Scripts, SQL Queries, Web App Features |
GP1 Review¶
- Discuss the feedback you will give
[8 min]- Compare your individual review responses
- Identify the main points to share verbally
- Meet other teams and give feedback
[24 min]- Each round is 8 minutes (4 minutes/team)
- Round 1: 1 and 2 3 and 4 5 and 6
- Round 2: 7 and 1 2 and 3 4 and 5
- Round 3: 6 and 7 (when available)
- Discuss the feedback you received (during round 3)
- Make plans and divide up the work to be done
PostgreSQL¶
- Pronounced "post-gres-Q-L"
- PostgreSQL vs MySQL (Integrate.io blog)
- For Example: Data Types
- However: DB-Engines Ranking
- pgAdmin – PostgreSQL Tools
- Exploring what's in the menus
- Clicking the tabs for an object