Scribd
Upload
17 views1 page

CS603 Assignment 1 Guidelines 2025

The assignment for Software Architecture and Design (CS603) requires students to complete tasks related to a banking system scenario, focusing on database design and relationships between entities. Students must submit their work in a Word document by the due date, adhere to originality rules, and avoid cheating. The assignment includes constructing database diagrams and identifying table relationships, with specific instructions on submission and evaluation criteria.

Uploaded by

Rana Bilal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
17 views1 page

CS603 Assignment 1 Guidelines 2025

The assignment for Software Architecture and Design (CS603) requires students to complete tasks related to a banking system scenario, focusing on database design and relationships between entities. Students must submit their work in a Word document by the due date, adhere to originality rules, and avoid cheating. The assignment includes constructing database diagrams and identifying table relationships, with specific instructions on submission and evaluation criteria.

Uploaded by

Rana Bilal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Assignment No.

01 Total Marks: 20
Semester: Spring 2025 Due Date: 30/04/2025
Software Architecture and Design - (CS603)

Assignment no. 1 covers Topics from Topic # 1 to Topic # 40.

Instructions:

The purpose of this assignment is to give your hands-on practice. It is expected that students will solve the assignment
themselves. The following rules will apply during the evaluation of the assignment.

 Assignment should be in a word document file form any other file type is not allowed.
 You should submit your assignment before or on the due date through VULMS.
 Your assignment should be your own work in your own words.
 Cheating from any source like Internet, handouts, ChatGPT or books will result in zero marks in the assignment.
 Assignments sent via email will not be replied to and accepted.
 If the submitted assignment does not open or the file is corrupt, it will not be marked and hence awarded zero marks.

Question No 1: Marks: 10

Consider the following scenario:

Consider a banking system where various entities interact with each other to manage financial services and
customer accounts. The bank has multiple Branches, and each Branch employs several Employees. Customers
can open Accounts, and each Customer may hold multiple Accounts, while each Account is linked to only one
Customer. Additionally, Accounts can be associated with multiple Services (like loans, credit cards, insurance),
and each Service can be linked to Accounts. This structure helps the bank manage its personnel, customer
services, and operations efficiently.

Based on the above scenario you have to answer the following questions.

a) Construct a database design diagram that includes the Branches and Employees tables only, clearly
illustrating their relationship.
b) Determine the type of relationship present between the Accounts and Services tables. Additionally, create
a database design diagram that includes only the Accounts and Services tables to illustrate this
relationship.
c) Mention only the names of all the potential tables involved in the banking system based on the given
scenario.
d) Based on your analysis in questions (a) and (b), specifically list the required column names for each table
and also specify the corresponding keys.

Note: You may break the relationship if you have to, for managing Relationship between the two tables.

Answer:

NOTE: Every student should provide his/her own work, exact copying of the assignment (or some portion of the
assignment) from the internet or other students will lead to copy case and zero marks will be awarded. Do not put
any query on MDB about this assignment, if you have any query, then email us at CS603@[Link]

You might also like