About CS403P Assignment 1
CS403P Assignment No 1 for Fall 2026 is from Database Management Systems (Practical). It covers lesson 3: Lab 3-Entity Relationship Diagram, carries 20 marks and closed on VULMS on Wednesday 4 November 2026. No solution was added before it closed.
- Course
- CS403P Database Management Systems (Practical)
- Assignment
- Assignment No 1
- Semester
- Fall 2026
- Lesson
- 3: Lab 3-Entity Relationship Diagram
- Total marks
- 20
- End date
- Wed 4 Nov, 11:59 pm
What CS403P Assignment 1 asks
This assignment focuses on designing an Entity Relationship Diagram (ERD) for a university database system. You will analyze a scenario involving students, courses, instructors, departments, and textbooks to determine their interactions. The work requires identifying entities, their specific attributes, and the relationships between them. Finally, you must synthesize these components into a complete ERD.
-
1
Task 1: Identify Entities
List all the entities present in the provided university scenario. Ensure you extract every distinct entity type mentioned in the description.
-
2
Task 2: Identify the attributes of the entities
Define the attributes for each entity identified in the previous task. You must determine the relevant characteristics that describe each entity within the system.
-
3
Task 3: Identify the relationships between the entities
Determine the nature of the relationships between the identified entities. Specify how these entities interact based on the provided business rules.
-
4
Task 4: Draw the Entity Relationship diagram
20 marksCreate a visual Entity Relationship Diagram using the entities, attributes, and relationships extracted in the first three tasks. The diagram must accurately represent the university database structure described.
- What to submit
- One .doc or .docx file containing the final Entity Relationship Diagram.
- Topics covered
- Entity Relationship Modeling Database Design Entity Identification Attribute Definition Relationship Mapping ERD Notation
A summary of the assignment file, Fall 2026_CS403P_1.docx. Download the file for the full wording before you start.
Lesson covered
The questions in this assignment come from this lesson. Read it in the CS403P handout before you open the assignment file, then practise it with the MCQs and past papers.
Solution
No solution was added before this assignment closed. The assignment file stays here so you can revise lesson 3.
Before you submit on VULMS
- 1 This assignment closed without a solution. Use the assignment file to revise lesson 3 before your exams.
- 2 Write the final answer in your own words. VU checks assignments for copying, and copied work gets zero marks.
- 3 Save your answer in the file type the assignment file asks for, and name it with your student ID, for example BC260012345.
- 4 Open the file once more to check it is not empty or corrupted, then upload it on VULMS before 11:59 pm on Wed 4 Nov.
Questions about this assignment
When is CS403P Assignment 1 due?
It closed on Wednesday 4 November 2026. VULMS no longer accepts files for it, but the assignment stays here for revision.
Will a solution be added?
No. Solutions are written only while an assignment is open on VULMS, and this one closed on Wednesday 4 November 2026. The assignment file stays here for revision.
Can I submit the solution as it is?
No. VU checks assignments for copying, and copied work gets zero marks. Use the solution to check your method, then write your own answer.
What file do I submit?
The assignment file says which file type to upload and lists any extra instructions from your instructor. Name the file with your student ID before you upload it on VULMS.