database system

You will demonstrate your skills in this course with a small-scale database systems project with a GUI interface. Each team will implement a non-trivial database to support a particular activity, event, or organization. Following are the minimum design requirements: 1. The database should have a minimum of three entities and at least one many-to-many relationship. 2. The application program should allow the user to do insert/delete/update each of table in the database. 3. The application program should provide the user with a suitable interface to query the database and display the results. The supported queries will depend on your application. However, at least two of the queries must use joins (i.e., retrieve data from table X based on data specified from table Y ), and another two should provide statistics using aggregate functions. 4. Data validation: for insert/update operations, make sure you validate user input in the application, e.g., validate date format, numbers, and string values in the application before sending data to the database tables. 5. Application access is controlled through user login. There are two types of users: a. Administrator: i. Can create/update/delete other users ii. Has all privileges of the normal user b. Normal i. Full access to all tables but cannot add/delete users. 6. (Optional) Log user activity: Add a log table to keep track of what logged-in users are doing with the application. Below is a timetable and the description of project various stages, deliverables and deadlines: Stage 1: Team Finalization, Project Proposal and System Design Team of three members can be chosen for this course project. Self-enroll in the project groups on iLearn. Select you domain and project title. The design document should have the following sections: - Project Title - Project Description - EER Modeling of your project - Database Schema (relations and attributes) - Keys and Constraints Stage 2: Database Development and Manipulation \& GUI Development Develop the database from the database design done in the second phase of the project. Populate it with sample data Develop the GUI for the system. It can be web-based application