Assignment No. 03 Semester: Spring 2012 CS507-Information Systems

Assignment No. 03
Semester: Spring 2012

CS507-Information Systems

Total Marks: 20

Due Date: 07/6/2012

Uploading instructions:

Please view the Assignment Submission Process document provided to you by the Virtual University for uploading assignments.

• Your assignment must be in .doc format.(Any other formats like scan images, PDF, Zip, rar, bmp, docx etc will not be accepted).
• Save your assignment with your ID (e.g. bc020200786.doc).
• No assignment will be accepted through email.

Assignment

Question 1: (10 Marks)

Draw a flow chart to illustrate the following functionality of Temperature analyzer in Air conditioner.

Functionality to illustrate in Flow Chart

• Input the Temperature
• If temperature is below 26 degrees then print the message “It is not very hot” and after displaying this message turn off the compressor.
• If temperature is above 26 degrees then print the message “It is Hot” and after displaying this message turn on the compressor.

Question 2: (10 Marks)

Consider a super store having several branches and each branch having registered customers. Draw an Entity Relationship Diagram to show primary relationship between registered customers and branch of the super store.

Following are the attributes of customer and branch of super store.

Attributes of Registered Customer	Attributes of Branch of super store
CustomerID (This is Primary Key attribute)	BranchID (This is Primary Key attribute)
Name	Location
Gender	Number of Customers (This is derived attribute)
Join Date	Start Date
Phone (This is multi valued attribute)

NOTE: Submit “.doc” file only. 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. Different softwares will be used to check plagiarism in assignments. Do not put any query on MDB about this assignment, if you have any query then  email at cs507@vu.edu.pk