Sample Mind Map

Mai multe ca aceasta

Unit on Trees

după Sarah Bull

Scholarly Databases

după leslie mccall

Chapter Supplement: Process Mapping and Analysis

după mia rarasputri

Lean Tools Kit IMBA J4

după Felipe Quintana

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