| Practical chapters using Libreoffice Base | Theory | UML Modelling |
|---|---|---|
Libreoffice Base databases required for the tutorials: http://www.robin-beaumont.co.uk/virtualclassroom/chap8/libreoffice/libreoffice_base_files.zip |
Ways of thinking about information pdf+ | |
| Databases & DBMS pdf+ | ||
| Tables, fields, indexes pdf+ | ||
| Relationships pdf+ | ||
| Relationships pdf+ | ||
| Introduction pdf+ | ||
| Classes & instances pdf+ | ||
| Forms | ||
| Associations pdf+ | ||
| Simple select queries pdf+ | ||
| Theory behind QBE/SQL pdf+ | ||
| Complex select queries pdf+ | ||
| Multiple table queries pdf+ | ||
| Reports | ||
| Normalisation link | ||
| Also check out the Section 11 documents on 'the material link above. | ||
| Web based databases |
What the course is:
The diagram above provides a suggested route through some of the database material, and associated handouts. Click on the name to see the document. If all the examples are undertaken each handout takes on average 3 hrs to complete, therefore the total time to complete the non optional modules is 42 hrs (14x3). The aims of such a course are to:
- Provide a good understanding of database concepts.
- Enable you to be able to engage effectively with IM&T professionals in aspects of database design.
- Develop the skills to develop small scale simple databases for one's personal use (e.g. research & audit)
- Several of the optional sessions, principally the modelling strand and normalisation, along with part of sections 11 & 12, are necessary for a greater understanding of the actual design process thus allowing you to have greater engagement in the process.
- The introduction to Normalisation (7.7) has been written in a web based learning style and takes approximately 6 to 10 hours to complete.
What the course is not:
The course is NOT designed to make you profficient at developing sufficiently robust databases which could be used by others. Such a course would need to include amongst other topics, programming skills, which would include an in depth knowledge of a Database programming language. Do you really want to become a database programmer or administrator?
last updated: February 1, 2012