| || |
On successful completion of the module, students should be able to:
- Understand, evaluate and create algorithms; design and write structured programs; compile programs; debug runtime errors; select and use appropriate programming structures.
- Select and implement appropriate data types; identify major DBMS functions and describe their role in a database system; prepare a relational schema from a conceptual model developed using the entity- relationship model.
- Demonstrate use of the relational algebra operations from mathematical set theory (union, intersection, difference, and Cartesian product) and the relational algebra operations developed specifically for relational databases (select (restrict), project, join, and division); demonstrate queries in the relational algebra; use a declarative query language to elicit information from a database; write programs that execute queries and use results within an application.
- For each of the layers in the TCP/IP reference model explain their implementation, functions, common protocols and data structures; discuss the techniques that can be used to share network resources.
- Explain how IP addresses can be assigned to hosts using sub netting and super netting, and will be able to identify situations in which these are appropriate solutions; set up a web server and provide simple web services.