Database workshop

Содержание и основные понятия

01
Short version
Loading option...
02
Editor practice
1.
Open Data Studio and add two records with different unique IDs.
2.
Do the category selection and sort the result for the year.
3.
Explain why ID is the key and the name isn't.
4.
Offer a second table if you need to consider extradition.
Open Alterna Office: Data
FILE
SQLite training base
Tables are in the database
books
and
loans
Open it on Data Studio or SQLite program, check the structure and form the request.
download library.db
03
Laboratory with real OBD file
Imports.
Open it.
library.db
; check that the tables of Books and Extraditions have appeared.
Communications.
Add an extradition with existing
book_id
Then try the non-existent key and explain the refusal.
Request.
Get the report from the reader, filter out active issuances, and sort out the results.
Export.
Run SQLite and open it again: both tables and the link must be preserved.
Microsoft Access.
download the double-leaf XLSX and import the sheets to Access as separate tables; communication attitude
book_id
.
MDB/ACCDB can only be opened in the Alterna Office to read table data. Forms, reports, saved requests and VBA are deliberately not being executed.