Filter By
Filter Reset
Lectures
  • All Lectures
  • Lecture 1 (1)
  • Lecture 2 (1)
  • Lecture 3 (1)
  • Lecture 4 (1)
  • Lecture 5 (1)
  • Lecture 6 (1)
  • Lecture 7 (1)
  • Lecture 8 (1)
  • Lecture 9 (1)
  • Lecture 10 (1)
  • Lecture 11 (1)
  • Lecture 12 (1)
  • Lecture 13 (1)
  • Lecture 14 (1)
Top Professors
Semester
Class Notes (1,030,090)
AUS (35,043)
UWA (1,427)
CITS (26)
CITS1402 (14)

Class Notes for CITS1402 at University of Western Australia

Relational Database Management Systems

CITS1402 Lecture Notes - Lecture 9: Foreign Key, Unique Key

Joins Coding - Section 4 CARTESIAN JOIN A CARTESIAN JOIN produces a new table with all possible tuple combinations Best General Code: SELECT * FROM relation1 CARTESIAN JOIN relation2 ; Alte...

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture Notes - Lecture 12: Delimiter, Stored Procedure

Routines Coding - Section 7 Stored Routine Stored Routines are named sets of declarative SQL statements Written by DBA Stored on the database they're created on Invoked by triggers, ...

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture 11: Subqueries (Code)

Subqueries Coding - Section 6

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture Notes - Lecture 6: Scientific Notation, Data Integrity, Xml

Basics Coding - Section 1Initial Commands Commands Description SHOW DATABASES; Shows all databases on server USE database-name;

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture 7: Tables (Code)

Tables Coding - Section 2

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture 10: Aggregation (Code)

Aggregation Coding - Section 5GROUP BY GROUP BY returns groups of tuples according to a certain attribute Each group has one attribute that has the same value for all members is represented...

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture 13: Triggers (Code)

Triggers Coding - Section 8

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture Notes - Lecture 8: Result Set

Data Coding - Section 3

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture Notes - Lecture 4: Foreign Key, Functional Dependency, Referential Integrity

Normalisation Theory - Section 4 Database Design Goals A well designed database system: Takes care of anomalies Minimises redundancy Preserves dependencies Carries out lossless joins...

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture Notes - Lecture 2: Relational Algebra, Relational Model

Relational Algebra Theory - Section 2 Query Languages Query languages allow efficient manipulation and retrieval of data from a database Strong formal foundation based on logic. Simple Powerful ...

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture Notes - Lecture 3: Requirements Analysis, Htc One X, Mathematical Analysis

Entity Relationship Models Theory - Section 3 Database Design Database Design is necessary so that we agree on structure of the database before deciding on a particular implementation Step Name ...

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture Notes - Lecture 5: Data Integrity, Two-Phase Locking, Serializability

Transactions Theory - Section 5 Transaction A transaction is one execution of a user program The program consists of SQL statements that accomplish a single unit of work Requirements : ACID All transa...

Computer Science
CITS1402
Jianxin Li
CITS1402 Lecture 1: Introduction (Theory)

Introduction Theory - Section 1

Computer Science
CITS1402
Jianxin Li

Log In


OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit