MySQL

MySQL was first released on 23rd May 1995.

It is very easy to write and make the system do what u want

Linux variant: depending on the distribution you use, there are (most certainly) prepared packages (e.g. Debian, Ubuntu) to install, if you use a more complicated distro like gentoo, you have to download and compile the source packages (check google for tutorials on that).

Windows variant 1: you can employ a prepared WAMPP package (apache, mysql, php, pear/pecl) - find it here: www.apachefriends.org

Windows variant 2: you can install all desired services manually (check google for tutorials on windows apache iis)

MySQL is the full name of the product, it's not an abbreviation. In general usage, the acronym "SQL" stands for Structured Query Language.

MySQL name was created in 2 parts, the first part was named after the original developer Michael Widenius's daughter "My". Then SQL stands for Structured Query Language. It is pronounced "My S-Q-L", but is often pronounced as "My Sequel" also.

The main difference that I see is Postgres' advanced support for things like Views, Stored Procedures, Transactions and other more advanced database functions. This is not to say that MySQL does not support these, however Postgres' advanced features are tuned to be highly performative.

Also, Postgres supports more concurrent users than MySQL.

That all being said, if you web application is a relatively simple, mostly read-only, and doesn't require large number of concurrent connections, MySQL is probably the better way to go, as it is performatively optimized for reading, and is simpler to install, maintain, and has better third-party tool suppport.

:)

In order for the MySQL server to be secure, it must have a unique and non-guessable password. Thus we cannot give you a password, as that would mean someone could access the database without your permission. A good password should be at least six characters long and consist of both alphabetical and numerical characters. It should be easy for you to remember but not something that could be found through a simple dictionary attack.

In a database table, the INSERT INTO statement is used to insert new rows. Let's create a SQL query with acceptable values using the INSERT INTO statement, and then run it by passing it to the PHP mysqli query() function to insert data into the table.

To learn more about data science please visit- Learnbay.co

DBMS stand for data base management system

We normally use dbms systems to improve the management of the data and accesss of the data too.

well if the data is in normal form it is very easy to access it as well as manage it for the system.

In the process of normalization we increase the normality of the data by removing the dependencies redundancy applying the entity integrity and referential integrity.

there are many stages of Normalization process..:

1. 1NF

2. 2NF

3. 3NF

4. BC NF

5. 5NF...etc..

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

Addendum:

While the above answer is not incorrect, I don't believe it properly answers the question in a way that anyone who is not already a database expert would understand. The question is this: Why do we need to normalize data in a database. Here is the answer:

First, in order to answer this you have to understand what normalization is. Normalization is the process of removing duplicate information and dependent information from a database.

Lets say for example you have two tables, one called 'employees' and another called 'addresses'. In the employees table you include a field called 'city' and you also include this field in the addresses table. The reason you might do something like this is that you want to be able to get a basic idea of where your employee lives without having to look up the address so you include it in both locations.

Why is this bad? well it should be obvious but here it is. Its bad because it allows for inaccuracies. What if the employee moves and changes his address and you forget to change the city listed in the employees table (or your system crashes while you trying to do it)

the proper way to do this would be to not have the 'city' field in the employee table and instead have a reference to the address table. When querying this info you need to join the two tables and this will ensure that you always have the correct info.

-Dallas Caley

An ER diagram is an entity-relationship diagram they show individuals and their links to each other. An ER diagram for a hospital management system would be a flow chart showing hospital staff, equipment, patients, records and more.

When a computer user wants to store data electronically they must do so by placing data in files. Files are stored in specific locations on the hard disk (directories). The user can create new files to place data in, delete a file that contains data, rename the file, etc -- all known as file management; a function provided by the Operating System (OS).

If the user wishes to perform some operation on the data he has placed in the file, such as viewing a list of his friends that celebrate their birthday in June, he has to scroll through all the data by himself in order to see the data he is interested in. Moreover, he has to know where he put the files that contain the data, and if there are multiple files he has to remember to go through each one of them.

A Database Management System is intended to remove this burden of manually locating data, and having to scroll through it by allowing the user to create a logical structure for the data beforehand, and then allowing the user to place the data in the database that the DBMS is managing. In this way the DBMS abstracts away the physical concerns of organising files, and provides the user with a logical view of the data.

Note, that the DBMS will still -- behind the scenes though -- place the data in files on the hard-disk.

Database is multiuser and provides utilization of resources whereas in file management there is no utilization of resources.

The ration Between total Participation and partial participation is called as Cardinality ration.

a phone book is 1 .. i think

ER Diagram - entity relationship diagram.

Identify the entities in a computer shop.

there will be

computers , and various peripherals and components

workers

customers (.. what else ?)

<%@ page import ="java.sql.*" %>

<%@ page import ="javax.sql.*" %>

<%@ page import ="java.io.*" %>

<%@ page language="java" import="java.util.*,java.text.SimpleDateFormat;" pageEncoding="ISO-8859-1"%>

<html>

<%

Calendar currentDate = Calendar.getInstance();

SimpleDateFormat formatter= new SimpleDateFormat("dd/MM/yyyy");

String dateNow = formatter.format(currentDate.getTime());

String nam=(String)request.getAttribute("uname");

String pwd=(String)request.getAttribute("pwd");

request.setAttribute("date",dateNow);

request.setAttribute("nam",nam);

request.setAttribute("pwd",pwd);

System.out.print(nam);

%>

<%

String full_name=request.getParameter("fname");

String cn=request.getParameter("name");

String deg=request.getParameter("designation");

String ema=request.getParameter("email");

String mobile=request.getParameter("mob_no");

String serial=request.getParameter("ser_no");

String department=request.getParameter("deptt_name");

String off_add=request.getParameter("office_address");

String st_name=request.getParameter("state_name");

String spin=request.getParameter("pin");

String phn_no=request.getParameter("phone_no");

String svar1=request.getParameter("srvip");

String svar2=request.getParameter("srvloc");

String svar3=request.getParameter("destport");

String svar4=request.getParameter("descrsrv");

String placen=request.getParameter("place");

String vdate=request.getParameter("date");

String rname=request.getParameter("r_name");

String rdesg=request.getParameter("r_designation");

String remail=request.getParameter("r_email");

String rphone=request.getParameter("r_phone");

String cname=request.getParameter("c_name");

String cdesg=request.getParameter("c_designation");

String cemail=request.getParameter("c_email");

String cphone=request.getParameter("c_phone");

String issby=request.getParameter("captchatext");

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost/vpn","root","test123");

Statement st= con.createStatement();

int i=st.executeUpdate("insert into vpn_registration(cname,name,designation,email,mobile,serial_no,name_dept,off_add,state,pincode,off_phone,place,rname,rdesign,rmail,rmob,c_name,cdesign,cmail,cmob,issuedby) values ('"+cn+"','"+full_name+"','"+deg+"','"+ema+"','"+mobile+"','"+serial+"','"+department+"','"+off_add+"','"+st_name+"','"+spin+"','"+phn_no+"','"+placen+"','"+rname+"','"+rdesg+"','"+remail+"','"+rphone+"','"+cname+"','"+cdesg+"','"+cemail+"','"+cphone+"','"+issby+"')");

Statement st1= con.createStatement();

int y=st1.executeUpdate("insert into server_details(registration_no,serip,serloc,destport,desc_service) values ('"+svar1+"','"+svar2+"','"+svar3+"','"+svar4+"')");

st.close();

con.close();

%>

<head>

<title>ONLINE VPN REGISTRATION FORM</title>

<style>

a, A:link, a:visited, a:active

{color: #0000aa; text-decoration: none; font-family: Tahoma, Verdana; font-size: 11px}

A:hover

{color: #ff0000; text-decoration: none; font-family: Tahoma, Verdana; font-size: 11px}

p, tr, td, ul, li

{color: #000000; font-family: Tahoma, Verdana; font-size: 11px}

.header1, h1

{color: #ffffff; background: #4682B4; font-weight: bold; font-family: Tahoma, Verdana; font-size: 13px; margin: 0px; padding-left: 2px; height: 21px}

.ctrl

{font-family: Tahoma, Verdana, sans-serif; font-size: 12px; width: 100%;}

.btnform

{border: 0px; font-family: tahoma, verdana; font-size: 12px; background-color: #DBEAF5; width: 100%; height:18px; text-align: center; cursor: hand;}

.btn

{background-color: #DBEAF5; padding: 0px;}

textarea, select,input

{font: 9px Verdana, arial, helvetica, sans-serif; background-color: #DBEAF5;}

</style>

<SCRIPT language="javascript">

function addRow(tableID) {

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

if(rowCount>6)

{

alert("Cannot add more than 6 rows.");

return false;

}

document.getElementById("rowlength").value=rowCount;

var row = table.insertRow(rowCount);

var counts=rowCount-1;

var cell0 = row.insertCell(0);

var chk = document.createElement("input");

chk.type = "checkbox";

chk.name="chk"+counts+"";

cell0.appendChild(chk);

var cell1 = row.insertCell(1);

var srvip = document.createElement("input");

srvip.name="srvip"+counts+"";

srvip.id="srvip"+counts+"";

srvip.className='ctrl';

srvip.type = "text";

//srvip.onClick="hello()";

cell1.appendChild(srvip);

var cell2 = row.insertCell(2);

var srvloc = document.createElement("input");

srvloc.type = "text";

srvloc.className='ctrl';

srvloc.name="srvloc"+counts+"";

cell2.appendChild(srvloc);

var cell3 = row.insertCell(3);

var destport = document.createElement("input");

destport.type = "text";

destport.className='ctrl';

destport.name="destport"+counts+"";

destport.id="destport"+counts+"";

cell3.appendChild(destport);

var cell4 = row.insertCell(4);

var descrsrv = document.createElement("input");

descrsrv.type = "text";

descrsrv.className='ctrl';

descrsrv.name="descrsrv"+counts+"";

cell4.appendChild(descrsrv);

}

</SCRIPT>

<script type="text/javascript">

function clearFields()

{

document.cmaForm.reset();

}

</script>

<SCRIPT language="javascript">

function deleteRow(tableID) {

try {

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

for(var i=0; i<rowCount; i++) {

var row = table.rows[i];

var chkbox = row.cells[0].childNodes[0];

if(null != chkbox && true == chkbox.checked) {

if(rowCount <= 2) {

alert("Cannot delete all the rows.");

break;

}

table.deleteRow(i);

rowCount--;

i--;

}

}

}catch(e) {

alert(e);

}

}

</SCRIPT>

<script type="text/javascript">

function setid()

{

var x=document.cmaForm.rowlength.value;

//alert(x);

document.cmaForm.id=x;

return true;

}

</script>

<script type="text/javascript" src="vpn.js"></script>

</head>

<body onload="noBack();" onpageshow="if (event.persisted) noBack();" onunload="noBack();" bgcolor="white">

<!-- Header -->

<table cellpadding="0" cellspacing="0" width="100%" border="0" bgcolor="#ffffff">

<tr>

<td align="center"><img src="img/nic.jpg" width="65%" height="80" border="0" alt="NIC Logo"></td>

</tr>

<tr><td><img src="img/line9.gif" width="1" height="5" border="0"></td></tr>

</table>

<!-- Form -->

<form method="post" name="cmaForm" action="vpn_registration.jsp" id="0" onSubmit="return setid(),validate_form(this.id)" >

<table cellpadding="0" cellspacing="0" border="0" width="65%" align="center">

<tr>

<td bgcolor="#4682B4" width="10"><img src="img/line9.gif" width="10" height="1" border="0"></td>

<td class="header1" nowrap>NIC VPN Services<img src="img/line9.gif" width="10" height="1" border="0"></td>

<td><img src="img/line5.gif" width="10" height="21" border="0"></td>

<td background="img/line8.gif" width="100%">&nbsp;</td>

<td background="img/line8.gif"><img src="img/line9.gif" width="10" height="1" border="0"></td>

</tr>

<tr>

<td background="img/line6.gif"><img src="img/line9.gif" border="0"></td>

<td colspan="3"><img src="img/line9.gif" width="1" height="10" border="0"><br>

<table cellpadding="0" cellspacing="0" border="0" width="100%">

<tr><td bgcolor="#DBEAF5">

<table cellspacing="1" cellpadding="2" border="0" width="100%">

<tr bgcolor="#ffffff">

<td colspan="7" align="center"><font size="2">National Infomatics Centre <br> Department of Information Technology<br>Ministry of Communications and Information Technology

<br> Government of India</font></td>

</tr>

<tr bgcolor="#4682B4">

<td colspan="7" align="center"><font size="2" color="white"><b>VPN Registration Form</b></font></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7"><b>Note:</b>&nbsp;&nbsp;Fields marked<font size="2" color="red"> * </font>are mandatory.

</td>

</tr>

<logic:present name="fail">

<tr><td colspan=7 align="center" ><font color="red" size="5">${fail}</font></td></tr>

</logic:present>

<tr bgcolor="#ffffff">

<td colspan="7" align="center"><b>SECTION I : SUBSCRIBER INFORMATION</b></td>

</tr>

<tr bgcolor="#CCCCCC">

<td colspan="7">&nbsp;1.1 Personal Details:</td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;Full Name:<font size="2" color="red">* </font></td>

<td colspan="1" width="35%"><input type="text" name="fname" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;Common Name:</td>

<td colspan="5" width="50%"><input type="text" name="name" value="<%= request.getParameter("uname")%>" readonly="readonly"class="ctrl"></td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;Designation:<font size="2" color="red">* </font></td>

<td colspan="1" width="35%"><input type="text" name="designation" size="12" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;E-mail Address:<font size="2" color="red">* </font></td>

<td colspan="5" width="50%"><input type="text" name="email" class="ctrl" size="10"></td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;Mobile:<font size="2" color="red">* </font></td>

<td colspan="1" width="35%"><input type="text" name="mob_no" size="12" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;DC Serial No.:</td>

<td colspan="5" width="50%"><input type="text" name="ser_no" value="<%= request.getParameter("pwd")%>" readonly="readonly"class="ctrl" size="10"></td>

</tr>

<tr bgcolor="#CCCCCC">

<td colspan="7">&nbsp;1.2 Official Address:</td>

</tr>

<tr bgcolor="#ffffff">

<td>&nbsp;Name of the Department:<font size="2" color="red">* </font></td>

<td bgcolor="#ffffff" colspan="7"><input type="text" name="deptt_name" size="35" class="ctrl"></td>

</tr>

<tr bgcolor="#ffffff">

<td >&nbsp;Office Address:<font size="2" color="red">* </font></td>

<td colspan="7"><input type="text" name="office_address" size="35" class="ctrl"></td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;State:</td>

<td colspan="1" width="35%"><input type="text" name="state_name" size="12" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;Pin Code:<font size="2" color="red">* </font></td>

<td colspan="5" width="50%"><input type="text" name="pin" class="ctrl" size="10"></td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%" >&nbsp;Office Telephone:</td>

<td colspan="1" width="35%"><input type="text" name="phone_no" size="35" class="ctrl"></td>

<td colspan="6" width="5%"></td>

</tr>

<tr bgcolor="#CCCCCC">

<td colspan="7">&nbsp;1.3 List of Server to access through VPN:<font size="2" color="red">* </font></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7">

<TABLE border="1" class="ctrl" id="addressesTable">

<TR>

<td width="21">&nbsp;</td>

<TD width="150">IP Address of the Server</TD>

<TD width="196">Location of the Server</TD>

<TD width="167">Destination Port</TD>

<TD width="162">Website/URL of Servers</TD>

</TR>

<TR>

<TD>

<INPUT name="chk" type="checkbox" class="ctrl" disabled="disabled"/></TD>

<TD><INPUT name="srvip0" type="text" id="srvip0" class="ctrl" /></TD>

<TD><input name="srvloc0" type="text" class="ctrl" value=""></TD>

<TD><INPUT name="destport0" type="text" id="destport0"class="ctrl" /></TD>

<TD><INPUT name="descrsrv0" type="text" class="ctrl" />

<input type="hidden" name="rowlength" id="rowlength" value="1">

</TD>

</TR>

</TABLE>

</td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7" align="left"><input name="des_ser2" value="Add New" type="button" onClick="addRow('addressesTable')" />

<INPUT type="button" value="Delete" onClick="deleteRow('addressesTable')" /></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7" align="center"><font size="2"><u>DECLARATION</u></font></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7">I hereby declare that<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1. The information provided is correct.<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2. Is responsible for the safety of the Digital Certificate, PIN, Username and Password issued for accessing VPN Service.<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3. I undertake to surrender the VPN account and Digital certificate on transfer / leaving the division.<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4. The certificate and VPN account are issued will be used only for accessing the NIC VPN Service as per the list provided in 1.3.<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5. Will not indulge in any activity and no attempt will be made to gain unauthorized access to other NIC Websites and facilities.<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6. I am responsible for the content/ data uploaded in the servers through VPN connection.<br>

&nbsp;I have read the terms and conditions of NIC VPN Services and will comply with. If at a later stage any information is found to be incorrect or non-compliance with the terms and conditions will result in the cancellation of the DC issued by NIC for NIC VPN service.</td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;Place:<font size="2" color="red">* </font></td>

<td colspan="1" width="35%"><input type="text" name="place" size="12" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;Date:</td>

<td colspan="5" width="50%"><input type="text" name="date" value="${date}" readonly="readonly" class="ctrl" size="10"></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7" align="center"><b>SECTION II : RECOMMENDATION</b></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7">&nbsp;This is to certify that the person as identified in SECTION-I has provided correct information and is authorized on behalf of the organization to update and access servers listed in 1.3.<br>

&nbsp;I shall intimate NIC VPN Division to deactivate the account when the person is transferred / relived from responsibility for which the VPN account and digital certificate is issued.

</td>

</tr>

<tr bgcolor="#CCCCCC">

<td colspan="7">&nbsp;2.1 Verification by Recommending/Reporting/Head of Office</td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;Name:<font size="2" color="red">* </font></td>

<td colspan="1" width="35%"><input type="text" name="r_name" size="12" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;Designation:<font size="2" color="red">* </font></td>

<td colspan="5" width="50%"><input type="text" name="r_designation" class="ctrl" size="10"></td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;E-mail Address:<font size="2" color="red">* </font></td>

<td colspan="1" width="35%"><input type="text" name="r_email" size="12" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;Contact No.:<font size="2" color="red">* </font></td>

<td colspan="5" width="50%"><input type="text" name="r_phone" class="ctrl" size="10"></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7" align="center"><b>SECTION III : Verification by NIC-Coordinator</b></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7" align="left" ><a href="http://webservices.nic.in/webcoord.aspx" target="blank"> <u> &nbsp;Please refer the authorised NIC Web Co-ordinator</a></u></td>

</tr>

<tr bgcolor="#ffffff">

<td colspan="7">&nbsp;User Category: Free / Paid<br>

&nbsp;If free enclose the copy of the approval.<br>

&nbsp;If paid, then confirm the period for which payment is made: From:.................To:.................<br>

&nbsp;Project No. ......................................................................................................................<br>

&nbsp;The web sites mentioned at 1.3 (a) in SECTION-I am correct. The subscriber is the authorized person to update this web site and require VPN Services. Permission may give for the same.<br>

&nbsp;I shall intimate NIC VPN division to deactivate the account when the person is transferred / relived from responsibility for which the VPN account and digital certificate is issued.

</td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;Name:<font size="2" color="red">* </font></td>

<td colspan="1" width="35%"><input type="text" name="c_name" size="12" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;Designation:<font size="2" color="red">* </font></td>

<td colspan="5" width="50%"><input type="text" name="c_designation" class="ctrl" size="10"></td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;E-mail Address:<font size="2" color="red">* </font></td>

<td colspan="1" width="35%"><input type="text" name="c_email" size="12" class="ctrl"></td>

<td colspan="1" width="5%">&nbsp;Contact No.:<font size="2" color="red">* </font></td>

<td colspan="5" width="50%"><input type="text" name="c_phone" class="ctrl" size="10"></td>

</tr>

<tr bgcolor="#ffffff">

<td width="15%">&nbsp;Enter the Letters:<font size="2" color="red">* </font></td>

<td colspan="1" width="20%"><input type="text" name="captchatext" size="12" class="ctrl"></td>

<td colspan="1" width="20%">&quot;</td>

<td colspan="1" width="20%"><input type="image" name="captchaimg" src="/vpn_app/jcaptcha" size="12" class="ctrl"></td>

<td colspan="4" width="25%"></td>

</tr>

</table></td></tr></table>

<img src="img/line9.gif" width="1" height="10" border="0"><br>

</td>

<td background="img/line7.gif"><img src="img/line9.gif" border="0"></td>

</tr>

<tr>

<td width="10"><img src="img/line4.gif" width="10" height="20" border="0"></td>

<td bgcolor="#4682B4" colspan="4" align="right">

<table cellpadding="0" cellspacing="0" border="0">

<tr>

<td class="btn" width="100"><input type="submit" name="Submit" value="Submit" class="btnform"></td>

<td width="1"><img src="img/line9.gif" width="1" height="18" border="0"></td>

<td class="btn" width="100"><input type="reset" name="Reset" value="Reset" class="btnform"></td>

<td width="1"><img src="img/line9.gif" width="1" height="18" border="0"></td>

</tr>

</table>

</td>

</tr>

</table>

</form>

<!-- Footer -->

<table align="center" cellpadding="3" cellspacing="0" width="65%" border="0" height="22">

<tr bgcolor="#DBEAF5">

<td align="center"><font face="Tahoma">For any query please contact VPN Support:</font><font color="blue" face="Tahoma">vpnsupport[at]nic[dot]in</font>

<br>

<font face="Tahoma">Contact No:</font> <font color="blue" face="Tahoma">+91-11-24305391 / 99</font></td>

</tr>

<logic:present name="fail">

${fail}

</logic:present>

</table>

<!-- /Footer -->

</body>

</html>

Connection is the process of linking your website or web application to the mysql database. So it cannot be a data within the database. The login & password or Signup details can be part of the database but not the connection.

Typical roles decision support systems (DSS) play in business modeling are around advocating a certain thought around decision making use of the underlying data. For example : identifying from the underlying data who are the most profitable customers, what products are selling well in a certain market etc ...for organizations DSS could help in cost management as well (where is money getting spent for what) .. it could help in defining marketing strategy, it could help is supply chain management and pretty much in the whole ecosystem of the organization.

There are many differences between Oracle and Access. First, you need to know that Oracle and Access are both relational database engines. Oracle is sold by Oracle Corporation and Access is sold by Microsoft. The biggest differences between the two are the size and number of users each supports. Oracle is a scalable enterprise database engine that supports from one to many (tens to hundreds of thousands) of simultaneous users. Access on the other hand is most commonly used as a single-user database but since the release of Access 97, can be augmented with Visual Basic code and can easily support 100+ simultaneous users (Top limit of 200 users). Oracle can support very large databases (Tens of Terabytes in size or larger), while Access is designed for much smaller databases in the 1 to 2 gigabyte size range. Oracle has a wide range of support features that can be used to monitor and tune database performance - Access is much more limited in its performance tuning capabilities. Microsoft's SQL Server rdbms is a direct competitor with Oracle and has a great many more similarities with Oracle. There are numerous incompatibilities between Access/Jet SQL and Oracle SQL, including, but not limited to the following:

1. The date delimiter is "#" in Access and " ' " (single quote) in Oracle and SqlServer.

2. In CHAR Datatype, Oracle returns trailing spaces. Access does not return trailing spaces in String data type. In Oracle, use VarChar2 Datatype.

3. Jet allows use of the "Join" keyword. Oracle uses "(+)" following the joined field(s). Join is not a recognized word in Oracle.

4. IIF() is allowed in Jet but in Oracle, you must use the DECODE function. See Oracle documentation.

5. The following functions in Jet must be translated in Oracle.

Mid(fld, 2, 2) - Substr(fld, 2, 2)

Left(2) - Substr(fld, 1, 2)

Right(n) - Substr( fld, Instr(...),n)

Len() - LENGTH()

Year(Fld) = 1997 - to_char(Fld, 'yyyy') = '1997'

Month(Fld) = 6 - to_char(fld, 'mm') = '06'

Trim(Fld) - LTrim() or RTrim()

6. Generally, you need to use "to_date('01/23/1978', 'mm/dd/yyyy')" to format a date for comparison in Oracle SQL whereas in Jet Sql you could simply use "#01/23/1978#".

7. "RENAME" is a reserved word in Oracle and is therefore an illegal field or table name, but not in Jet.

8. If a memory variable is used in a SQL statement, and the variable is a string with trailing spaces, Jet will trim the value before comparing to the database field. Oracle will not! Therefore, the following will work in Jet but not Oracle, assuming the Oracle field in VARCHAR[2].

Sql = " ... where fldname = 'abc ' ...."

9. Oracle SQL will not find uppercase data in the database if the value in the SQL statement is lowercase. Assume that the LastName field contains the value 'SMITH' in the Oracle table Policy. Access will make a find on the following SQL and Oracle will not (Like character would be "*" for Access.

select * from Policy where LastName Like 'smith%'

10. Conversion of Memo (Jet) fields to Oracle can be a problem. The only data type in Oracle that is analogous to the Memo in Jet is the Long. Although it can hold up to 2gb of string data, you cannot append more than approximately 5,000 characters to the existing Long field because you exceed the length of the maximum string length in an Oracle SQL Statement.

Additionally, you cannot use such expressions, as the following, usable in Jet, in Oracle. They result in the error, "Invalid use of Long Datatype."

select distinct LONGFLD

Length(LONGFLD)

It seems impossible to use a query to determine rows where there is data in the Long field since a Long field that has '' in it is not Null.

Oracle 8 has Append and Get Chunk commands, but the documentation in the Oracle 7.2 Book does not mention these functions, nor are there any examples of how to update a Long field that exceeds 5,000+ characters.

11. Use of the following sql can be extremely slow in Oracle.

select * from table where policy in

(select policy2 from table2 where .....)

Try using the Oracle Minus operator instead. It uses indexes where the "in (select...)" does not. See the Oracle documentation for usage of the Minus.

12. It is normal, when using Jet, to fill the recordsource property of a data control at design time, even if you are going to fill it with a specific SQL sometime after Form_Load. This is done in order to use the Grid Designer when a data control is bound to a Grid or Combo, etc. However, when the form loads, all such data controls are refreshed. If you have the table name as the data control recordsource, which would be normal for designer use, and assuming that dbSQLPassThrough is being used, the entire table is returned to the client machine and refreshed into the grid, even if the grid is not visible, i.e., on a different tab. In Jet, this will not be the case if "UseExactRow" property is not set and therefore will not take an inordinate amount of time, but in Oracle it could be disastorous!

An easy way to deal with this is to set the recordsource to "" in the Form_Load event, especially if you are connected to Oracle. Later on, your code will set the recordsource to the specific SQL as required. Note that this must be done in the Form_Load because the Grid will be refreshed by the time the Activate Event is fired.

13. Be aware that, when using dbSQLPassThrough, the entire recordset, specified by the SQL, is returned to the client machine, and is therefore readonly. At this point the recordset belongs to the client, and Oracle is out of the picture. In praticality, there is no difference between a Snapshot and Dynaset in passthrough mode.

14. Use of apostrophes (') in names and abbreviations are a problem in SQL. In Access, it may be circumvented by use of the double quote (") to encapsulate string data in the SQL statement instead of the apostrophe, thus allowing the use of the (') in the string. In Oracle, you can use two single quotes ('') to denote an apostrophe. The string below is valid in Oracle Sql.

... Set Lastname = 'O''Toole',...

15. In Access, an empty string ("") is not Null. Oracle's default parameter for Null is set to '' (double single quotes or empty string). In other words, Oracle, by default, treats an empty string field as Null. Therefore, the following code which works in Access, does not work in Oracle.

...Where RTrim(Fld) <> ''.....

In Oracle, change the SQL to:

... Where Fld is not null....

Also, the following sql will not work if a field is Null.

... Where THSTATE <> 'Z'...

Even though the field is null, and therefore <> 'Z', the row containing the Null field will not be returned. In order to get the row, you must enhance the SQL as:

...where (THSTATE <> 'Z' or THSTATE is Null)...

WHATEVER YOU THINK NULL IS, IT ISN'T!

16. When using dbSQLPassThrough with DAO, the RecordsAffected Property will always return -1, and there is apparently no way to determine whether any records were affected by an action sql or not.

17. When printing an error message from ODBC, if you print Error, as in the errors object, you will print "ODBC Call Failed", which is useless. Instead, print Errors(0).Description (or both) and you will get the true error description returned from the ODBC data source.

18. If you are having trouble with a bound data control returning less than the correct number of row, i.e., returns 100 rows when it should have returned 200 or more, set the DefaultCursorType to 1 (ODBC Cursor). For some reason this is not always required, but it will solve the problem of truncated recordsets in a data control connected to Oracle.

19. Access allows an Order By clause at the end of a query that uses a Union, but if you try this in Oracle, it will not work because Oracle ignores the column names in the result set from the Union. Not to worry! You can Order By column positions from the select statement. In other words, if Policy is returning in column 3 of the result set, and you want to order by Policy, then use "Order By 3..."

ER diagrame shows the relationship among entities.

When you open Access, Select NEW. The New tab provides several ways that you can create a new database including "TABLE View" which then looks like a datasheet

They run things using Yahoo+ code. For mor info contact me via my IM .... kaybee_0@yahoo

Java applets are used to provide a self contained application or visually intensive experience to a user visiting a website. They are normally platform independent and as such the same Java applet can be delivered to users using Windows, Apple, or Linux.