Go Back

CSC 343 - Intro To Databases

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.

	Lecture Slides	WorkSheets
Week 1 Relational Model	Relational Model Intro Annotated	Movies
Week 2 Relational Algebra	Relational Algebra	Relational Algebra exercise sol Relational model exercise sol
Week 3	Same as above
Week 4 SQL DML	SQL-DML_part1	set ops sol group by having sol SQL readings
Week 5 SQL DML p2	SQL-DML_part2	Joins sol Subqueries sol
Week 6 SQL DDL, Embedded SQL	Embedded slides Schema slides SQL DDL(data def language) slides	DDL sol RP sol JDBC
Week 7	MIDterm
Week 8 Design Theory & Normalization	Design Part 1	FDs sol PRojection_minimalBasis
Week 9 Design Theory & Normalization, cont.	Design Part 2	BCNF sol PRoperties SOL Keys sol 3NF Sol
Week 10 Design Theory cont, ER Models	ER Slides chase Slides	chase sol ER1 SOL ER2 sol
Week 11 ER Models cont, XML	XML Slides	xml sol
Week 12 JSON	JSON Slides	JSON

Through the 3 assignments I learned how to

- A1
- read a relational scheme and analyze instances of the schema
- read and apply integrity constraints
- express queries and integrity constraints of your own
- think about the limits of what can be expressed in relational algebra
- A1 Solution
- A2
- read and interpret a novel schema written in SQL
- write complex queries in SQL
- design datasets to test a SQL query thoroughly
- quickly find and understand needed information in the postgreSQL documentation
- embed SQL in a high-level language using JDBC
- recognize limits to the expressive power of standard SQL
- A3
- informally design a database to represent a real-world scenario
- express your design as an SQL schema
- reason about functional dependencies and usenormal forms

Midterm

midTerm Sol

Reflection ✍

Overall:4/5, Workload 4/5, Difficulity 3/5

I took this class with Danny Heap in 2020W. Content wasn't difficult but homeworks were long. Learned a lot of super useful SQL and got to define schemas based on real world problems, modify existing databases and craft complex queries.