DATABASES AND INFORMATION SYSTEMS
Learning outcomes of the course unit
The course offers an introduction to business Information Systems, both on fundamental and on technological aspects. Contents are mainly related to computer networks, distributed systems security and to the use and design of databases.
Course contents summary
HW/SW for computer systems
Types of computers systems. Main hardware components of computers. Key concepts and behavior of Operating Systems.
Computer networks and Internet
Introduction to Computer Networks. OSI model. Transmission media. LAN. IEEE 802 and Ethernet. Internetworking. Architecture of TCP/IP. Internet applications. Application level protocols. HTTP. Elements of HTML and XML.
Security of distributed systems: key concepts. Symmetric and public-key cryptography. Digital signatures. PGP. Secure Socket Layer. Firewalls.
Part 2 - Databases
Introdution to Business Information Systems. The relational model.
Relational algebra. SQL query language. Scheme declaration. Simple and complex queries. Privilege.managements Constraints, procedures and active rules.
Database design. The Entità-Relationship model. ISA hierarchies. Design strategies and restructuring of schemes. Logical relational design. Access structures in DBMS and the cost of data access.
Transational systems and concurrency control. Data analysis.
Web access to databases.
The CGI protocol . Technologies for the integration between databases and Web.
Ullman and Widom, A First Course in Database Systems , (Prentice-Hall, 1999).
Andrew Tanenbaum, Computer Networks (fourth edition), Prentice Hall, Upper Saddle River, NJ, 2003, ISBN 0-13-038488-7.
W. Stallings, Cryptography and Network Security: Principles and Practice (3rd Edition), Prentice Hall; 3 edition (August 27, 2002).
Exercises in the “Gestionale Lab” on LAN equipment and TCP/IP software and network applications.
Exercises on HTML/XML. Introduction to Access. Exercises on Access: table creation and SQL queries.
Midterm written test on the first part of the course (HW/SW, networks and security).
Final written exam on the design (E-R) and use (SQL) of a relational database .