Scenario: It is the OLTP database of a company name Ahmad Coverall Pakistan that takes orders from the customers and forwards these orders to the suppliers. Suppliers fulfill the order of the company and delivered the product. Company received the delivery and noted number of units sent by the vendor. Company verifies the delivery after [...]
Archive for the ‘Assignments’ Category
Assignment (30) Draw the snow flake schema with possible hierarchies of the above scenario Sales System In England Mr. Zaid has chain departmental stores with headquarters at London. Salesmen deal different type of products; the products are identified by their Id, name, description, category name. In category they also store the CatogeryDescription. In his stores [...]
Assignment Part (i): (25) Draw an ER Diagram for flight Reservation System. Draw the Complete ER diagram of above scenario by illustrating the diagram with attributes of the entity and relationship. Part (ii): (25) Translate the ER diagram to a relational data model identifying the relational schemas, attributes, primary keys and foreign keys. Flight Reservation [...]
Assignment Design a normalized database for Students. One non-normalized way to represent this data is with the following single table with given fields. You normalized the table up to 3rd Normal Form. Students Sid First Name Last Name Blood Group Major Domicile Province 2006-56 Irfat Ali A+ Pre-Medical Lahore Punjab 2006-05 Nadeem Zafar A+ Pre-Engineering [...]
a. Show the shortest form of the following IPV6 address: 2340:1ABC:119A:A000:0000:0000:0000:0000 b. Show the original (unabbreviated) form of the following IPV6 address: 0:AA::0 c. In IP datagram header format, what is the value of the data field given H.LEN value of 12 and TOTAL LENGTH value of 40,000? d. What are the main advantages of [...]
Q.1 What is gratuitous ARP? [3] Q.2 Find the net ID and host ID of the following IP Addresses. [8] a) 117.34.4.8 b) 29.34.41.5 c) 23.67.12.1 d) 139.33.4.5 Q.3 Find the class of the following IP Addresses. [4] a) 218.34.54.12 b) 238.34.2.1 c) 124.34.2.8 d) 139.14.6.8 Solution: Spring 2009_CS610_4_SOL
Spring 2009_CS610_3 Solution: Spring 2009_CS610_3_SOL
Q#1 Draw an example of ‘Cycle of Bridges’ with the segments below: [5] Q#2 Answer the following questions: i. If we can extend the LAN then why we need a WAN? [3] ii. How can a bridge know whether to forward frames? [2] iii. Can the length of an Ethernet be increased to many [...]
Question 1 (Marks: 3+4+3) Answer the following questions: Explain what might happen if two stations are accidentally assigned the same hardware address? If sharing reduces cost, why are shared networks used only for local communication? Why wireless LAN can not use the same CSMA/CD mechanism that Ethernet uses Question 2 Complete given table and answer [...]
Q1. Suppose an ISP has class C address i.e. 193.5.48.0. If the ISP has three customers with only six computers each, then what IP addresses are assigned to three customers by using classless addressing? [10] Q2. What are two standard implementations to improve the computational efficiency in address resolution with table lookup? [...]
Q1. See the fig given below and complete the entries of the Next Hop in the table ? Q2. What are the differences between static and dynamic routing? (10) Spring 2008_CS610_3 Solution: Spring 2008_CS610_3_SOL
Q1. Provide 5 IEEE standards, describing in maximum 5 line (diagram can be provided) e.g. IEEE 802.2 LLC. [10 Marks] Q2. What tools can be used to monitor and debug performance of a network, give example of these tools. [5 Marks] Q3. What is the difference between host and end system? List the types of [...]
Question # 1 (Marks: 10) Answer the following questions: a. What sort of information difference that is provided when the ping and trace route commands are executed in the command prompt. Using Ping to measure the round-trip times to destinations on the Internet (e.g., to Web sites).What is the maximum round-trip time you encounter? b. [...]
Question#1 (Marks 10) What are major problems in User Datagram Protocol (UDP) due to which we need Transmission Control Protocol (TCP)? How does Transmission Control protocol (TCP) achieve reliability? What are the main advantages of IPV6 over IPV4? Can a router in the global Internet use static routing the same way a host does? Question#2 [...]
Question#1 (Marks 10) Suppose an ISP has class C address i.e. 193.5.48.0. If the ISP has three customers with only six computers each, then what IP addresses are assigned to three customers by using classless addressing? Question#2 (Marks 10) What is chief advantage of using virtual packets instead of frames? What happens if a [...]
