A final exam project from 3rd semester Database course at University of Latvia. The aim of the project is to create a database for cinema company with all details starting from creating database with SQL, inserting data to database tables, creating models such as physical, logical and conceptual models, retrieving data from database.
- Database Design (1480 lines SQL code)
- SQL Queries
- Conceptual Model
- Physical Model
- Logical Model
- Database design with sql (creating tables and inserting data)
- Sql queries (retrieving data, joining tables)
- Conceptual model
- Physcial model
- Logical model
