DBS-14.5: BUSES number(11) BUS NO BUS_NAME varchar2(20)e TYPE SCHEDULE SCHEDULE ID TRAVEL DATE SOURCE DESTINATION varchar2(20)t P BUS NO DURATION varchar2(3) date d varchar2(20)t varchar2(20) TOTAL SEATS number(11) AVAIL_SEATS number(11) BUS NO number(11) number(11) PAYMENTS DISCOUNTS varchar2(3) PAYMENT_ID varchar2(3) t varchar2(3) number(11) P DISCOUNT_ID varchar2(3) TICKET ID BO P TICKET ID DISCOUNT_ID DISCOUNT AMOUNT number(11) PBD_ID DISCOUNT ID TICKETS varchar2(3) P SCHEDULE ID varchar2(3) number(11) number(11) O number(11) TICKET ID HEDULE ID FARE USER ID PUSER ID NO SEATS USERS USER ID number(11) NAME primary kay - not nul varchar2(20) el foreign kay | data type - nunber a| data type - date le| data type - varcha2 ADDRESS varchar2(100) t PHNO EMAILID varchar2(30) e number(11) CANCELLATION CANCELLATION_ID varchar2(3) OP TICKET ID P BD ID TICKET ID BOOKINGDETAILS varchar2(3) number(11) BD ID number(11) ACC_NO number(11) NAME varchar2(10) t PUSER ID number(11) ustR_ID Cosider the above given relational database model of Ticket Booking Application to develop an SQL to schedule id, source, destination and travel time which having the maximum travel time and sort it in the order of schedule id.

Q: Q3)For each the following address , give the 1st host address, last host address ,network address…

A: As per our company guidelines we can answer only one question. Please post the other question…

Q: Routers, bridges, and gateways only allow data traffic through itself when data are intended for…

A: Routers, bridges and gateways are usually configure in the network to stablish a communication…

Q: QUE STION 3 Traffic Padding makes traffic analysis easier. O True False

A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: Perform FLSM, take a network address generated from your student id (method mentioned above) and…

A: Since you have asked multiple questions, according to the company's policy we will solve the first…

Q: An ISP is granted a block of addresses starting with 129.80.0.0/16. The ISP wants to distribute…

A: Actually, given information..  An ISP is granted a block of addresses starting with 129.80.0.0/16.

Q: What is a segmentation fault and page fault? Also briefly explain the difference between the…

A: Segmentation Fault: In computer science, a segmentation fault can be defined as a case of access…

Q: In DNS recursive query the Local DNS server first checks the DNS root then The Local DNS server…

A: In DNS recursive query the Local DNS server first checks the DNS root then the local DNS server…

Q: Assume a direct-mapped cache that holds 4096 bytes, in which each block is 16 bytes. Assuming that…

A: Total cache size = 4096 bytes                           = 212 bytes Block size = 16 bytes…

Q: 1 . One of the responsibilities of the Controller in MVC is to Select proper Models for Views  True…

A: 1.True. 2.False 3.True 4.True

Q: In MS Access, what kind of data will be accepted into database using theinput mask \A\S\…

A: Input mask:Input mask is used to specify what kind of data it will take in database. These are some…

Q: Refer to the exhibit. What is the default gateway address for host A 192.168.1.0/24 254 33…

A: default gateway address for host A is

Q: Perform the matching below to indicate the datagram field value and type at point (a). [Note: You…

A: We are going to see how an IPv6 version packet will reach to destination which crosses through a…

Q: BUSES number(11) BUS NO BUS NAME varchar2(20)t TYPE SHEDULE PSOEDULE ID TRAVEL DATE SOURCE…

A: SQL is a domain-specific language used in programming and designed for managing data held in a…

Q: For each access shown above, list: Whether the access is a hit or miss in the TLB Whether the…

A: Page Size=4KiB ==> Page Offset = 12 bits 1. 0x123D Page Offset=0x23D Page Number=TLB tag= 0x1…

Q: 2 B- 5 <?php // Variable to check = "2001:0db8:85a3:08d3:1319:8a2e:0370:7334"; Sip e // Validate…

A: It is defined as Hypertext Preprocessor (PHP) is a programming language that allows web developers…

Q: RouteID RouteStartPoint RouteEndPoint RouteDrivingTime ScheduleDate ScheduleDepTime ScheduleArrTime…

A: Normalization is the process to reduce the redundancy of the data. Data is store logically in the…

Q: The physical address: Select one: O a. network independent O b. uses columns in it's representation…

A: Given:

Q: Why do switches flood frames addressed to unknown destinations?

A: In this case, we have to find the reason why the switches flood frame to an unknown destination.

Q: The CSM Tech organization has a substantial web presence with several publicly accessible web and…

A: The public Domain Name System (DNS) servers are running recursive queries for both the internal and…

Q: HTTP can deliver any type of data Select one: O True O False

A: HTTP: It is basically a normal method to encode and transfer all the data from/to client and…

Q: HTTP can deliver any type of data Select one: O True O False

A: HTTP is a Hypertext Transfer Protocol which is used to send and receive hypertext html documents but…

Q: In the following network traffic, the response is not expected. Why?       Question 3 options:…

A: The answer has given below:

Q: Q18. Draw the single call routing diagram between people with following telephone numbers given in…

A: Answer:-

Q: A 4000 octet user data is to be transmitted over a network which supports a maximum user data size…

A: Given that MTU is 536 octets and header size is 20 octets Therefore, the maximum length of data that…

Q: Number of hosts in the block 20.30.50.0 /22 is а-1024 b- 2024 С- 1048 d- non of the previous

A: Number of host = 2(32 - Given bits for mask) - 2

Q: In networks using CSMA/CD, there is a chance of collision O False True The frame contains a Header…

A: I have answered all the 4 parts and have provided necessary explanations with them.

Q: This system is a monitoring system which manages the transports of UHB’s buses, and the system is…

A: use case diagram is given below for the above description.

Q: YOU CAN CONNECT TO AWS SERVICE INSTANCES USING THEIR______ ADDRESSES.

A: AWS(amazon Web Services)  instances can be connected by using the SSH(Secure shell) key and will…

Q: Source DI MS Factor ? ? 115.1387 3.698 ? Block ? ? 72.1750 Error ? ? ? Total

A:

Q: In a particular DNS resource record(RR), if Type= NS, then Name and Value fields indicate…

A: Ans: In a particular DNS resource record(RR), if Type= NS, then Name and Value fields indicate:  b)…

Q: This header may be used to determine if a cached page has been modified since it was last accessed.…

A: Introduction: A client or server may send a variety of instructions in requests or replies through…

Q: 14. and is used by a process running on one host to identify a process running on another host.

A: Lets discuss the solution in the next steps

Q: For each host address below,find the number of subnet bits , number of host bits, number of subnet…

A: Answer of number of subnet bits host bits subnets and hosts is in step2.

Q: HTTP/1.1 200 ОK\rn Date: Sun, 26 Sep 2010 20:09:20 GMT\r\n Server: Apache/2.0.52 (CentOS)\r\n…

A: Refer to step 2 for the answer.

Q: 12- IP address resolution works by retrieving the domain name based on a given IP address. True…

A: Lets see the solution.

Q: The CSM Tech organization has a substantial web presence with several publicly accessible web and…

A: The public DNS servers are running recursive queries for both, the internal and external clients…

Q: a. Referring the TEACHER table and SUBJECT table, identify and write the correct answer in the…

A: PRIMARY KEY : A key uniquely use to identify each entity in a table is called PRIMARY KEY. A primary…

Q: Response time: is the waiting time of packets in service queue in addition to their servicing time.…

A: The solution to the given problem is below.   ***Note: According to Bartleby policy we are not…

Q: Servicing requests strictly according to deadline using EDF may result in : a. lower seek times b.…

A: What is seek time first we need to understand.  The time taken to locate a piece of information in…

Q: A: 320 hosts; B: 205 hosts; C: 120 hosts; D: 60 hosts; E: 47 hosts

A: An organization has been assigned the prefix 202.9.11.0/22 and it wants to form subnets for five…

Q: It uses the default route to illustrate the path to any network which does not have more specific…

A: Task :- Choose the correct option for given question.

Q: Client (Shahid) 198.150.11.34 FE:ED:F9:44:45:66 Client (Khalid) 198.150.11.163 R1 R2…

A: IP Address and MAC Address "-  R1  IP =192.150.11.33 MAC = DD:EC:BC:AB:04:AC R2 IP = 198.150.11.61…

Q: What is horizontal fragmentation

A: Horizontal fragmentation is the process of dividing a table horizontally by assigning one or more…

Q: 22. Checksum, as used in the transport layer, can detect all errors. a. True b. False

A: Note: As per the bartleby policy we can answer single question at a time if you want the solution of…

Q: Refer to the below Figure Calculate number of Collision & Broadcast Domain, and circle all the…

A: Collision Domain: it is the set of devices where the frames will collide, it is the network  segment…

Q: UDP and TCP segments have a fixed size of payload field. A True B) False

A: Lets see the solution in the next steps

Q: Computer Network Fundamentas1 Class Arranged By Dr.Ahmed Chalak Shaki 18 255.255.255.192 /26 262144…

A: As multiple question is given we are allowed to answer only one question if you want answer of…

Q: b) Please continue to fill the next blank below to display all the IP addresses as shown below $…

A:

Q: Write a report on OpenFlow 1.2 additions, 1) Extensible match support 2) Extensible SET_FIELD packet…

A: the answer is given below:-

Q: 1. Admin Office - 30 addresses ii. IT Dept - 20 addresses iii. Warehouse - 10 addresses iv. Graphic…

A: Here the given IP address is 192.168.1.0/24 /24 means number of network bits is 24 which means…