CS302 Assignment No. 01 Solution

	Assignment No. 01 Semester: Spring 2011 CS302: Digital Logic Design		Total Marks: 10 Due Date: 18/04/2011
Instructions: Please read the following instructions carefully before submitting assignment: It should be clear that your assignment will not get any credit if: § The assignment is submitted after due date. § The assignment is submitted via email. § The submitted assignment does not open or file is corrupt. § All types of plagiarism are strictly prohibited. Objectives: · Understanding the number system. · Understanding the conversion of numbers into various number systems. Guidelines: · Perform all steps while converting the numbers.
Assignment
Problem Statement: 1) Convert 10101100 binary numbers to its decimal equivalent. (2 Marks) Solution: 10101100 = 1x27 + 0x26 + 1x25 + 0x24 + 1x23+ 1x22 + 0x21 + 0x20 = 1x128 + 0x64 + 1x32+ 0x16 + 1x8 + 1x4 + 0x2 + 0x1 = 128+0+32+0+8+4+0+0 = 172 2) Convert decimal number 374 to octal number. (2 Marks) Solution: We will use repeated division method. 8 374 8 46 – 6 8 5 – 6 0 - 5 Now writing the reminders in the reverse order 566. 3) Convert the following 0110100000111001 (BCD) in to decimal number. (2 Marks) Solution: We first of all with will write 0110100000111001 in the groups of four bits, and then will write down the decimal equivalent of each group. = 0110 1000 0011 1001 6 8 3 9 Our required decimal number is 6839 4) Convert B2A16 to Octal (2 Marks) Solution: First we will convert B2A to Binary 1011 0010 1010 Now grouping into 3 bit 101 100 101 010 5 4 5 2 We will get 5452 5) Convert decimal number 3085 to hex Solution: 16 3085 16 192 – 13 16 12 – 0 16 0 – 12 12 0 13 C 0 D We will get C0D16
Deadline: Your assignment must be uploaded/submitted on or before 18th April, 2011

CS403 Assignment No. 2 Announced

Assignment No. 02

Semester Spring 2011

Database Management Systems-CS403

Total Marks: 15

Due Date: 25/04/2011

Objective: To learn and understand basic concepts of ER Diagram. 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 does not open or file is corrupt. o The assignment is copied (from other student or copy from handouts). o The assignment is in the format other than MS Word (doc). o Student ID is not mentioned in the assignment File or name of file is other than student ID. For any query about the assignment, contact at cs403@vu.edu.pk

Q Draw an E-R diagram for each of the following situations: a. A University has many departments whereas each department belongs to that particular university. That university has also many buildings whereas each building belongs to that particular university. The University also has many employees whereas each employee belongs to that particular university. Every employee has only one parking space whereas each parking space belongs to only one employee. Department offers many study programs whereas each programs offered by only a single department. 7.5 Marks b. In a shopping Store there are many supervisors whereas each supervisor belongs to one store. Product belongs to a single vendor whereas vendor provides so many products. Product belongs to a single category whereas category has many products. A category belongs to a single shelf in a store whereas a shelf may have more than one categories’ products.7.5 Marks

Guidelines / Instructions

It is required to draw Entity Relationship Diagrams for each of the upper situations using Chen’s notation. A sample can be found at http://en.wikipedia.org/wiki/Entity-relationship_model . It is also required to clearly mention that either the relationship is One-to-One, One-to-Many or Many-to-Many

Cs401 assignment no 1 spring 2011 idea solution

Suppose your computer has a processor with 24-bit address lines. What is maximum amount of memory that can be attached in your system? (Show the step(s) for calculation of maximum addressable memory) (2.5 marks)

b) How many address bits are required for accessing 1GB RAM? (Show the step(s) for calculation of required address bits) (2.5 marks)

Question No. 2:

What are the contents of memory locations 0151, 0152, 0153, ………….,0158 if 0151 is starting address for Label1. (1 mark for each location)

Label1: dw 8494

db 42

dw 54

dw 7500

db 01

Question No. 3:

a) Calculate physical address using the following segment offset pairs. (1 mark each)

00EA:02A4

0100:AA23

D3B8:F222

00A0:1234

8FEf:0FFF

b) What is effective address generated by the following instructions? Every instruction is independent of others. Initially bx = 0x0101, bp=0x0222, si=0x1234, var1=0x1771 (1 mark each)

mov ax, [bx+si]

mov ax, [bx+100] (100 is in decimal)

mov ax, [bp+si]

mov ax, [var1+bp]

mov ax, [si+var1]

CS610 Assignment No. 1 Solution

Q1. In which situation multiplexing is used? Explain with the help of working structure. Multiplexing is used for sharing of resources

1) Which cable is suitable for networking? Give reasons twisted pair 100baseT or 1000baseT

2) Which network Topology will be used with in the office and why?

star shaped bus

3) Which network Topology will be used for connecting two offices and why?

WAN

1) Which cable is suitable for networking? Give reasons LAN

4)Which network device will be used to connect two offices?

Fiber modem

for detail plz concerns hands out

:::::::::::::::::::::::

Under the simplest conditions, a medium can carry only one signal at any moment in time.

For multiple signals to share one medium, the medium must somehow be divided, giving each signal a portion of the total bandwidth.

Multiplexor (MUX)

Demultiplexor (DEMUX)

Sometimes just called a MUX

• Two or more simultaneous transmissions on a single circuit.

– Transparent to end user.

• Multiplexing costs less.

Frequency Division Multiplexing

Assignment of non-overlapping frequency ranges to each “user” or signal on a medium. Thus, all signals are transmitted at the same time, each using different frequencies.

A multiplexor accepts inputs and assigns frequencies to each device.

The multiplexor is attached to a high-speed communications line.

A corresponding multiplexor, or demultiplexor, is on the end of the high-speed line and separates the multiplexed signals

Time Division Multiplexing

Sharing of the signal is accomplished by dividing available transmission time on a medium among users.

Digital signaling is used exclusively.

Time division multiplexing comes in two basic forms:

1. Synchronous time division multiplexing, and

2. Statistical, or asynchronous time division multiplexing.

Synchronous Time Division Multiplexing

The original time division multiplexing.

The multiplexor accepts input from attached devices in a round-robin fashion and transmit the data in a never ending pattern.

T-1 and ISDN telephone lines are common examples of synchronous time division multiplexing

• Very popular

• Line will require as much bandwidth as all the bandwidths of the sources

CS601 Assignment No. 1 solution

Assignment No. 01

SEMESTER Spring 2011

CS601- Data Communication

Total Marks: 15

Due Date: 18/04/2011

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:

• The assignment is submitted after due date.

• The submitted assignment does not open or file corrupt.

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

• Student ID is not mentioned in the assignment File or name of file is other than student ID.

For any query about the assignment, contact at cs601@vu.edu.pk Marks: 20

Question 1: [5]

For six devices in a network, what is the number of cable links required for a mesh, ring, and star and bus topology?

Question 2: [5]

Draw a hybrid topology with a ring backbone connecting two bus backbones each bus backbone connecting three star networks.

Question 3: [5]

Suppose we want to build a small network in school building, which topology you will prefer and why? Explain your answer with solid reasons.

Solution:

Answer Question#1

Mesh Topology = 30 Cables
Ring Topology = 6 Cables
Star Topology = 5 Cables
Bus Topology = 7 Cables

Mesh Topology
n=6
n(n-1)

Star topology contain of 7 devices. 7th hub device.. but in this question, just asked for 6 devices, so for 6 devices 5 cables..

Bus topology have 6 links but cables are 7, 7th cable straight.

Question 3: [5]
Suppose we want to build a small network in school building, which topology you will prefer and why? Explain your answer with solid reasons.

Answer: For school network we will prefer the Star topology because it is efficient and fast. Lets see why we are preferring this topology in our school.

Explanation:
1. Easy to install
2. Easy to maintain as compare to other topologies
3. If we want to install a system it will take only 1 minute
4. Not costly as compare to other topologies
5. If a system is down our network will not diatribe as compare to bus and star topologies.

CS504 Assignment No. 1 solution

Q1 [Marks 10]

"During the construction of a motorway link road, for shifting an Interchange 5 Km ahead of its current location after it has already been built, it is going to be very costly. It could be easily fixed if realized earlier."

1) Create an analogy of the software development phases with above scenario.

2) Also mention the most suitable and worst phase (justify your answer with solid reasons in each case) for a "needed change" in case of software development regarding cost and efforts.

Q2 [10 Marks]

Draw the use case diagram of the following scenario

As System Analyst at Pakistan Railways, you need to model a Ticket Selling System for Terminal computers (TSSTC). Reading the Functional Specification of the system, you draw the following conclusions:

The main purpose of TSSTC is to use it for searching the "Train Timings" and purchasing the train tickets.

> TSSTC consists of touch screen as an interface between passenger and system, credit-card reader and a printer to print tickets.

> Each passenger uses available interface to search the available routs and train times from which he selects one train.

> After he selects the train, the terminal screen displays the available seats in that train.

> The passenger selects the seat and the system prompts the total fare.

> The payment is then made by credit card (using credit-card reader).

> The system confirms the payment. If the payment is not confirmed, system displays an error message and transaction is terminated.

> If the payment is confirmed, the ticket is issued and printed by the printer, from where the passenger collects his ticket.

SOLUTION:

IT430 Assignment No. 1 solution

Instructions

Please read the following instructions carefully before submitting assignment:
It should be clear that your assignment will not get any credit if:
o Assignment is submitted after due date.
o Submitted assignment does not open or file is corrupt.
o Assignment is copied.

Assignment

Question# 1 (3+7)
a) Consider an office environment in which we have 10 stand alone computers, one printer and one scanner.
Which topology is suitable for the given scenario? Support your answer with at least two reasons.

b) Write an HTML program that creates a table containing a list of Universities in Islamabad using ordered and unordered lists. Set the background color to green. Each University name should be liked with its particular website. By clicking on the University name it must lead the user to the respective University website e.g.http://www.au.edu.pk

A sample output will look like given below:

Question:2 (10)
Write an HTML program that divides the webpage in two frames with ratio of 25% and 75%. Assign the first frame to “Table of Contents” and the second frame to “Display area”. Attach another HTML document to the table of contents frame which will contain four hyperlinks named “About VU”, “How VU works”, “Organizational Structure” and “Board of Governors”. Attach four “.doc” files to these links in such a way that when user clicks the link, the target files should open in “Display area”.

::::::::::::::::::::::::::::::
SOLUTION:
::::::::::::::::::::::::::::::

List of Universities in Islamabad

Public Sector University	Private Sector University
Air University	Riphah International University , Islamabad
Allama Iqbal Open University	FOUNDATION UNIVERSITY , ISLAMABAD
Bharia University , Islambad	National University of Computer and Emerging Sciences
Quaid-i-Azam University, Islamabad
International Islamic University, Islamabad

REMEMBER, solutions which we provide you are JUST for your idea, NEVER submit to VU as it is, please do some changes before submission, otherwise, everyone who copied solution & submitted as it is, will be awarded zero marks

CS403 Assignment No. 5 Announced

Assignment No. 05

Semester Fall2010

Database Management Systems-CS403

Due Date: 03/02/2011

Q 1: Write SQL statements/queries for each of individual scenario given below from the given tables on the next page. 15 marks (3+4+4+4)

1. Create a simple view showing the names of employees whose designation is ”Instructor”

2. Create a view to list down employees name and designation of Computer sciences Department

3. Update view to change designation from instructor to lecturer of employee “Ali hassan”

4. Create a view to show number of courses student “VU

CS403 GDB Idea Solution

Just take the idea not copy paste

Question:-

When data is manipulated, the indexes have to be updated. This slows down data manipulation.

Answer:-

Search engine indexing collects, parses, and stores data to facilitate fast and accurate information retrieval. Index design incorporates interdisciplinary concepts from linguistics, cognitive psychology, mathematics, informatics, physics, and computer science. An alternate name for the process in the context of search engines designed to find web pages on the Internet is Web indexing. So doing all this operation indexes have to be updated which causes slow manipulation. Because this operation causes the index to be modified and requires additional updating of each index on that table, SQ L has to internally maintain the “pointers” to the inserted rows in the actual data file, each index potentially adds an alternative access path for a query for the optimizer to consider, which increases the compilation time.

IT430 GDB No. 1 solution

Graded discussion board
Dated: Jan 25, 11

Dear students,

A Graded Discussion Board for 'E-Commerce (IT430)' will be opened on Monday 31 January, 2011and it will be closed on Tuesday 01 February, 2011.

Discussion Topic

From consumers' point of view trust and satisfaction are two most important aspects of E-Commerce. In your opinion, which factors can be more critical to the internet consumer regarding trust on an E-Commerce portal?


Read the instructions carefully before sending your comments:


1. GDB will have weight-age of 5% of your total subject marks.
2. Your discussion must be based on logical facts.
3. You should post your comments on the Graded Discussion Board & not on the Regular MDB. Both will run parallel to each other during the time specified above.
4. Your comments should be relevant to the topic i.e. clear and concise (Maximum 5-8 lines answer).
5. Books, websites and other reading material may be consulted before posting your comments. (Do not copy the material as it is.)
6. No extra time will be given for discussion.
7. You cannot participate in the discussion after the due date or through e-mail.

SOLUTION:

As from the question we can see that two things are asked from us as E-commerce analyst that which one is most important priority vise. It is understood that if a internet consumer is going to purchase he/she first trust on the site after that the internet consumer will get the product and will be satisfied that this product is working fine for him/her. So most important is the trust. To get trust most of the sites use SSL certificate for security which helps and shows the credibility of the site its secure for the online payment. One more thing which is the VeriSign authentication services. So trust is more important as compare to satisfaction.