Database Assignment.

Computer Science Department CSC 3300 Database Management Systems Project3-Step2 (04/07/2016; Spring 2016) Beata Kubiak

What to submit as a solution to the Step2 of Project3? Zipped: java code, documentation in the PDF format.

Where to submit this file? The dropbox in iLearn named Project3-Step2. The due date for this assignment is 04/15/2016 at 9:00pm. The end date for this assignment is 04/17/2016 at 9:00pm.

Rules You may discuss on piazza what has to be done (clarification of the assignment’s specification). Don’t use any third party libraries.

How this assignment will be graded? This assignment is worth 75% of the grade for the third project and a maximum of 100 points. Your submission has to meet the requirements to be given max number of points. Unadressed aspects in this document are subject to your own decisions. Your program has to provide functionality described below, be of good quality and come with the documentation.

Points No Documentation of the code 10 Validation of user input 10 CLI 10 Documentation 10 SQL statements 10 Functionality 50

Table 1: Grading

Implement a console java applications that interacts with the University database that is described in the book entitled ”Database System Concepts” by Avi Silberschatz, Henry F. Korth and S. Sudarshan.

User brown(staff) should be able to log-in with password brown123. User grey(student) should be able to log-in with password grey123.

1. brown should be able to:

(a) retrieve info abut all departments without info abut their budgets

(b) create/retrieve all/update/delete courses

(c) create/retrieve all/update/delete course sections

2. grey should be able to:

(a) register for a course section

1

(b) drop a course section

(c) retrieve all course sections he currently takes (grade is null)

(d) view his transcript

i. all course sections he took and those he takes currently ordered by semester and year (semesters should be ordered!)

ii. gpa (A corresponds to 4 grade points , B 3 grade points etc. <make your assumptions here>)

Additional requirements:

1. Document your code.

2. Validate user input. Your program shouldn’t ever crash.

3. Information displayed to the user (Command Line Interface) should be intuitive.

4. Documentation should include:

(a) User manual (screenshots are welcome).

(b) Implemented and not implemented functionality.

(c) Assumptions made regarding issues that were not explicit.

(d) Info about how to build and run your project.

2