Coding task · SQL and MySQL course · Module 4: Creating tables (DDL)

Build the wypozyczenia shelf

Crown your learning - design a complete shelf combining all the types and constraints you have learned.

Task

Write a CREATE TABLE statement that creates the wypozyczenia table with columns: id of type INT with AUTO_INCREMENT and PRIMARY KEY, ksiazka_id of type INT NOT NULL, czytelnik_id of type INT NOT NULL, data_wypozyczenia of type DATE NOT NULL and data_zwrotu of type DATE.