Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision |
classlog:database_management [2013/11/19 17:44] – [Homeworks] neilhao | classlog:database_management [2023/02/11 17:30] (current) – external edit 127.0.0.1 |
---|
==== Database Management ==== | ===== Database Management ===== |
| |
| |
---- | ---- |
| |
| ==== My Notes ==== |
=== My Notes === | |
| |
| |
- 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: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}} ) |
| |
| |
| |
| |
* {{: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) | * {{: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]] |
| |
| |