ome Orade sQl to create a table (table name must be vour last first name (e.g, Kwang Lee -> KLEE). The table must include following columns (fields): CWID .Name -. Date of Birth . Address . Etc Then copy the screen shot (code and result) and insert here (10 points). 2. Insert columns (School, Department) into the table and delete a column (Etc) from the table. Then copy the screen shot (code and result) and insert here (10 points). 3. Insert at least three virtual data (you and your two friend data) into the table and list the students name, CWIID, and Address who are Computer Sclence Department. Then copy the screen shot and result) and insert here (10 points). who are Computer Science Department. Then copy the screen shot (code 4. Using Oradle SQL to create another table (table name DEPT). The table must indude following columns (fields): CWID Name -. Class name -, Grade Insert at least three virtual data (you and your two friend data) into the table and display the form using "Views" command. Then copy the screen shot (code and result) and insert here ( points). 0 5. Containing two tables relation, then identify a primary key and a candidate key. List the students name, class name, grade, and address where the students' age is over 5 years using the relational commands. Then copy the screen shot (code and result) (20 points). 6. Consider the following relational database for Happy Cruise Lines (See the attached file). It keeps track of ships, cruises, ports, and passengers. A "cruise" is a particular sailing of a ship on a particular date. For example, the seven-day journey of the ship Pride of Tampa that leaves on June 13, 2003, is a cruise. Note the following facts about this environment (40 points). - Identify the primary key and any alternate keys of each relation (20 points). . Using the informal relational command language described in this chapter, write commands to: (30 points) what was the gross weight of the ship used for cruise number 394827 a List the home address of every passenger on cruise number 17543. Relational Database Concepts kumari do Assignments. Spring 2019| :. Assignment 02 (1)pdf file:///C/Users/siva%20k mari%20yada X + AppData/Local Packages MicrosoftMicroso Edge Oekyb3dbbe/T Q1) List five nonproprietary Internet applications and the application layer protocols that they use 02) What is the difference between network architecture and application architecture? Q3) For a communi cation session between a pair of processes, which process is the cient and which is the server? Q4) For a P2P file-sharing application, do you agree with the statement, "There is no notion of dlent and server sides of a communication session"? Why or why not? Q5) What information is used by a process running on one host to identify a process running on another host? Q6) Suppose you wanted to do a transaction from a remote client to a server as fast as possible. Would you use UDP or TCP? Why? Q7) List the four broad classes of services that a transport protocol can provide. For each of the service classes, Q8) Recall that TCP can be enhanced with SSL to provide process-to-process security services, including indicate if either UDP or TOP (or both) provides such a service. encryption. Does SSL operate at the transport layer or the application layer? If the application developer wants TCP to be enhanced with SSL, what does the developer have to do? What is meant by a handshaking protocol? Why do HTTP, FTP, SMTP, and POP3 run on top of TCP rather than on UDP? Consider an e-commerce site that wants t this can be done with cookies. 09) Q10) Q11) Q12) Describe how Web caching can reduce the delay in receiving a requested object. Will Web caching reduce Q13) Telnet into a Web server and send a multiline request message, Include in the request message the If 014) Why is it said that FTP sends control information "out of band"? the delay for all objects requested by a user or for only some of the objects? Why? modified-since: header line to force a response message with the 304 Not Modified status code Q15) From a user's perspective, what is the difference between the download-and delete mode and the download-and-keep mode in POP3? What is an overlay network? Does it include routers? What are the edges in the overlay network? Q16) 17) For the client-server application over TCP, why must the server program be executed before the client program? For the client server application over UDP, why may the client prog am be executed before the server program? What is the difference between MAIL FROM: in SM How does SMTP mark the end of a message body? How about HTTP? Can HTTP use the same method as SMTP to mark the end of a message body? Explain. TP and From: in the mail message itself? Q18) Q19) 20 n overlay network with N actie peers, with each pai f peers nineg an athe 1P connection Additionally, suppose that the TCP connections pass through a total of M routers. How many nodes and edges are there in the corresponding overlay network? 853 PM ch