Modulo Clil

Database

Domande di riepilogo modulo CLIL sui database

slide_Database.png
  • What are data?

Data are facts related to the object in consideration. For example: age, name, height, weight of a men but also pdf, picture, ecc.

  • What is a database?

A database is a systematic collection of data. It is important to remember that data in a database are organized in a easy and simple way but at the same time a database can store information and relationships that are more complicated than a simple list

  • What is the purpose of a database?

There are three purpose: storing data; providing an organized structure for data; providing a mechanism for querying, creating, modifying and deleting data. It is not the same of a simple list.

  • What is DMBS? What it can do for us?

A DMBS is formed by a collection of programs that serve as an intermediary between the user and the database. It can create, process and administer the database and at the same time, it controls access to database. So it can CREATE databases, READ database data, MODIFY database data, MAINTAIN database structures, ENFORCE rules, CONTROL concurrence, PROVIDE security, PERFORM data backup and recovery

  • What is SQL?

SQL is the contraction for STRUCTURED QUERY LANGUAGE, and it is an international standard language for creating, processing and querying databases and their tables

  • What type of DBMS are there?

There are four type of DBMS: Hierarchial DBMS, Network DBMS, Relational DBMS and Object Oriented DBMS.

  • Describe a Hierarchical DBMS

Hierarchical DBMS is a type of DBMS that supports parent-child relation in storing data. It is structure like a three, in which knots are records and branches are information (data). This type of DBMS is not used a lot these days

  • Describe a Network DBMS.

Network DBMS is a type of DBMS that supports "many to many" relationships (every object shares a lot of information). With this kind of DBMS, we can create a complex database structure.

  • What is a Relational DBMS? Make an example.

A Relational DBMS is a kind of DBMS that define database relationships in form of tables. This kind of DMBS doesn't support "many to many" relationships

  • Give an example of a DBMS type and describe it.

See previous answers or maybe you could describe an OBJECT ORIENTED RELATION DBMS

  • What is the most popular type of DBMS?

The most popular type of DBMS is RELATIONAL DBMS

  • Make an example of an Application where we use DBMS.

An application where we use Database Management Systems is Facebook. In fact, users enter their data, then Facebook process data. Another example, is banking system but also ARGO.

  • Does a database contain only the data that we have put into it? What is metadata?

No, it doesn't. In fact a database also contains metadata which describe our data. But it also contain overhead data (tables of data used to improve performances) and application metadata (data values used by the application which rely upon the database.

  • How many kind of data abstraction are there? What are their names?

A level of abstraction is equal to hide the complexity of data form the basic user. There are three kind of abstraction: PHYSICAL LEVEL, LOGICAL LEVEL and VIEW LEVEL

  • Describe the VIEW LEVEL of abstraction.

View level is the highest level of abstraction, it describes the user interaction with database system. At this level, user just interact with system using the GUI

Un video riassuntivo (in inglese) del programma svolto nel modulo clil si trova qui

Puoi inserire le risposte alle domande proposte ma anche altre domande inerenti all' argomento

N.B.: Sia le risposte che le domande possono contenere errori grammaticali!!

stock-photo-database-concept-in-word-tag-cloud-on-white-background-157231454.jpg
Salvo diversa indicazione, il contenuto di questa pagina è sotto licenza Creative Commons Attribution-ShareAlike 3.0 License