INTRODUCTION TO CODING AND DATABASE TECHNOLOGY MOD.1

Academic year
2020/2021 Syllabus of previous years
Official course title
INTRODUCTION TO CODING AND DATABASE TECHNOLOGY MOD.1
Course code
FM0535 (AF:338862 AR:179781)
Modality
On campus classes
ECTS credits
6 out of 12 of INTRODUCTION TO CODING AND DATABASE TECHNOLOGY
Degree level
Master's Degree Programme (DM270)
Educational sector code
INF/01
Period
1st Term
Course year
1
Where
VENEZIA
Moodle
Go to Moodle page
The course aims at providing students a better understanding of the nature of relational databases by assembling and subsequently analysing a database from printed sources and pre-existing tables.
By the end of the course the students will have acquired:
- Basic knowledge of SQL
- Knowledge and understanding database normalization
- Ability to judge the organization of existing databases
- Ability to apply this knowledge to devise complex searches
Basic knowledge of cataloguing and spreadsheets.
Work will start from printed catalogues and pre-existing tables. By gradually assembling and organizing these into a database we will introduce the principles of normalization and query languages. The final result will be a complex relational database and data model. For didactic purposes we will use MS Access or Base for visualisation.
Morgan Kaufmann, SQL Clearly Explained, 2010, ISBN 0-12-375697-9 (online version provided by the university library).
Ron Mcfadyen, Relational Databases and Microsoft Access, Winnipeg 2016 (Open Textbook Library).
There will be regular assignments. The exam of the course will be a project about a SQL database created by the student on a given task. Participants may at any time ask for a project by emailing holger.essler@unive.it. Once they receive the detailed instructions on the project, they have 14 days to submit the result. The (partial) vote will be averaged with the result of mod. 2.
The first 12 and the penultimate 6 hours will be carried out in the conventional way (in presence with live streaming online), the 12 hours in between will be according to the switched classroom method (asynchronous), using moodle. Active participation of the students is required as mentioned above in the Contents. Attendance of the first twelve hours is strongly recommended.
English
written and oral
Definitive programme.
Last update of the programme: 19/10/2020