CS403 Assignment 1 Solution Fall 2017
#1
CS403- Database Management System
Assignment No. 01
SEMESTER Fall 2017


[b]Question  [/b]
 
Consider that you are working as a database designer in a software company. Your company has given the project for developing an application for the Election Commission of Pakistan. The application would enable the citizen of Pakistan to cast vote through this application.  Keeping in view that a citizen of age 18 and more can cast the vote. At the voting day a ballot paper is allotted to voter which contains symbols of different political parties. The voter chooses a symbol of his/her own interest and mark it through stamp. At the end of the day presiding officer or the polling staff counts the votes and submitted the results to election commission of Pakistan. The Election Commission then announces the results publically and to the candidates.
The entire application is going to be developed in the broad perspective, However you are required to keep in view only the scenario (portion) whose details have mentioned above and perform the following tasks.
 
  1. Draw Context Diagram (Level 0 DFD) which depicts the above scenario.
  2. Identify Entities, their attributes, relationships among entities in above scenario and draw Entity Relationship Diagram (ERD) for it.



Solution
Entity Relation Diagram of Election System

ERD of Election Sytem
  


Possibly Related Threads…
Thread Author Replies Views Last Post
  CS403 Assignment 1 Solution Fall 2019 Ayra Suleman 0 87 11-11-2019, 01:12 AM
Last Post: Ayra Suleman
  CS403 GDB IDEA Solution Spring 2019 Ayra Suleman 0 662 08-10-2019, 12:23 AM
Last Post: Ayra Suleman
  CS403 Assignment 2 Solution Spring 2019 Mishi Khan 0 1,208 05-27-2019, 01:31 AM
Last Post: Mishi Khan
  CS403 Assignment Solution Spring 2019 Mishi Khan 0 425 05-12-2019, 02:57 PM
Last Post: Mishi Khan
  CS403 GDB Solution Mishi Khan 0 1,244 02-05-2019, 11:30 PM
Last Post: Mishi Khan
  CS403 MidTerm Past Paper Mishi Khan 0 886 12-14-2018, 09:56 PM
Last Post: Mishi Khan
  CS403 Assignment # 3 solution Rubaisha(Moody Girl) 2 4,771 11-18-2017, 09:45 PM
Last Post: Pakistani
  Need solution for CS403 nadia ahmed 2 2,418 11-15-2017, 05:19 PM
Last Post: nadia ahmed
  CS403 Assignment 1 help required Syed Muhammad Taha 3 3,961 05-06-2017, 06:50 PM
Last Post: Admin
  CS403 GDB Complete correct solution Rubaisha(Moody Girl) 0 4,532 07-28-2016, 04:28 PM
Last Post: Rubaisha(Moody Girl)



Users browsing this thread:
1 Guest(s)