About CS409P Assignment 1
CS409P Assignment No 1 for Fall 2026 is from Introduction to Database Administration (Practical). It covers lesson 3: Lab 03: Entity Relationship Diagram, carries 20 marks and closed on VULMS on Wednesday 4 November 2026. No solution was added before it closed.
- Course
- CS409P Introduction to Database Administration (Practical)
- Assignment
- Assignment No 1
- Semester
- Fall 2026
- Lesson
- 3: Lab 03: Entity Relationship Diagram
- Total marks
- 20
- End date
- Wed 4 Nov, 11:59 pm
What CS409P Assignment 1 asks
This assignment focuses on database design principles, specifically identifying key types and creating an Entity Relationship Diagram for an Appliance Service Booking System. Students will classify various database keys based on provided descriptions and model a real-world scenario involving service centers, technicians, customers, and bookings. The work requires mapping entities, attributes, and relationships to produce a conceptual database model. Students must demonstrate their understanding of ER notations and cardinality constraints.
-
1
Question 1
Identify the correct key type for five specific descriptions provided in a table. The options to use are Super Key, Candidate Key, Primary Key, Surrogate Key, and Composite Key. Each option must be used exactly once to classify the described identifying sets or attributes.
-
2
Question 2
Analyze the Appliance Service Booking System scenario to identify four main entities and their respective attributes. Define the relationships between these entities and specify the cardinality for each. Finally, draw a complete ER diagram that incorporates all entities, attributes, primary keys, relationships, and cardinalities using standard ER notations.
- What to submit
- One .DOC file containing the completed table and the ER diagram.
- Topics covered
- Database keys Entity Relationship Diagram Cardinality Conceptual database modeling ER notations
A summary of the assignment file, Fall 2026_CS409P_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 CS409P 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 CS409P 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.