Introduction

$$ Throughout this semester, we learned the basic concepts of database systems.

$$ The purpose of the final project is to get an in$-$depth experience by creating schema, inserting

records, and updating the database instance.

$$ Minimal requirement

$$ Draw an ER diagram for the University

$$ Write DDL statements for each entity

$$ Write DDL statements for each relationship

$$ Explain each DDL statement in relation to ER diagram

$$ Write sample insert statements for each table $($both entity and the relationship$)$

$$ Connect to the database using JDBC

$$ Create database schema using JDBC

$$ Moderate requirements

$$ Insert records to all tables

$$ Assuming that income tax rate is $10\%,$ print the tax amount for each instructor about

the amount of tax

$$ Print the student with the highest grade for each semester.

$$ Challenge requirements $($Write an application program$)$

$$ Write application functions

$$ Explain the interface

$$ Show the DML statements

$$ Write Java Program

$$ Example functions

$$ Insert$/$delete new students using JDBC

$$ Insert$/$delete new instructor

$$ Change a student$$s department