Abbottabad University's BSSE-4th Project Management System, Assignments of Database Management Systems (DBMS)

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

2020/2021

Uploaded on 09/20/2021

bakhtawar-jadoon
bakhtawar-jadoon 🇵🇰

2 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
ABBOTTABAD UNIVERSITY OF SCIENCE & TECHNOLOGY
Artifact #1.1
Department of computer science
BSSE-4th
Project Title:
“PROJECT MANGEMENT SYSTEM”
Submitted To:
Ma'am Mehwish
Submitted By:
Student Name Roll
Number
Email
Bakhtawar Jadoon 6320 Bakhtawar [email protected]
Submission Date:
19/6/2020
pf3
pf4
pf5

Partial preview of the text

Download Abbottabad University's BSSE-4th Project Management System and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!

ABBOTTABAD UNIVERSITY OF SCIENCE & TECHNOLOGY

Artifact #1.

Department of computer science

BSSE-4th

Project Title:

“PROJECT MANGEMENT SYSTEM”

Submitted To:

Ma'am Mehwish

Submitted By:

Student Name Roll

Number

Email

Bakhtawar Jadoon 6320 Bakhtawar^ [email protected]

Submission Date:

PROJECT MANGEMENT SYSTEM

SCENARIO:

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

ERD of project management system: