Project 1 Rubric

Load companyDB

http://tinman.cs.gsu.edu/~raj/8711/sp21/p1/companyDB.sql

Points
Login and Display Tables 10
Display Skeletons 20
Query 1 10
Query 2 10
Query 3 10
Query 4 10
Error Checks 10
2 Extra Features 20
Report 10
TOTAL 110

 

Display Skeletons:

  1. 2 employee, 1 department

  2. 1 employee, 1 dependent, 1 project

4 TEST CASES:

QUERY 1:

drawing

QUERY 2:

drawing

QUERY 3:

drawing

QUERY 4:

drawing

ERROR CHECKS:

 

Extra Features: any two of following

ASC/DESC, UNQ, Aggregates, Group By