2020-12-16 07:12
CP363: Notes - Fall 2020
The following are copies of the notes presented in lecture. They are
generally point form and reading them is not a substitute for attending
lecture and discussing their material in-depth. The instructor normally adds
extra material while discussing each slide, material that you are
responsible for on tests and exams.
Theory
Introduction Database and Application Development
Data UML
Basics UML Web Extensions
Data and Relations Relations (cont'd) Relational Algebra Relational Algebra (cont'd)
Relational Operations Joins Joins
(cont'd) Join Anomalies Functional Dependencies Normalization First Normal Form Second
Normal Form Third Normal Form Boyce-Codd Normal Form Fourth Normal Form Normal Form Rules of Thumb Transactions Concurrency Recovery Security Distributed Databases XML Query
Optimization (EXPLAIN)
Practice
Web Applications DCRIS Database Introduction to SQL SQL Table Creation SQL Table Creation
Examples SQL SELECT SQL INSERT SQL DELETE SQL UPDATE SQL Subqueries SQL Views SQL Scripts SQL Triggers SQL Triggers Examples SQL Security Dependency Examples WAE Examples
Implementation
MySQL Connecting to MySQL with a DBMS
Connecting to MySQL - Python
The Connector/Python Cursor
PHP (older notes)
PHP Notes PHP Usage Example PHP Sessions PHP Pages Selecting Binding Parameters Binding Values Forms Forms Fill Forms Other
Wilfrid Laurier University 75 University Avenue
West, Waterloo, Ontario, Canada N2L 3C5