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)
Semester
Class Notes (1,045,618)
AUS (35,236)
UTS (658)
31271 (10)

Class Notes for 31271 at University of Technology Sydney

Communication for IT Professionals

31271 Lecture Notes - Lecture 10: Embedded Sql, Aggregate Function
Premium

Lecture 10: SQL IV Subqueries can be noncorrelated (executed once for the entire outer query), or they can be correlated (executed once for each row which is returned by the outer query). A correlate...

Information Technology
31271
All Professors
31271 Lecture 9: Database Fundamentals Notes
Premium

Lecture 9: SQL III Simple Subquery A subquery is a query within a query. It is used in WHERE and HAVING conditions. The subquery will execute once. Most commonly used to find the maximum or minimum An equivalent way to fin...

Information Technology
31271
All Professors
31271 Lecture Notes - Lecture 8: Foreign Key, Unique Key

Lecture 8: SQL II Join Join is a relational operation that causes two or more tables with a common column to be combined into a single table or view. It displays the output from these tables by finding matching row values ...

Information Technology
31271
All Professors
31271 Lecture Notes - Lecture 7: Aggregate Function, Programming Productivity, Virtual Method Table

Lecture 7: SQL I Connecting to PostgreSQL in Labs In terminal, type psql h pgsqllab.it.uts.edu.au U username username To add a database file, type i dbfile.txt SQL Overview SQL Structured Query Language, is the standard fo...

Information Technology
31271
All Professors
31271 Lecture Notes - Lecture 6: Candidate Key, Third Normal Form, Foreign Key

Lecture 6: Normalisation II Boyce Codd Normal Form (BCNF) For a relation to be in BCNF, it must already be in third normal form, and every determinant must be a candidate key. Put simply, a relation ...

Information Technology
31271
All Professors
31271 Lecture Notes - Lecture 5: Electrical Contacts, Foreign Key, Data Redundancy

Lecture 5: Normalization I Terms for Normalisation Functional Dependencies A functional dependency is a constraint between two attributes in which the value of one attribute (dependent) is determined by the...

Information Technology
31271
All Professors
31271 Lecture Notes - Lecture 4: Subtyping, Referential Integrity, Unique Key

Lecture 4: Relational Model Components of Relational Model Data Structure: o Tables (relations), rows, columns Data manipulation: o Powerful SQL operations for retrieving and modifying data Data Integrity: o Mechanisms for...

Information Technology
31271
All Professors
31271 Lecture Notes - Lecture 3: Subtyping

Lecture 3: Data Modelling Part III Supertypes and Subtypes Supertypes have the common attributes across multiple entities. It is a generic entity types that has a relationship with one or more subtypes. ...

Information Technology
31271
All Professors
31271 Lecture Notes - Lecture 2: Unique Key, Foreign Key, Associative Entity

Lecture 2: Data Modelling Part II Relationship Relationship Type and Instances A relationship type is modelled as lines between entity types, whereas a relationship instance is between specific entity insta...

Information Technology
31271
All Professors
31271 Lecture Notes - Lecture 1: Meed, Business Rule, Conceptual Schema

Lecture 1: Introduction to DBMS and Data Modelling Part 1 Database Development (Basic Concepts) Data is stored representations of objects and events that have meaning and importance in the users environment...

Information Technology
31271
All Professors

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