===== 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}}