Creating a database using MySQL

Management Database System

Create a project management database system which manages baseline project information for an IT database design project, for many different users in multiple different locations of an organization. This database system should be able to report who is responsible for which project, or section of a project, at any point in time. It should also be able to report the progress of a project at any given time, noting the due date. Include user account data, users and project session management, and pertinent project information, as discussed in the text book. Include optimization techniques. Users access the data from all locations. Reporting is available in each location. Be sure to include replication schedules to maintain all database locations. Design the complete database application required to achieve these processes. Include diagrams, code, and descriptions and justifications of your approach and selected optimization techniques.