About CS409 Assignment 1
CS409 Assignment No 1 for Fall 2026 is from Introduction to Database Administration. It covers lesson 37: ER Diagrams with Relationships Many to Many, carries 20 marks and closed on VULMS on Wednesday 4 November 2026. No solution was added before it closed.
- Course
- CS409 Introduction to Database Administration
- Assignment
- Assignment No 1
- Semester
- Fall 2026
- Lesson
- 37: ER Diagrams with Relationships Many to Many
- Total marks
- 20
- End date
- Wed 4 Nov, 11:59 pm
What CS409 Assignment 1 asks
This assignment focuses on DBMS architecture levels and conceptual database modeling for a smart-device rental company. You will classify specific database operations into Internal, Conceptual, or External levels. Additionally, you will analyze a Device Rental System to identify entities, attributes, and relationships. Finally, you will design an Entity-Relationship Diagram (ERD) to represent the system's data requirements.
-
1
Question No. 1
Classify three provided scenarios into the correct DBMS architecture level. You must label each scenario as either Internal Level, Conceptual Level, or External Level. Provide your answers in the specified table format.
-
2
Question No. 2
Analyze the Device Rental System requirements to identify all main entities and their corresponding attributes. Determine the relationships and cardinalities between these entities based on the provided business rules. Create a complete ER diagram that includes all entities, attributes, primary keys, relationships, and cardinalities.
- What to submit
- One .DOC file containing the completed table and the ER diagram.
- Topics covered
- DBMS architecture levels Internal level Conceptual level External level Entity-Relationship modeling Cardinality constraints Database design
A summary of the assignment file, Fall 2026_CS409_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 CS409 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 37.
Before you submit on VULMS
- 1 This assignment closed without a solution. Use the assignment file to revise lesson 37 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 CS409 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.