COMPUTER SKILLS FOR BUSINESS
ABILITÀ INFORMATICHE PER L'IMPRESA
Analysis and management of databases
Analisi e gestione delle basi di dati
| A.Y. | Credits |
|---|---|
| 2020/2021 | 2 |
| Lecturer | Office hours for students | |
|---|---|---|
| Stefano Russo |
Assigned to the Degree Course
| Date | Time | Classroom / Location |
|---|
| Date | Time | Classroom / Location |
|---|
Learning Objectives
Know the main tools for the development and creation of databases and web pages.
Basic skills for creating databases and web pages.
Program
Database creation (20 ore)
1. Information data, information systems
2. Design of a database
3. Conceptual design
4. The relational model
5. Define the database using the relational model (logical design)
6. Create a database with MS-Access
7. Create a database with MySQL
8. How to set up database with Excel
9. Database functions in Excel
Bridging Courses
No prerequisites.
Learning Achievements (Dublin Descriptors)
In relation to the teaching of computer science, the student must show possession of the:
Teaching Material
The teaching material prepared by the lecturer in addition to recommended textbooks (such as for instance slides, lecture notes, exercises, bibliography) and communications from the lecturer specific to the course can be found inside the Moodle platform › blended.uniurb.it
Supporting Activities
Any additional lessons and / or seminars.
Teaching, Attendance, Course Books and Assessment
- Teaching
Lectures and computer lab activities.
- Attendance
Frequency is recommended.
- Course books
- S. Russo-G. Chiriatti, Laboratorio basi di dati: introduzzione ad Access e MySQL, per le Scienze Umanistiche e Sociali, Edizioni Nuova Cultura, Roma, 2020 (in corso di stampa).
- Assessment
Oral exam and yests with multiple-choice questions.
- Disability and Specific Learning Disorders (SLD)
Students who have registered their disability certification or SLD certification with the Inclusion and Right to Study Office can request to use conceptual maps (for keywords) during exams.
To this end, it is necessary to send the maps, two weeks before the exam date, to the course instructor, who will verify their compliance with the university guidelines and may request modifications.
Additional Information for Non-Attending Students
- Teaching
Individual study on texts and specific materials reported .
- Attendance
No obligation.
- Course books
1) S. Castano, A. Ferrara, S. Montanelli, Informazione, conoscenza e Web - per le scienze umanistiche, Pearson, 2009 [ISBN9788871925486]
Capp. 1 (pp. 1-5); 3 (pp.15-24); 4 (pp. 25-38); 5 (pp. 39-44); 6 (pp. 45-76); 8 (pp. 77-92); 9 (pp. 93-102); 11 (pp-113-120)
2) Paolo Sordi, Progettare per il Web, Carrocci editore, Roma, 2013 [ISBN9788843070060].
- Assessment
Oral interview and / or possible written exam by means of multiple choice question type, multiple answer, true or false affirmation, open answer, association of words, personalized question (total 35 questions) and / or possible exercises to be performed. The time for the eventual test will be thirty minutes. Eligibility will be achieved by answering exactly 75% of the questions.
- Disability and Specific Learning Disorders (SLD)
Students who have registered their disability certification or SLD certification with the Inclusion and Right to Study Office can request to use conceptual maps (for keywords) during exams.
To this end, it is necessary to send the maps, two weeks before the exam date, to the course instructor, who will verify their compliance with the university guidelines and may request modifications.
Notes
Non-attending students are advised to practice following the examples provided by the study texts and in the didactic materials present in the following Blended Learning Uniurbal platform lik: https://blended.uniurb.it/moodle/
| « back | Last update: 17/05/2021 |
