Abbottabad Uni's Project Management: Entity, Relationship, and Domain Identification, Assignments of Database Management Systems (DBMS)

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 #2 Department of computer science BSSE-4th Project Title: “PROJECT MANGEMENT SYSTEM” Submitted To: Ma'am Mehwish Submitted By: Student Name Roll Email Number Bakhtawar Jadoon 6320 Bakhtawar jadoon941@gmail.com Submission Date: 27/6/2020 Foreign keys in project management system: Project Details Project_ID_FK1 Payments Project_ID_FK1 Projects Client_ID_FK Project status Project_ID_FK1 tasks Project_ID_FK1 The payment is the associative entity with the project. project ID payments pay into projects ct ID Specialization and generalization of PMS: Here project is super type entity and payment, project details are sub types . end date start date projects. project_ID project_ID project_ID i Projects Details payments details ID Enhanced ERD of Project management system: A a ON a. A vaiassor™ ~ have otal 7 Vv Gru | rota _ —Lavepayren) eee) (tester }— —_ A Domain of attributes of entities: Attribute Domain name__| Description Domain Client ID Client ID’s Set of all possible | Integer :size 5 Client ID’s Client name Client names Set of all possible | Character: size 25 Client names Status ID Status ID’s Set of all possible | Integer :size 5 Status ID’s Project status Project status's Set of all possible | Character: size 50 Project status's Detail ID Detail ID’s Set of all possible | Integer :size10 Detail ID’s Start date Start date’s Set of all possible | Date: format Start date’s mnvdd/yy Detail ID Detail ID’s Set of all possible | Integer :size 10 Detail ID’s Task ID Task ID’s Set of all possible | Integer :size 10 Task ID’s Task name Task names Set of all possible | Character: size 40 Task names