In this assignment, My partner and I implemented queries in SQL and embedded SQL using JDBC. We also practiced complex queries in SQL for a car-hailing app, as well as achieved database modification using JDBC. Please see the details about the assignment in A3.pdf.
Introduction to database management systems. The relational data model. Relational algebra. Querying and updating databases: the query language SQL. Application programming with SQL. Integrity constraints, normal forms, and database design. Elements of database system technology: query processing, transaction management.
- University of Toronto 2019F CSC343 Teaching Team
- Jiahao Cheng
- Zhiyuan Yang