Web programming

1.) MySQL: a.) Write SQL commands to create a database called my_db (Imk) b.) Write SQL commands to create the following tables; ustomer (CustomerlD, Persons (PersonI , CustomerName, ContactName. Address, City. PostalCode. Country) (1mk) ID, LastName, FirstName, Address, City) (1mk) Tabot" o records into Customer table one of them should be a customer with CustomerName- and Country Cameroon" (2mks) b) Update Country of "Tabot" to "Nigeria" (Imk) d) Delete the entire records of "Tabot" from the database. (Imk) e) Pri int out the CustomerlD, CustomerName and PostalCode of the other customer (1mk) f.) Name three other popular databases you know (2mks) C1Omks) 2.) HTML: a.)Write a HTML program to design a form which should allow to enter your personal data Hint: make use of text field, password field, e-mail, lists, radio buttons, checkboxes, submit button) b) Write html code to generate following output. . Coffee . Teatck o Black Tea o Green Tea . Milk (10mks) 3.) CSS: a.) What is CSS and why is it important? (2mks) b.)Write code to create a horizontal navigation bar in CSS with the following menus; Home, News, About, Contact. (3mks) c.) Describe with examples the three ways of inserting a style sheet. (5 mks) (10 mks) 4.) PHP: a.) How do you write "Hello World" in PHP? (2mks) b.) Write a php loop that prints the numbers I to 5 on a web page. (3mks) c.) Write a php function that when call appends the given name of any individual (meaning must be passed as an argument in the function) to the name "Arreytambe". (Smks) (10mks) 5.) a.) Explain what is going on here (3mks); Sresult mysql_query(Ssql. Sdb_link) Snum-rows mysql_num_rows($result); echo "Snum_rows rows found" b.)What is the difference between char and varchar data types? (2mks) c.) What are the advantages and disadvantages of php and MySQL. (5mks) (10mks) Arreytambe Tabot GoodLuck guys!!! SECTION A: Objective - 20 points ts are executed by? (vi) Where in an HTML document is the correct place to re- fer to an external style sheet? (a) JS Interpreter (b) JavaScript Virtual Machine eBrowser (d) Compiler Cheader> section cbody> section (a) chead> section (d)