SQL & PL/SQL Example

ERD

12

SHARES

Introduction
ERD
Create CUSTOMERS Table
Create TRANSACTIONS Table
Create EMPLOYEES Table
Create CUSTOMERSFINANCIAL Table
Create EMPLOYEESFINANCIAL Table
Create CUSTOMERSCONTACT Table
Create EMPLOYEESCONTACT Table
Add CONSTRAINT to all tables
Add Sample Data
ADD SAMPLE DATA TO CUSTOMERS TABLE
ADD SAMPLE DATA TO EMPLOYEES TABLE
ADD SAMPLE DATA TO CUSTOMERCONTACT TABLE
ADD SAMPLE DATA TO EMPLOYEESCONTACT TABLE
ADD SAMPLE DATA TO CUSTOMERSFINANCIAL TABLE
ADD SAMPLE DATA TO EMPLOYEESFINANCIAL TABLE
ADD SAMPLE DATA TO TRANSACTIONS TABLE
SQL QUERY TO UPDATE DATA IN A TABLE
SQL QUERY FOR A LIST THAT DISPLAYS THE CUSTOMER AND RESPECTIVE CUSTOMER’S BANK ORDERED BY CUSTOMER NAME

Visit Today : 56

Visit Yesterday : 309

This Month : 1444

This Year : 25659

CODETEACHING.COM