This project is an SQL-based database schema designed to manage and store data related to research projects, employees, and funding agencies. It models real-world relationships between entities involved in collaborative research environments such as universities, tech labs, or grant-based research organizations.
- Stores information about:
- Projects: Including name, budget, duration, manager, and funding agency.
- Employees: With SSN, name, salary, and project assignments.
- Funding Agencies: Holding name and address.
- Supports:
- Many-to-many relationship between employees and projects.
- Unique project names within each agency.
- Each project funded by a single agency.
- Managers are also employees and can work on multiple projects.
