School of
School of Engineering
Department of Computer Engineering & Computer Science
Subject: Database Management Systems Subject Code: ECD 2142
Task: Individual Assignment Subject Coordinator: Ts. Keith Chong PL
Max marks: 50 marks (will be scaled down to 10 %)
Subject –Assignment – by “Your Names”
Submissions: Please submit soft copy on/before 20 January 2022
5 marks per day will be deducted for late submissions.
Assignment: Entity Relationship Diagrams
Assigned Date: 18.11.2021
Due Date: 20.01.2022
The Assignment: This assignment is about creating ER diagrams on the given topic.
Purpose: To analyze the existing manual system and draw Entity Relationship diagram.
Topic: University Management System
Deliverables – Your Assignment Report should contain
1. Problem Definition
2. Specify the business rules
3. Identify the entities (minimum 10 entities)
4. Identify the Entity Attribute’s (minimum 6 attributes per entity)
5. Identify the Primary keys / foreign keys
6. Give relational Schema for each table
7. Identify the relation between the entities
8. Identify the Cardinality
9. Draw the complete ERD
10. References
Everyone will be working on the same topic. Strictly no copying from each other or copying
directly from a book or any source from internet. One can always refer to internet/book for
ideas
To help you do this assignment
1. Diagrams can be hand drawn or use any software like word or Visio. ERD must be on any
blank A2 paper.
pg. 1
School of
School of Engineering
Department of Computer Engineering & Computer Science
2. First page must have the Cover Page of your Assignment.
pg. 2
School of
School of Engineering
Department of Computer Engineering & Computer Science
Cover Page
<<Assignment TITLE>>
DCEE
RDBMS
< Subject Code>
Submitted by: [Student Id / Student Name / branch]
pg. 3
School of
School of Engineering
Department of Computer Engineering & Computer Science
[Link] of Contents
CONTENTS
ABSTRACT i
LIST Of Entitles iii
LIST OF Attributes for each entity iv
LIST OF SYMBOLS v
pg. 4
School of
School of Engineering
Department of Computer Engineering & Computer Science
Abstract
ABSTRACT
<<A short summary of the assignment emphasizing on the model chosen, definitions of
important terms ..etc..>>
pg. 5
School of
School of Engineering
Department of Computer Engineering & Computer Science
Evaluation Rubric -
Sno Requirements Marks
allocated
1 Define the Problem, Indexing, Abstract 5
2 Specify the business rules 5
3 Identify the entities (minimum 10 entities)
4 Identify the Entity Attribute’s (minimum 6 15
attributes per entity)
5 Identify the Primary keys / foreign keys
6 Give relational Schema for each and every 5
table
7 Identify the relation between the entities
8 Identify the Cardinality 15
9 Draw the ERD
10 References 5
Total 50
pg. 6