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.