User Tools

Site Tools


classlog:database_management

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
classlog:database_management [2013/10/10 11:01] – [Homeworks] neilhaoclasslog:database_management [2023/02/11 17:30] (current) – external edit 127.0.0.1
Line 1: Line 1:
-==== Database Management ====+===== Database Management =====
  
  
 ---- ----
  
- +==== My Notes ====
-=== My Notes ===+
  
  
Line 12: Line 11:
     - {{:classlog:databasemanagement:query_optimization.pdf|QUERY OPTIMIZATION}}  ({{:classlog:databasemanagement:queryopt.pdf|PPT}}  )     - {{: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}}      - 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 ==== ==== Homeworks ====
Line 22: Line 22:
  
     * {{: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: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 ==== ==== Past Exams ====
classlog/database_management.1381402881.txt.gz · Last modified: 2023/02/11 17:30 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
CC Attribution-Noncommercial-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki