HEAVY WEIGHT: We will assign 20% for the completeness of the GUI. During the demo, we will ask you to perform all the tasks as described in the project description. If you can finish all tasks correctly, you will get an A+ in Phase III. The more complicated tasks (reports) will have a higher weight than the simple ones. Please make sure they all (especially reports) work correctly. For each missing or incomplete task, we will deduct the points accordingly. LIGHT WEIGHT: First, you need to setup the database system 1. Either ORACLE on ACME. 2. Or other database systems - (MySQL/MS SQL Server) on your local machine. Second, we suggest that you create a file that consists of the following parts (or they can be in three separate files): 1. CREATE TABLE: it consists of create table sql commands 2. INSERT: consists of INSERT commands to populate the database,i.e., Books, Members, some pending requests, some issued books etc. You can make up the values for the rows in each table. 3. SQL Statements (insert, update, select): it consists a sets of SQL statements for each task as mentioned in the IFD. It is very similar to phase II. During the demo, we will walk through the tasks and give points accordingly. We expect you to use aggregate functions (sum, count), group by and join operations to perform the tasks, e.g. calculate total fine for a Member, check if a Member can request/borrow a book or not, view all the pending requests, issued books etc. Do not use simple Select statements while doing the data computation inside your application program. The database query should extract the exact data that is needed and your application program should just format the data for viewing. We suggest you make up a plan according to the IFD for phase I and we will follow those steps to test all your SQL statements.