ألتخنيون - معهد تكنولوجي لإسرائيل
		236363 - Database Systems
		شتاء 2012-2011
	مادة الدورة Additional files Notice Slides may be slightly updated before a lecture / tutorial. If they are updated, the updated version will appear on the site before Sunday 11:59AM of the lecture / tutorial week. Lectures Introduction 236363_Intro.ppt 462 KB 236363_Intro.pdf 84437 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 Admin 0 Admin.ppt 327 KB 0 Admin.pdf 49073 Bytes Part 1 - SQL SQL (tutorials 1,2,3) DBMStut_sql(intro+Queries).pdf 424 KB DBMStut_sql(intro+Queries).ppt 4.5 MB DBMStut_sql(DDL+DML).pdf 254 KB DBMStut_sql(DDL+DML).ppt 1.9 MB ملاحظات:   PostgreSQL and example can be found in the self reading section. Part 2 - RA DBMStut-RA.ppt 1.3 MB DBMStut-RA.pdf 309 KB ملاحظات:   If you see weird signs please inform the TA in charge about the problem. Part 3 - RC Logic, TRC, DRC DBMStut-logic.ppt 139 KB DBMStut-logic.pdf 120 KB 3 DBMStut-RC.ppt 431 KB 3 DBMStut-RC.pdf 121 KB Part 4 - Datalog 4 DBMStut-datalog.ppt 635 KB 4 DBMStut-datalog.pdf 931 KB Part 5 - Design Functional dependencies Data integrity, Dependency integrity BCNF, 3NF 5 DBMStut-FD.ppt 714 KB 5 DBMStut-FD.pdf 202 KB 5 DBMStut-Decompositions.ppt 1.1 MB 5 DBMStut-Decompositions.pdf 143 KB 5 DBMStut-NormalForms.ppt 920 KB 5 DBMStut-NormalForms.pdf 884 KB Part 6 - XML XML, DTD, XPath, XQuery 6DBMStut-xml.ppt 536 KB 6DBMStut-xml.pdf 144 KB 6DBMStut-XPath.ppt 676 KB 6DBMStut-XPath.pdf 156 KB Functions.pdf 51893 Bytes intersection.pdf 51352 Bytes 6DBMStut-XQuery.ppt 428 KB 6DBMStut-XQuery.pdf 1.6 MB XQueryExamples.zip 1562 Bytes Self Reading ODL+OQL 236363_ODL+OQL.ppt 304 KB 236363_ODL+OQL.pdf 250 KB 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 ملاحظات:   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