The Building Blocks of a Project Management System

Here are the primary functions of a project management system:

• Project planning: To define a project schedule, a project manager may use the software to map project tasks and visually describe task interactions.
• Task management: Allows the project manager to create and assign tasks, establish deadlines, and produce status reports.
• Resource management: Defines responsibilities – who is supposed to do what.
• Budgeting and cost tracking: A good project management application facilitates budget reporting as well as viewing, notifying, and updating costs for stakeholders.
• Time tracking: The software must have the ability to track time spent on all tasks and maintain records for third-party consultants.

Complete Database Schema Diagram

A database schema is the structure that represents the logical view of the entire database: tables, views, and primary and foreign keys. A database schema includes all entities and the relationships between them.

Below is the database diagram of our simple project management application. The key symbol in each table represents the table’s primary key while the magnifying glass indicates a foreign key linking it to another table (lookup table) in the database.

The diagram is made with DBSchema.

Check out complete walkthrough