CS507 ASSIGNMENT NO. 2 SPRING 2022 || 100% RIGHT SOLUTION || INFORMATION SYSTEMS || BY VuTech

CS507 ASSIGNMENT NO. 2 SPRING 2022

CS507 ASSIGNMENT NO. 2 SPRING 2022 || 100% RIGHT SOLUTION || INFORMATION SYSTEMS || BY VuTech

Instructions

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit (zero marks) if:

o   The assignment is submitted after due date.

o   The submitted assignment is other than .doc or .docx file.

o   The submitted assignment does NOT open or file is corrupted.

o   The assignment is copied (from other student or ditto copy from handouts or internet).

Uploading instructions

o   For clarity and simplicity, you are required to Upload/Submit only .doc or .docx file.

Objective

The objective of this assignment is to enable students:

o   To understand the concept of Entity Relationship Diagram

For any query about the assignment, contact at cs507@vu.edu.pk

Note:

No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignment in the last hour of deadline. It is recommended to upload solution file at least two days before its closing date.

Covering Lectures: Assignment No. 2 covers lectures 19-26.

Question No. 1

Identify entities and attributes from following scenarios.

A.  There is a Bank ABC, where people can open their accounts. In order to open account, they have to provide their name, Father Name, CNIC#, Address, and Source of income. After opening account, they get an account number and cheque book. They can deposit and withdraw money from their account.

B.  An ABC school has 3 branches in 3 different cities. Each Branch is assigned different code. Each branch announces admission two times a year. In order to get admission in particular branch of school, students have to apply online. The students have to fill online registration form in which they have to mention their CNIC#, name, branch code, and class in which admission is required. After filling out the form, students will get their test schedule having Roll No, test date and test center.

Note: You have to only extract entities and attributes given in above scenarios. Extracting of extra attributes is not required. Provide your answer in following table. Mention each entity and attribute on single line with proper numbering.