About this document
EER Diagram and SQL for University DB by mirroalex is a document available to read on EtoBox.
This document outlines the final assignment for a database systems course. It includes 7 questions regarding entity relationship diagrams, SQL queries, relational algebra, database normalization, and checking functional dependencies. Students are asked to draw ER diagrams, write SQL code to create tables, translate between relational algebra and SQL, decompose relations into BCNF, identify candidate keys, and write a query to check a functional dependency.
- Author
- mirroalex
- Language
- EN