User Comments for the tutorial:

Designing Database

Total comments: 8      View Tutorial    Discuss: Designing Database




difference between primary and foreign key?  

PK vs UK
Primary key: for a relational database to work, every record needs to be identified on its own. Unique key: you can specify that certain data in your dbms must be unique. These are constraints and can be added to more then one field at a time 

primary key and foreign key
A primary key provide a unique way to identify each record in a table. A foreign key may or may not be a primary key in the present table but should be a primary key of another table, thus its purpose is to relate the two tables.  

loginid as Unique Key
As much as I know Unique key can be NULL, and each and every user will be mandatorily have one loginid in this application then why here in the database you declared loginid as a UNIQUE KEY. 

About java
Hi. Give me information about project. 

TYPE is not preferred term
As per the MySQL 5.0 manual - The older term TYPE is supported as a synonym for ENGINE for backward compatibility, but ENGINE is the preferred term and TYPE is deprecated. 

java code
very good coding 

Related Tutorial and Articles

Java Spring Framework Programmer
; Keywords: Spring, Spring Framework, Java, Core Java, Struts, EJB, JSP ... Java Spring Framework Programmer        Position Vacant: Java Spring Framework 


Java Struts 2 Programmer
Java Struts 2 Programmer      ... Years  Keywords: Software developer, Java Programmer, Struts Programmer... ID: Java Struts 2 Programmer 


Java Hibernate 3 Programmer
Java Hibernate 3 Programmer        Position Vacant: Java Hibernate 3 Programmer Job...; Reference ID: Java Hibernate 3 Programmer 

Hibernate Questions

Struts Hibernate Spring - Hibernate
Struts Hibernate Spring  HI Deepak, This is reddy.i want expamle for struts hibernate spring example.  Hi Friend, Please visit the following link: 

Struts Questions

Integration Struts Spring Hibernate.
Integration Struts Spring Hibernate.  Integration Struts Spring Hibernate 

Web Services

Web Programmer
; designing on Java/PHP/.Net. platform. Thorough knowledge of Linux... of Java/PHP/.Net. Advanced database concepts. Proven affinity with large... Web Programmer       

Struts Examples

Integrate Struts, Hibernate and Spring
Integrate Struts, Hibernate and Spring   ... are using one of the best technologies (Struts, Hibernate and Spring). This tutorial...:// We are using Struts version Download Hibernate 

Hibernate Questions

Struts Hibernate Spring - Login and User Registration - Hibernate
Struts Hibernate Spring - Login and User Registration  Hi All, I fallowed instructions that was given in Struts Hibernate Spring, Login and user.... 

Hibernate Questions

What is Spring Struts Hibernate DAO Layer?
What is Spring Struts Hibernate DAO Layer?  Hi, explain me the difference in between Spring Struts Hibernate DAO Layer? Thanks   Hi... Spring Struts Hibernate DAO Layer. Thanks 

Java Technology Tutorials

Understanding Spring Struts Hibernate DAO Layer
Understanding Spring Struts Hibernate DAO Layer... how Spring Hibernate and Struts will work together to provide best solution for any web based application.   Understanding Spring Struts