Historia

Project 1: Simple Course Catalog
Deadline: September 6, 2012 at 11:59 PM (no late assignments)
Points: 20 (This assignment cannot be dropped)
Turn in: Zip your code and your db file and turn intoNiikha (make sure that you use relative paths when expressing the location of the database in your code).
Mini-world Description
You are going to build an application to manage and query a set ofcourses and departments at a university. Since this is the first project, this has been greatly simplified. A department consists of an id (a sequence of 3 characters which uniquely identifies thedepartment), a name (up to 30 characters), an office (up to 20 characters), and a phone (a 7 digit number)). A course has an integer id, a department, a name (up to 30 characters, and a description(up to 100 characters). Courses are uniquely identified by their name and their department. Your application has to be able to list all departments, list all courses, add departments, add courses,remove courses, remove departments, find all courses in a department, search departments by name keyword, and search courses by name keyword. Searching by key word returns anything that that containsthe keyword (this should be case sensitive—this is a favor case insensitive is harder).
Restrictions (you risk getting a 0 if you do not do this)
1. Code must be written using SQL Lite (Thisshould be the only access to disk).
2. Code must use JDBC to access the SQL Lite database.
Population of Data
You will be responsible for populating the data for your sample application (your dbfile that you turn in must meet these requirements). The minimal requirements are as follows:
1. Create 3 or more departments. These should have reasonable names, offices, and phone numbers.
2.Create 10 or more courses. These should have reasonable names and descriptions.
3. Each department must have at least 2 courses.
Sample Run
I have given three sample runs, write a Java...