PEGA Basic Questions

• Basics:
• What is BPM?
• What is Pega?
• What is PRPC?
• Advantages of PEGA? Disadvantages of Pega?
• What is rule?
• What is ruleSet?
• What is case?
• What is Case Type?
• What is Process?
• What is Sub Process?
• What is Step?
• What is Stage?
• What is child case?
• What is SLA?
• How to create child case during runtime?
• Exercises (ADMIN):
• How to create organisation and create different types of users to that organisation who should handle various operations End user, Admin, BA
• Exercise (BA)
• How to Case?
• How to Create subcase at runtime?
• How to assign case to workbasket?
• How to assign case to worklist?
• How to create SLA?
• How to Send email ? carrnew
• What is Flow and Flow Action
• What is Carrnew
• What is Tickler
• Technical (Coding Level )
• What is PyDefault in datatransform
• Explain : Smart shapes of Pega
• What is pattern  inheritance and Direct inheritance?
• Write program to implement Decision Tree and Decision Table?
• How to set data page in Thread?
• What is Spinoff cases
• Write a program to save case detail in database
• Store Case Details in Separate Table
• How to create reusable section (inheritance)
• What corrnew?
• How to setup sla?
• Explain : Setting, Breakpoint,Watch
• What are the values available in Clipboard
• Advanced 
• How to create workbasket dynamically
• UI
• What are the 2 types of validation 
• Reports
• How to view escalated cases?
• What is Business Metric and Process Matric in pega
• Security :
• What is access group?
• Rules and RuleSet
• Pega Project Design Best Practises
• What is guardrail
• Best Practices of Pega - Why to reduce activities
• Pega Database Design
• How to design reusable components in pega. Frame work vs implementation
• Sample Projects
• Insurance claim , Onboarding
• 
  

Java UTIL - HashSet - LinkedHashSet - TreeSet Examples

package com.util;

import java.util.HashSet;
import java.util.LinkedHashSet;
import java.util.TreeSet;

public class LinkedHashSetTreeDemo {
 public void operationHashSet()
 {
  HashSet hs = new HashSet();
       // add elements to the hash set

   hs.add("B");
   hs.add("B");
       hs.add("A");
       hs.add("D");
       hs.add("E");
       hs.add("C");
       hs.add("F");
       System.out.println("HASHSET ANY RANDOM OREDER"+hs);
 }
 public void operationLinkedHashSet()
 {
  LinkedHashSet hs = new LinkedHashSet();
       // add elements to the hash set
       hs.add("B");
       hs.add("B");
       hs.add("A");
       hs.add("D");
       hs.add("E");
       hs.add("C");
       hs.add("F");
       System.out.println("LINKED HASH SET SAME ORDER"+hs);
 }
 public void operationTreeSet()
 {
  TreeSet hs = new TreeSet();
       // add elements to the hash set

   hs.add("B");
   hs.add("B");
       hs.add("A");
       hs.add("D");
       hs.add("E");
       hs.add("C");
       hs.add("F");
       System.out.println("TREE SET"+hs);
 }
 public static void main(String args[]) {
       // create a hash set
  LinkedHashSetTreeDemo lhs= new LinkedHashSetTreeDemo();
  lhs.operationLinkedHashSet();
  lhs.operationHashSet();
  lhs.operationTreeSet();
    }
}

Java DatabaseMetaData Example

package com.fc.databaseInfo;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
public class DBMD {
public DBMD() {
Connection Db2Conn = null;
PreparedStatement Db2Stmt = null;
ResultSet Db2Rs = null;
String sql = null;
String Table ="YTRT860_RET ";
String fileWriter="";
try { // Database connection string String DRIVER = "com.ibm.as400.access.AS400JDBCDriver";
String URL = "jdbc:db2://localhosturl/DSN8";
// Connect to Database Class.forName("com.ibm.db2.jcc.DB2Driver");
Db2Conn = DriverManager.getConnection(URL,"USERID","PASSWORD");
DatabaseMetaData databaseMetaData = Db2Conn.getMetaData();
String catalog = null;
String schemaPattern = null;
String tableNamePattern = null; String[] types = null;
ResultSet result = databaseMetaData.getTables( catalog, schemaPattern, tableNamePattern, types );
 while(result.next()) {
String tableName = result.getString(3);
System.out.println("tableName "+tableName);
}
}
// Handle any errors that may have occurred. catch (Exception e) { e.printStackTrace(); }
finally { if (Db2Rs != null) try { Db2Rs.close();
} catch(Exception e) {}
if (Db2Stmt != null) try {
Db2Stmt.close(); } catch(Exception e) {}
if (Db2Conn != null) try { Db2Conn.close(); }
catch(Exception e) {}
System.out.println("====================SUCCESS============================="); } }
public static void main(String args[])
{
DBMD d = new DBMD();
}
}

Hibernate Example

-- phpMyAdmin SQL Dump -- version 3.3.9 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 15, 2013 at 03:49 PM -- Server version: 5.5.8 -- PHP Version: 5.3.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `product_catalog` -- -- -------------------------------------------------------- -- -- Table structure for table `product_info` -- CREATE TABLE IF NOT EXISTS `product_info` ( `pk_product_id` varchar(50) NOT NULL, `product_name` varchar(50) NOT NULL, `product_detail` varchar(100) NOT NULL, `parent_product_id` varchar(20) NOT NULL, `child_product_id` varchar(20) NOT NULL, `model` varchar(50) NOT NULL, `material_type` varchar(50) NOT NULL, `quantity` int(5) NOT NULL, `calculation_unit` varchar(4) NOT NULL, `current_rate` decimal(8,0) NOT NULL, `product_image` varchar(255) NOT NULL, `created_by` varchar(25) NOT NULL, `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_updated_by` varchar(50) NOT NULL, `last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `status` varchar(1) NOT NULL, PRIMARY KEY (`pk_product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `product_info` -- INSERT INTO `product_info` (`pk_product_id`, `product_name`, `product_detail`, `parent_product_id`, `child_product_id`, `model`, `material_type`, `quantity`, `calculation_unit`, `current_rate`, `product_image`, `created_by`, `created_date`, `last_updated_by`, `last_updated_datetime`, `status`) VALUES ('', '', '', '', '', '', 'JW', 0, '', '0', '', '', '2013-10-16 01:44:00', '', '0000-00-00 00:00:00', ''), ('1000', 'thosanas', 'pd', 'pid', 'NULL', 'model', 'material_type', 0, 'NO', '999', 'image', 'created_by', '2013-11-15 21:08:01', 'last_updated_by', '2013-11-15 21:08:01', '1'), ('11111111111', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586227Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('111111111111111', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586094Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('11111111111a', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586262Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('67876876', 'yiuyi', 'yiuy', '', '', 'yiy', 'HH', 0, 'no', '0', '1381588215Chrysanthemum.jpg', 'yiyi', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('7', '8798798', '7987', '', '', 'pm', 'JW', 798798, 'no', '98798', '1381571437c-t-winding-machine-150mm-125x125.jpg', '798798', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '1'), ('78798', '9879', '7987', '', '', '', 'JW', 98798, 'no', '987988', '1381580817Penguins.jpg', '79879', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('7987', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381582956Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381584809Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777888', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381585060Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777888222222222222', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381585167Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877897987', '98798', '7987', '', '', '', 'JW', 798, 'no', '987', '1381580987Jellyfish.jpg', '98798', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('798798797', '897', '987', '', '', '98798', 'JW', 0, 'no', '7', '1381588288Koala.jpg', '779879', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('987', '7987', '987987', '', '', '87', '87987', 0, 'no', '87', '1382179471Hydrangeas.jpg', '87', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('ajskdhaksh', 'yiuyi', 'iuy', '', '', 'iuyiuy', 'JW', 0, 'uiy', '0', '13815690002013-09-23 17.09.05.jpg', 'uy', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '1'), ('hjg', 'hjg', 'hg', '', '', 'g', 'JW', 0, 'j', '0', '1381567851judithpaper.jpg', 'gg', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'g'), ('iuououoiuioui', 'uou', 'oiuoi', '', '', 'uoiu', 'JW', 0, 'oiuo', '0', '13815690932013-09-21 17.43.29.jpg', 'uoiu', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'o'), ('u', 'iouo', 'iuoiu', '', '', 'pm', 'JW', 0, 'no', '0', '1381572794Koala.jpg', 'oiuo', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'u'), ('yiuyiuuiy', 'uiy', 'uy', '', '', 'uy', 'HH', 0, 'no', '0', '1381600683Penguins.jpg', 'uy', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A');

Role Base Security Data Base Design (MYSQL Script)

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2011 at 07:58 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `security`
--

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
`pk_role_id` varchar(50) NOT NULL,
`role_name` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`pk_role_id`, `role_name`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('psu1001', 'prod_support', 'andrew', '2011-08-20 11:51:58', 'andrew', '2011-08-20 11:52:02'),
('ops1001', 'order pro specialist', 'andrew', '2011-08-20 11:52:51', 'vdsi', '2011-08-20 11:52:55');

-- --------------------------------------------------------

--
-- Table structure for table `role_screen`
--

CREATE TABLE IF NOT EXISTS `role_screen` (
`pk_role_screen_id` varchar(50) NOT NULL,
`fk_role_id` varchar(50) NOT NULL,
`fk_screen_id` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_role_screen_id`),
KEY `fk_role_id` (`fk_role_id`),
KEY `fk_screen_id` (`fk_screen_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role_screen`
--

INSERT INTO `role_screen` (`pk_role_screen_id`, `fk_role_id`, `fk_screen_id`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('1', 'psu1001', 'oes1001', 'andrew', '2011-08-20 12:01:35', 'andrew', '2011-08-20 12:01:40'),
('2', 'psu1001', 'psu1001', 'andrew', '2011-08-20 12:02:11', 'andrew', '2011-08-20 12:02:17'),
('3', 'oes1001', 'oes1001', 'andrew', '2011-08-20 12:03:46', 'andrew', '2011-08-20 12:03:50');

-- --------------------------------------------------------

--
-- Table structure for table `screens`
--

CREATE TABLE IF NOT EXISTS `screens` (
`screen_id` varchar(50) NOT NULL,
`screen_name` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`screen_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `screens`
--

INSERT INTO `screens` (`screen_id`, `screen_name`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('oes1001', 'order_entry', 'andew', '2011-08-20 11:56:47', 'andrew', '2011-08-20 11:56:57'),
('pss1001', 'production support', 'andrewq', '2011-08-20 11:58:01', 'andrew', '2011-08-20 11:58:08'),
('1111', 'scree', 'andrew', '2011-08-20 11:56:47', 'andrew', '2011-08-20 11:56:47');

-- --------------------------------------------------------

--
-- Table structure for table `userinfo`
--

CREATE TABLE IF NOT EXISTS `userinfo` (
`pk_user_id` varchar(50) NOT NULL,
`user_name` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`email_id` varchar(50) NOT NULL,
`current_designation` varchar(50) NOT NULL,
`current_role` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userinfo`
--

INSERT INTO `userinfo` (`pk_user_id`, `user_name`, `password`, `email_id`, `current_designation`, `current_role`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('z381466', 'anton', 'anton', 'anton@gmail.com', 'developer', 'developer', 'andrew ', '2011-08-20 11:50:46', 'andrew', '2011-08-20 11:50:46'),
('z381455', 'andrews ', 'andrvdsiews', 'andrew_india@yahoo.com', 'analyst', 'developer', 'vdsi', '2011-08-20 11:49:22', 'andrew', '2011-08-20 11:49:22'),
('oiu', 'oiuo', 'oiu', 'ioou', '98', '9809', '098', '2011-11-11 00:00:00', '890', '2011-11-11 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `user_role`
--

CREATE TABLE IF NOT EXISTS `user_role` (
`pk_user_role_id` varchar(50) NOT NULL,
`fk_role_id` varchar(50) NOT NULL,
`fk_user_id` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_user_role_id`),
KEY `fk_role_id` (`fk_role_id`),
KEY `fk_user_id` (`fk_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`pk_user_role_id`, `fk_role_id`, `fk_user_id`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('1', 'psu1001', 'z381455', 'vdsi', '2011-08-20 11:55:23', 'andrew', '2011-08-20 11:55:33'),
('2', 'ops1001', 'z381455', 'andewq', '2011-08-20 11:55:54', 'vdsi', '2011-08-20 11:55:58');

Inventory database Design

Hi All Please find a DB Design for inventory and you can use it in your projects.
post questions if youn have any questions or comments.

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2011 at 07:43 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `inventory`
--

-- --------------------------------------------------------

--
-- Table structure for table `branch_info`
--

CREATE TABLE IF NOT EXISTS `branch_info` (
`pk_branch_id` varchar(50) NOT NULL,
`fk_company_id` varchar(50) NOT NULL,
`branch_name` varchar(50) NOT NULL,
`branch_poc` varchar(50) NOT NULL,
`branch_detail` varchar(200) NOT NULL,
`website` varchar(100) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_branch_id`),
KEY `FK_branch_info_company_info` (`fk_company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `branch_info`
--


-- --------------------------------------------------------

--
-- Table structure for table `company_info`
--

CREATE TABLE IF NOT EXISTS `company_info` (
`pk_company_id` varchar(50) NOT NULL,
`company_name` varchar(50) NOT NULL,
`company_type` varchar(25) NOT NULL,
`company_detail` varchar(100) NOT NULL,
`website` varchar(50) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company_info`
--


-- --------------------------------------------------------

--
-- Table structure for table `inventory`
--

CREATE TABLE IF NOT EXISTS `inventory` (
`pk_inventory_id` varchar(50) NOT NULL,
`fk_product_id` varchar(50) NOT NULL,
`fk_company_id` varchar(50) NOT NULL,
`fk_branch_id` varchar(50) NOT NULL,
`quantity` int(5) NOT NULL,
`calculation_unit` varchar(4) NOT NULL,
`io_type` varchar(1) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_inventory_id`),
KEY `FK_inventory_product_info` (`fk_product_id`),
KEY `FK_inventory_company_info` (`fk_company_id`),
KEY `FK_inventory_branch_info` (`fk_branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`
--


-- --------------------------------------------------------

--
-- Table structure for table `product_info`
--

CREATE TABLE IF NOT EXISTS `product_info` (
`pk_product_id` varchar(50) NOT NULL,
`product_name` varchar(50) NOT NULL,
`product_detail` varchar(100) NOT NULL,
`model` varchar(50) NOT NULL,
`material_type` varchar(50) NOT NULL,
`quantity` int(5) NOT NULL,
`calculation_unit` varchar(4) NOT NULL,
`current_rate` decimal(8,0) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_info`
--


-- --------------------------------------------------------

--
-- Table structure for table `product_supplier`
--

CREATE TABLE IF NOT EXISTS `product_supplier` (
`pk_product_supplier_id` varchar(101) NOT NULL,
`fk_product_id` varchar(50) NOT NULL,
`fk_supplier_id` varchar(50) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_product_supplier_id`),
KEY `FK_product_supplier_product_info` (`fk_product_id`),
KEY `FK_product_supplier_supplier_info` (`fk_supplier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_supplier`
--


-- --------------------------------------------------------

--
-- Table structure for table `supplier_info`
--

CREATE TABLE IF NOT EXISTS `supplier_info` (
`pk_supplier_id` varchar(50) NOT NULL,
`supplier_name` varchar(50) NOT NULL,
`supplier_type` varchar(25) NOT NULL,
`supplier_detail` varchar(100) NOT NULL,
`website` varchar(50) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_supplier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_info`
--


--
-- Constraints for dumped tables
--

--
-- Constraints for table `branch_info`
--
ALTER TABLE `branch_info`
ADD CONSTRAINT `FK_branch_info_company_info` FOREIGN KEY (`fk_company_id`) REFERENCES `company_info` (`pk_company_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventory`
--
ALTER TABLE `inventory`
ADD CONSTRAINT `FK_inventory_branch_info` FOREIGN KEY (`fk_branch_id`) REFERENCES `branch_info` (`pk_branch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_inventory_company_info` FOREIGN KEY (`fk_company_id`) REFERENCES `company_info` (`pk_company_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_inventory_product_info` FOREIGN KEY (`fk_product_id`) REFERENCES `product_info` (`pk_product_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_supplier`
--
ALTER TABLE `product_supplier`
ADD CONSTRAINT `FK_product_supplier_product_info` FOREIGN KEY (`fk_product_id`) REFERENCES `product_info` (`pk_product_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_product_supplier_supplier_info` FOREIGN KEY (`fk_supplier_id`) REFERENCES `supplier_info` (`pk_supplier_id`) ON DELETE CASCADE ON UPDATE CASCADE;

PHP TUTOR

What is PHP?
PHP is one of the langauge for Web Programming.
It is used to develop dynamic web sites like Online shopping, Exam results and railway reservation.

What is Know as Dynamic web Pages and static web Page? (Basic)
Dyanmic Web Site :
Web Page Content is taken and displayed from database, It is Dynamic Content.
Example : Exam Results. Here student info and marks are taken from database.

Static Web Site :
In web Page, Content is entered in web page it self is known as static content.
Example : About us, Contact us pages in web site.

What is Database commonly used for PHP and WHY? (Basic)
MYSQL because it is open source.