Note: You are currently viewing documentation for Moodle 2.0. Up-to-date documentation for the latest stable version is available here: Database activity module.

Database activity module: Difference between revisions

From MoodleDocs
Main page ► Managing a Moodle course ► Activities ► Database activity module
Activities
No edit summary
(relocated screenshot)
 
(69 intermediate revisions by 24 users not shown)
Line 1: Line 1:
{{Databases}}
{{Activities}}{{Improve}}
{{Moodle 1.6}}


Moodle's '''Database Activity Module''' is an activity which allows the teacher to define a structured format for information - a set of fields. Teachers and/or students can then contribute to the "database" and build up a collection of structured records.
The database activity module allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.  


:(Technically, a single instance of the database activity module is more like a single ''data table'' than a whole ''relational database''.)
[[Image:Databaseexample.png]]


For example, one activity might ask students to contribute pictures they have created. The activity would need a "picture" field but could also have a "title" field and a "description" field. The teacher could decide to allow participants to add comments to each others' contributions, or even to rate them.
* [[Database activity settings|Database settings]]
* [[Building Database]]
* [[Using Database]]
* [[Database activity FAQ]]




:'''''Note:''' Please don't confuse this activity type with Moodle's underlying database, which stores all of the information used in Moodle activities.''
This module will create one table per instance, but you may create as many instances you need. The records can be linked to other tables and all resources in the course, if you allow autolink in a name field, but you cannot build a SQL query.  


[[Category:Teacher]]
The table is not created in the SQL database, it is just stored there in lines of other SQL tables (mdl_data*).
 
[[de:Datenbank]]
[[es:Base_de_datos_%28m%C3%B3dulo%29]]
[[eu:Datu-basea]]
[[fr:Base de données]]
[[cs:Modul Databáze]]
[[ja:データベースモジュール]]
[[ru: База_данных]]

Latest revision as of 13:49, 30 September 2011

This page really needs improving. Please see the page comments for suggestions of what to include, then remove this template when you're done.


The database activity module allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.

Databaseexample.png


This module will create one table per instance, but you may create as many instances you need. The records can be linked to other tables and all resources in the course, if you allow autolink in a name field, but you cannot build a SQL query.

The table is not created in the SQL database, it is just stored there in lines of other SQL tables (mdl_data*).

Retrieved from "https://docs.moodle.org/20/en/index.php?title=Database_activity_module&oldid=90832"
Powered by MediaWiki