Outcome on relational databases

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

01
Design of the training base
The School Library
Design the tables "Knowledge" and "Exports." Name the primary keys, types of fields and external key of the book in the issue. Then form the request: which scientific books are issued and when to return them? Do the same script in Data Studio, deliberately check the non-existent external key and unload the SQLite copy.
02
Lounge
The diagram.
Each table has a purpose and a unique key.
Communications.
The external key refers to the existing primary key.
Request.
The condition and fields of result answer one question.
Security.
Educational data were used without telephones, addresses or other unnecessary personal information.
03
Project integrity tests
A duplicate of the key.
Box of the second entry with the same ID should be rejected.
External key.
Extradition may not refer to a missing book.
Removal.
The release book is not removed before processing the dependent record.
Type and range.
The year, date and status are limited.
Reopening.
SQLite Exported is tested
integrity_check
and
foreign_key_check
.
Request.
The connection does not duplicate the data and returns the expected lines on the control set.