Note: You are currently viewing documentation for Moodle 3.9. Up-to-date documentation for the latest stable version of Moodle may be available here: Database activity.
The Database activity 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.
The '''Database 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. You may be familiar with similar technology from building Microsoft Access or Filemaker databases.
{{MediaPlayer | url = https://youtu.be/HkKUojvm6Ag | desc = Overview of the Database activity}}
==How is it set up?==
#In a course, with the editing turned on, choose 'Database' from the activity chooser.
#Give it a name and, if needed, a description.
#Expand the other sections to define the settings you want, in particular the Entries section.
#Click Save and Display
#Create a new field from the dropdown, repeating as necessary, or click the link choose a defined set to import an existing preset.
#Click the Templates tab to edit and save templates. For more help, see [[Database templates]]
==How does it work?==
===Student view===
Students click on the Database icon in the course to access it and add an entry.
:'''''Note:''' Please don't confuse this [[Adding resources and activities | activity type]] with Moodle's underlying SQL database, which stores all of the information used in Moodle courses and is only of interest to Moodle [[Administrator documentation | Administrators]].''
They can usually see entries individually (View single) and in a list (List view) and are able to search entries.
===Teacher view===
Teachers additionally see the set up tabs and can edit,delete, approve/unapprove entries as required.
* The first task is to [[Adding/editing_a_database|add the database]]. You will be asked to give it a name, provide some text explaining its intended purpose to users and set a few other options.
* Next you define the kind of [[Database fields|fields]] that define the information you wish to collect. For example a database of famous paintings may have a picture field called ''painting'', for uploading an image file showing the painting, and two text fields called ''artist'' and ''title'' for the name of the artist and the painting.
* It is then optional to edit the [[Database templates|database templates]] to alter the way in which the database displays entries.
* Note that if you later edit the fields in the databases you must use the Reset template button, or manually edit the template, to ensure the new fields are added to the display
* Finally the [[Teacher]] and/or [[Students]] can start entering data and (optionally) commenting on and grading other submissions. These entries can be viewed alone, viewed as a list or searched and sorted.
==Database and Roles==
Since Moodle 1.7 a number of options in Database have been migrated over to the Roles system. For example, preventing students (or any other role) submitting data must be done by overriding the role for that particular instance of the Database. However, do note that by default teachers are unable to override roles and this ability must first be granted by your Administrator for the course or site as appropriate.
== Example databases ==
Moodle.org has three good examples of the database module in action:
* [http://moodle.org/mod/data/view.php?id=6140 Moodle Buzz], a database of the titles, authors and web links to news articles mentioning Moodle
* [http://moodle.org/mod/data/view.php?d=26 Themes], a database with screenshots, download links and user comments about Moodle [[Themes|themes]]
* [http://moodle.org/mod/data/view.php?d=13 Modules and plugins], a database containing a variety of web links (download, documentation, discussion) and info (maintainer, module type, requirements) about the modular components of Moodle, including those created by third parties.
== Creative uses ==
You could use the database module to:
* allow collaboration on building a collection of web links/books/journal references related to a particular subject
* display student created photos/posters/websites/poems for peer comment and review
* gather comments and votes on a shortlist of potential logos/mascot names/project ideas
* provide a [http://moodle.org/mod/forum/discuss.php?d=52699 student file storage area]
== See also ==
* Using Moodle [http://moodle.org/mod/forum/view.php?id=3505 Database module forum]
* [[Glossary module]], which performs a similar though more specialised, text-based role and is also available for previous versions of Moodle.
* [http://treadwell.cce.cornell.edu/moodle_doc/database_moodle/index.html a screencast introducing the Database Module and walking through creating a database]
* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=72260 Database Module: Each learner Private DB?] forum discussion
[[Category:Database]]
[[category:Modules]]
[[es:Base_de_datos_%28m%C3%B3dulo%29]]
[[es:Base_de_datos_%28m%C3%B3dulo%29]]
[[eu:Datu-basea]]
[[eu:Datu-basea]]
[[fr:Base de données]]
[[fr:Base de données]]
[[cs:Modul Databáze]]
[[ja:データベースモジュール]]
Latest revision as of 14:53, 13 August 2020
What is the Database activity?
The Database activity 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.
