Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+===== Database Management =====
+----
+==== My Notes ====
+    - {{:classlog:databasemanagement:er_diagram.pdf|ER diagram}}
+    - {{:classlog:databasemanagement:five_fundamental_operators_and_additional_operators.pdf|FIVE FUNDAMENTAL OPERATORS AND ADDITIONAL OPERATORS}}
+    - {{:classlog:databasemanagement:query_optimization.pdf|QUERY OPTIMIZATION}}  ({{:classlog:databasemanagement:queryopt.pdf|PPT}}  )
+    - Relational Database Design ({{:classlog:databasemanagement:redesign.pdf|PPT}}  ) \\  {{:classlog:databasemanagement:functional_dependencies.pdf|THEORY OF FUNCTIONAL DEPENDENCIES}}
+    - {{:classlog:databasemanagement:tuple_relational_calculus.pdf|Tuple relational calculus}}
+    - {{:classlog:databasemanagement:sql.pdf|SQL}}
+    - {{:classlog:databasemanagement:transactions_recovery_concurrency_control.pdf|TRANSACTIONS, RECOVERY & CONCURRENCY CONTROL}}  ({{:classlog:databasemanagement:transactions_recovery_concurrency_control_ch.pdf|PPT_Chinese}}, {{:classlog:databasemanagement:transact.pdf|PPT}}  )
+----
+==== Homeworks ====
+    * {{:classlog:databasemanagement:hw1.zip|HW1}}  (Relational Algebra) \\   \\  __Key Points:__  \\ {{:classlog:databasemanagement:list_the_artists_that_have_been_a_member_of_more_than_one_group.pdf|List the artists that have been a member of more than one group}}  \\ {{:classlog:databasemanagement:maximum.pdf|Maximum}}  ({{:classlog:databasemanagement:aggregate_relational_algebra_maximum_-_stack_overflow.pdf|Reference}}  )
+    * {{:classlog:databasemanagement:hw2.zip|HW2}}  (Tuple Relational Calculus) \\  \\ __Key Points:__  \\ {{:classlog:databasemanagement:trc_basic_operations_division_maxvalue.pdf|Basic operations, Division and Max Value}}
+    * {{:classlog:databasemanagement:hw3.zip|HW3}}  (SQL) \\  \\ {{:classlog:databasemanagement:a3_keypoints.pdf|Key Points}}
+**__Software:__ **
+[[http://winrdbi.asu.edu/|WinRDBI Educational Tool]]
+----
+==== Past Exams ====
+    * {{:classlog:databasemanagement:midterm_spring_2007.pdf|MidTerm Spring 2007}}
+    * {{:classlog:databasemanagement:midterm_solutions.pdf|Midterm solutions}}