



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
A project management system designed for a software house at Abbottabad University of Science & Technology. The system aims to keep records of projects, employees, project status, and payments. Entities and attributes include Clients, Projects, Project Details, Payments, Tasks, and Project Status. The document also includes the ERD (Entity Relationship Diagram) of the project management system.
Typology: Assignments
1 / 5
This page cannot be seen from the preview
Don't miss anything!




PROJECT MANGEMENT SYSTEM
The scope of the current project is to design the database of one of the several processes of a software house. The main objectives of designing data base are as follows: To keep records of projects. To keep records about the employees. To keep the project status. Information about payments It checks the detail of given projects. .
Projects Candidate keys Primary key Client ID Project ID Project ID Start date End date Projects DETAILS Candidate keys Primary key Detail ID Detail ID Project ID Payments Candidate keys Primary key Payment ID Payment ID Payment date Task Candidate keys Primary key Task ID Task ID Task name Project status Candidate keys Primary key Status ID Status ID Project status Project ID