Filter By
Filter Reset
Lectures
  • All Lectures
  • Lecture 2 (1)
  • Lecture 3 (2)
  • Lecture 4 (2)
  • Lecture 5 (1)
  • Lecture 6 (1)
  • Lecture 7 (1)
  • Lecture 8 (1)
  • Lecture 9 (1)
  • Lecture 10 (1)
  • Lecture 11 (1)
  • Lecture 12 (1)
Semester
Class Notes (1,030,960)
AUS (35,044)
Monash (3,663)
FIT (395)
FIT2094 (13)

Class Notes for FIT2094 at Monash University

Databases

FIT2094 Lecture Notes - Lecture 4: Unique Key, Associative Entity, Foreign Key

Summary of Terminologies at Different Levels Conceptual Logical Physical Entity Relation Table Attribute ...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 3: Peter Chen, Database Design, Database Model

Database Design 1: Conceptual Modelling ANSI/SPARC Architecture External Level Conceptual Level Internal Level The Database Design Life Cycle Requirements Definition - ...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 6: Data Manipulation Language, Data Definition Language, Referential Integrity

SQL General Syntax - A single statement is ended with SEMICOLON - Predefined KEYWORDS represent clauses (components) of a statement - Keywords are NOT case sensitive - Examples: CREATE TA...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 2: Tuple, Referential Integrity, Relational Model
Premium

FIT2094 Databses Lecture 2 Relational Model Data Redundancy Relational Model Fundamental basis for relational DBMS Basic structure is the mathematical concept of a RELATION mapped Relation: A relation consists of two p...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 9: Aggregate Function, Database
Premium

Lec 9: SQL10 Aggregate Functions COUNT,MAX,MIN,SUM,AVG GROUP BY If a GROUP BY clause is used with aggregate function, the DBMS will apply the aggregate function to the dierent groups dened in the clause rather than all row...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture 12: FIT2094 Lec 12 Notes
Premium

W12: Data Current Trends Usage of database Example of a supermarket Decision making Operational level When do we need to restock Xitem? Strategic and tactical level Is there any branch that performs worse than the state av...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture 10: FIT2094 Lec 10 Notes
Premium

W10: SQL III Subquery (NESTED) For each unit, nd the students who obtained maximum mark in the unit Select studid, unitcode, mark from enrolment where (unitcode, mark) IN (select unitcode, max(mark) from enrolment group by...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 5: Data Redundancy, Dependency Graph, Functional Dependency
Premium

Normalisation Data Normalisation: Relations should be normalised in order to avoid anomalies which may occur when inserting, updating and deleting data. Normalisation is a systematic series of steps for progressively renin...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 8: Transaction Processing, Database Transaction, Granularity
Premium

W8: SQL UPDATE Change the values of existing data For example, at the end of semester, change the mark and grade from 0,NA to the actual mark and grade. DELETE Removing data from the database DELETE FROM table [W...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 11: Java Database Connectivity, Application Programming Interface, Oracle Application Express
Premium

L11: Database Connectivity Database Connectivity The DATA LAYER your data management application (DBMS) The DATABASE MIDDLEWARE manages connectivity and data transformation issues. Many options available such as: Native SQ...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 7: Pattern Matching, Database
Premium

W7: SQL Set Membership Totestwhetherthevalueofexpressionequalsoneofasetofvalues. Operator: IN Example:cityIN(Melbourne,Sydney) Pattern Match Totestwhetherastring(text)matchesaspeciedpattern. Operator: LIKE Patterns: chara...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 4: Data Modeling, Unique Key, Social Security Number

FIT2094 Notes Relationships: relationships describe associations among data, between two entities Composite and Simple Attributes: Attributes are classified as simple or composite. A composite attribute, not to be confuse...

Information Technology
FIT2094
Mr Lindsay Smith
FIT2094 Lecture Notes - Lecture 3: Social Security Number, Database, Relational Model

DATABASE DESIGN 1: CONCEPTUALMODELLING Requirements Denition: Identify and analyse user views A user viewmay be a report to be produced or a particular type of transaction that should be supported Corresponds to the extern...

Information Technology
FIT2094
Mr Lindsay Smith

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