Online Mind Mapping and Brainstorming

Create your own awesome maps

Online Mind Mapping and Brainstorming

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account? Log In

Database Implementation Module 5 (DSS 5525) by Mind Map: Database Implementation Module 5 (DSS 5525)
0.0 stars - reviews range from 0 to 5

Database Implementation Module 5 (DSS 5525)

Additional Join Forms

Inner

Outer

SQL Data Manipulation Language (DML)

INSERT

UPDATE

DELETE

SQL Data Definition Language (DDL)

CREATE TABLE

ALTER TABLE

DROP TABLE

database design process

1) Information-level design

2) Physical-level design

3) Final database structure

schemas

types

Basic database design methodology

Oracle statements

Oracle does not support CASCADE UPDATE constraint

Money or currency in Oracle is Numeric

Oracle sequences must be used for surrogate keys

The DESCRIBE or DESC command is used to view table status

data types

General Info

Why use SQL instead of graphical tool for DBMS management task?

procedural language extensions