Technion - Israel Institute of Technology
		236363 - Database Systems
		Spring 2012
	Course Material Additional files Moed A - first page first_page.pdf 34484 Bytes Division On definitions of division in RA and DRC and connection between them Division.pdf 551 KB Safety Safe (Safe range) formulas safety.pdf 53104 Bytes BCNF Characterizing BCNF nf-course.pdf 123 KB Lectures Introduction 236363_Intro.ppt 460 KB 236363_Intro.pdf 80007 Bytes ERD 236363_ERD.ppt 474 KB 236363_ERD.pdf 151 KB Relational Algebra 236363_RA.ppt 1.2 MB 236363_RA.pdf 115 KB Relational Calculus 236363_DRC.ppt 347 KB 236363_DRC.pdf 116 KB Datalog 236363_datalog.ppt 325 KB 236363_datalog.pdf 72985 Bytes Functional Dependencies 236363_FD.ppt 455 KB 236363_FD.pdf 136 KB Normal Forms 236363_NormalForms.ppt 463 KB 236363_NormalForms.pdf 87335 Bytes XML 236363_xml.ppt 459 KB 236363_xml.pdf 137 KB XPath 236363_xpath.ppt 735 KB 236363_xpath.pdf 117 KB XQuery 236363_xquery.ppt 445 KB 236363_xquery.pdf 91426 Bytes Tutorials Part 0 - Introduction 0_Admin.ppt 327 KB 0_Admin.pdf 49213 Bytes 0_LogicsAndDatabases.ppt 647 KB 0_LogicsAndDatabases.pdf 160 KB Part 1 - SQL SQL (tutorials 1,2,3) 1a_DBMStut_sql(intro+Queries).ppt 4.5 MB 1a_DBMStut_sql(intro+Queries).pdf 423 KB 1b_DBMStut_sql(DDL+DML).ppt 1.8 MB 1b_DBMStut_sql(DDL+DML).pdf 236 KB Notes:   PostgreSQL and example can be found in the self reading section. Part 2 - RA 2_DBMStut-RA.ppt 1.2 MB 2_DBMStut-RA.pdf 281 KB 2b_DBMStut-RA_BasicSQL.ppt 367 KB 2b_DBMStut-RA_BasicSQL.pdf 88237 Bytes Part 3 - RC Logic, TRC, DRC 3a_DBMStut-logic.ppt 281 KB 3a_DBMStut-logic.pdf 57055 Bytes 3b_DBMStut-RC.ppt 460 KB 3b_DBMStut-RC.pdf 132 KB Part 4 - Datalog 4_DBMStut-datalog.ppt 614 KB 4_DBMStut-datalog.pdf 197 KB Part 5 - Design Functional dependencies Data integrity, Dependency integrity BCNF, 3NF 5a_DBMStut-FD.ppt 704 KB 5a_DBMStut-FD.pdf 203 KB 5b_DBMStut-Decompositions.ppt 1.1 MB 5b_DBMStut-Decompositions.pdf 184 KB 5c_DBMStut-NormalForms.ppt 922 KB 5c_DBMStut-NormalForms.pdf 223 KB Part 6 - XML 6a_DBMStut-xml.ppt 538 KB 6a_DBMStut-xml.pdf 138 KB 6b_DBMStut-XPath.ppt 665 KB 6b_DBMStut-XPath.pdf 153 KB 6b_XPathFunctions.pdf 51893 Bytes 6b_XpathIntersection.pdf 51352 Bytes 6c_DBMStut-XQuery.ppt 413 KB 6c_DBMStut-XQuery.pdf 148 KB Self Reading Library Example DBMStut-libExample.ppt 64512 Bytes DBMStut-libExample.pdf 50082 Bytes SQL PostgreSQL.ppt 273 KB PostgreSQL.pdf 180 KB SQL Questions.ppt 450 KB SQL Questions.pdf 102 KB Datalog The meaning of Datalog.pdf 32204 Bytes Notes:   Summary of few definitions and the meaning of the program. Design - additional exercises DesignQuestions.pdf 168 KB design-exam-q.pdf 132 KB XML catalog.xml 504 Bytes