The course is going to present basics on database analysis and design. Also, students will be provided with tools and programs to implement databases. We will discuss the general methodology to create databases on PCs and on the Web, including query language and desgin techniques. At the end of this course, students will be able to design and create databases.
The course aims at covering basics on database design and providing students with the needed capabilities to create and manage databases for network applications.
The students will acquire an adequate level of knowledge and capabilities in understanding database analysis and design.
The students will be able to apply acquired notions and wil have problem solving capabilities in the field of database and database management systems.
Active lectures Laboratory activities
Data and information Information management Information management systems Database and database management systems Entity-relationship analysis Logical and conceptual data models From analysis to design Database implementation Relational algebra SQL language Database in a client/serve architecture with PHP/MySQL Hands on laboratory
Teacher.
R.A. Elmasri, S.B. Navathe, Fundamentals of Database Systems Ed. Pearson, 2016.
Ricevimento: Before and after lectures, at the Savona Universtity Campus. On appointment, at the Savona University Campus or at the Department DIBRIS in Genoa.
MAURO COCCOLI (President)
GIOVANNI ADORNI
GIANNI VIARDO VERCELLI
October 3, 2016.
DATABASES AND INFORMATION SYSTEMS
Quizzes and project work.
The quizzes aim to proving that the students have become proficient in database theory and have acquired analysis skills.
The project work aims to proving that the students have acquired database design capabilities and skills in using database management system programs.