代写JDBC Assignment代写Java编程

JDBC Assignment

30%

Submission Instructions

You must submit a zip file via Moodle containing the following

1. Your java project

2. Your database setup script.

3. A 5-7 minute screencast explaining your project

4. A word document (no more than 3 pages) outlining

a. the key concept of your project

b. a snapshot of your java GUI

c. any extra features you may have used

Assignment Instructions

You are required to design a relational database for a concept of your choice and connect to this database from a Java GUI using JDBC.  You should base your work on the template given. Your assignment should

1. Create a sample relational database of your choice (Database Content)

2. Implement  Create, Read, Update and Delete (CRUD) operations (CRUD Actions)

3. Extract data from your relational database using JDBC and export the content to a Comma Separated Values (CSV) format. (Export Data)

Expectations

Good Concept

Joins

Stored functions / procedures /triggers

Good use of SQL Queries