ABBOTTABAD UNIVERSITY OF SCIENCE & TECHNOLOGY
Artifact #2
Department of computer science
BSSE-4th
Project Title:
“PROJECT MANGEMENT SYSTEM”
Submitted To:
Ma'am Mehwish
Submitted By:
Student Name Roll
Number
Email
Submission Date:
27/6/2020
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
Guidelines and tips
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
Abbottabad Uni's Project Management: Entity, Relationship, and Domain Identification, Assignments of Database Management Systems (DBMS)
A project submission for the Department of Computer Science at Abbottabad University of Science & Technology, BSSE-4th year. The project titled 'Project Management System' includes the identification of entities, relationships, composite and multivalued attributes, weak entities, associative entities, and the specialization and generalization of PMS. The document also provides an enhanced ERD and the domain of attributes for various entities.
Typology: Assignments
2020/2021
1 / 7
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Abbottabad Uni's Project Management: Entity, Relationship, and Domain Identification and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!
ABBOTTABAD UNIVERSITY OF SCIENCE & TECHNOLOGY
Artifact
Department of computer science
BSSE-4th
Project Title:
“PROJECT MANGEMENT SYSTEM”
Submitted To:
Ma'am Mehwish
Submitted By:
Student Name Roll
Number
Bakhtawar Jadoon 6320 Bakhtawar^ [email protected]
Submission Date:
Foreign keys in project management system:
Project Details
Project_ID_FK
Payments
Project_ID_FK
Projects
Client_ID_FK
Project status
Project_ID_FK
tasks
Project_ID_FK
Attributes of relationship:
Now if we deeply inspect all the relationships in this project, we will find an associative entity between the relationship of entities images and category. We have a Test relationship between these entities which we can convert in to a separate associative entity because;
Identification of weak entity:
Project details totally depend on project so project details is a weak entity.
Identification of associative entity:
The payment is the associative entity with the project.
Specialization and generalization of PMS:
Here project is super type entity and payment, project details are sub types.
Enhanced ERD of Project management system:
Domain of attributes of entities:
Attribute Domain name Description Domain
Client ID Client ID’s Set of all possible
Client ID’s
Integer :size 5
Client name Client names Set of all possible
Client names
Character: size 25
Status ID Status ID’s Set of all possible
Status ID’s
Integer :size 5
Project status Project status's Set of all possible
Project status's
Character: size 50
Detail ID Detail ID’s Set of all possible
Detail ID’s
Integer :size
Start date Start date’s Set of all possible
Start date’s Date: format mm/dd/yy
Detail ID Detail ID’s Set of all possible
Detail ID’s
Integer :size 10
Task ID Task ID’s Set of all possible
Task ID’s
Integer :size 10
Task name Task names Set of all possible
Task names