References¶
SQL¶
International Organization for Standardization and International Electrotechnical Commission. (2016). Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) (ISO/IEC 9075-2, Fifth Edition).
SQLite Documentation. Retrieved from https://www.sqlite.org/docs.html.
PostgreSQL 12 Documentation. Retrieved from https://www.postgresql.org/docs/12/index.html.
MySQL 8.0 Reference Manual. Retrieved from https://dev.mysql.com/doc/refman/8.0/en/.
Oracle Database SQL Language Reference 18c. (April, 2020). Retrieved from https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/.
Transact-SQL Reference. (April 29, 2020). Retrieved from https://docs.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver15.
Data modeling¶
Chen, Peter Pin-Shan. “The entity-relationship model—toward a unified view of data.” ACM transactions on database systems (TODS) 1.1 (1976): 9-36.
Elmasri, Ramez, and Sham Navathe. Fundamentals of Database Systems. 7th edition, Pearson, 2016.
Everest, Gordon C. “Basic data structure models explained with a common example.” Proc. Fifth Texas Conference on Computing Systems. 1976.
Relational database theory¶
Childs, David L. “Feasibility of a set-theoretic data structure: a general structure based on a reconstituted definition of relation.” Proc. IFIP Cong. (1968).
Codd, Edgar Frank. “A relational model of data for large shared data banks.” Communications of the ACM 26.1 (1983): 64-69.