PLEASE HELP URGENTLY

This document describes the final delivery of the class group project. Students are expected to think of some project which satisfies all the following criteria.

The user interface for the project should be graphical user interface (GUI) based.

The basic assumption is that your project will use MySQL as your DBMS.

The project must demonstrate your mastery of the relational model knowledge covered throughout the semester as well as your ability to develop a 3-tier integrated system with a GUI presentation layer, logical layer and a relational database as its storage mechanism.

PLEASE SEND REQUIRED FILES AS ANSWERS!

THANKS

Analysis \& Class Diagram (25 Points) Provide a document containing the following content: 1. Provide a final project description and class diagram of your project. (15 Points) 2. There should be at-least one Composition / Aggregation in your project. (5 Points) 3. BONUS POINTS: At-least one generalization. (5 Points) MySQL Database Schema (30 Points) Provide a SQL file of your schema. This should contain at least the create commands for the objects within your database: tables, indexes, constraints etc. It may also contain a dump of the data. The schema should contain the following: 1. There should be at-least 3 tables in your schema. (6 Points) 2. Tables should ensure data integrity (Domain, entity and referential) (9 Points) 3. Use views, indexes, stored procedures, triggers, wherever applicable. (15 Points) Presentation Layer (35 Points) Provide one file that contains a subset of the presentation layer (front-end) code used to build your system. You may use any language which you are comfortable in. You should be able to connect your MySQL database with this language. Please ensure security of your system especially against SQL injection attack. 1. GUI should be aesthetic and highly useable. (5 Points) 2. User should be able to perform CRUD operations on your database. (20 Points) 3. System should be securely developed. (10 Points) Final Submission and Presentation (10 Points) Please provide a verbal 5-minute description video of your project. It should contain a brief description of the schema, the architecture, and utility. You can provide a visual representation such as a power point slide describing your system and schema. You need to provide a demonstration of the front end with CRUD operations. It is important that you describe and demonstrate your project succinctly without exceeding the time limit. Submission and Presentations are scheduled for end of the semester on the final examination day