a Thanh Tin Nguyen 8 éve
342
Sample Mind Map
This is a sample mind map
Relation Database
Lecture 10
MySQL Basics
MySQL Basics Example
Lecture 11
Codd’s 12 Rules
Rule 12: Non-Subversion Rule
Rule 11: Distribution Independence
Rule 10: Integrity Independence
Rule 9: Logical Data Independence
Rule 8: Physical Data Independence
Rule 7: High-Level Insert, Update, and Delete
Rule 6: View Updating Rule
Rule 5: Comprehensive Data Sublanguage Rule
Rule 4: Dynamic Online Catalog Based on the Relational Model
Rule 3: Systematic Treatment of NULL Values
Rule 2: Guaranteed Access Rule
Rule 1: The Information Rule
Lecture 12
Truncate Table
Alter Table
Modifying a column data type
Modifying a constraint
Rename a column
Removing a column
Adding a column
Rename a table
Drop Table
Create Table
Constraints
SQL Tables
Naming convention
MySQL Data Types
Large storage
Date and time
String
Numeric
Fixed point
Floating point
Integer
Types of SQL statements
Data Control Language (DCL)
Data Manipulation Language (DML)
Data Definition Language (DDL)
Lecture 13
DELETE
UPDATE
SELECT
Lecture 14
JOIN – Example
Renaming Columns
Table Aliases
RIGHT JOIN
LEFT JOIN
INNER JOIN
CROSS JOIN
More Complex SELECT
Main topic
Lecture 15
SUBQUERIES
Aggregate Functions
HAVING
GROUP BY
COUNT
AVG
SUM
MIN
MAX
Lecture 16
Transparency
DDB types
Heterogeneous
Homogeneous
Characteristics of DDBMS
Distributed Databases
Deductive Databases
Object-Oriented Databases
Disdvantages
Advantages
Relational Databases
Lecture 1
Important terms
Structured Query Language (SQL)
Database Management Systems (DBMS)
Database
Flat database vs. Relational database
Relational database terminology
information
Data
Examples
In Griffith
Property Listings
Job Portal
Flight Booking System
Video-Sharing Portal
Hotel Booking System – Typical example
Overview
Why do we need a database?
Problems with traditional file systems.
Controlled Redundancy
Security
Ease of Updating
Accuracy
Efficiency
Definition
What is a database?
Introduction to relational database
Queries
Normalisation
Entity-Relationship Modelling
Lecture 2
Database Architecture
Objectives
Three-Levels
Internal or Physical Level
Conceptual or Logical Level
External Level
Database Users
Database Administrators (DBA)
End Users
Sophisticated Users
Naïve Users
Application Programmers
Levels of Data
Real World Data
Importance of Data
Data as a resource:
Resource:
Lecture 9
Boyce-Codd Normal Form
Third Normal Form
Second Normal Form
First Normal Form
Effect of Redundancy
Deletion Anomaly
Update Anomaly
Insertion Anomaly
Flattened Table Problems
Normal Forms
Understanding Data
Problem of Redundancy
What is Normalisation?
Data redundancy
Data integrity
Referential integrity
Entity integrity
Lecture 8
Mapping M:N Relationships
Mapping 1:M Relationships
Mapping 1:1 Relationships
If not Combined
Combine Entities
Mapping Entity Type into a Relation
Preparing to Map the ERD
What is Mapping?
Lecture 7
Constructing an ERD
9 steps to Constructing an ERD
Relationship Representation (Cont)
Attribute Representation (Cont)
Entity Representation (Cont)
Lecture 6
Cardinality of relationships
Many to Many
One to Many
One to One
Degree of a Relationship
Replacing Ternary relationships
Chen’s ERD
Relationship Representation
Attribute Representation
Entity Representation
Entity Relationship Model
Types
Relationship
Attribute
Entity
Lecture 5
basic operations
Querying (Cont)
Relational Algebra
Difference
Intersection
Union
Cartesian Product
Picking both rows and columns by composing operators
Projection
Selection
Lecture 4
Relational Data Model
Querying
Referential Integrity Constraints
Basic Constructs
Database Design Methodology
Physical Design
Logical Design
Conceptual Design
Lecture 3
Components of DBMS
Concurrency Control, Backup, & Recovery Manager
Runtime Database Processor
System Catalog/Data Dictionary
Data Definition Language (DDL) and Data Manipulation Language (DML) Compilers
User Interface
Functions of DBMS
Integrity Services
Support for Data Communication
Authorization Services
Recovery Services
Concurrency Control Services
Transaction Support
A User Accessible Catalog
Data Processing
