Skip to main content

DIFFERENCE BETWEEN DBMS AND RDBMS

Sl.#DBMSRDBMS
1Introduced in 1960s.Introduced in 1970s.
2During introduction it followed the navigational modes (Navigational DBMS) for data storage and fetching.This model uses relationship between tables using primary keys, foreign keys and indexes.
3Data fetching is slower for complex and large amount of data.Comparatively faster because of its relational model.
4Used for applications using small amount of data.Used for complex and large amount of data.
5Data Redundancy is common in this modelKeys and indexes are used in the tables to avoid redundancy.
6Example systems are dBase, Microsoft Acces.Example systems are SQL Server,Oracle.

Comments

Post a Comment

Popular posts from this blog

DIALOG BOX SHOW CODE IN SWING JAVA

import javax.swing.*; import java.awt.event.*; public class Dialog {   JFrame frame;   JPanel p;   public Dialog(){   frame = new JFrame("Show Message Dialog");   p=new JPanel();   JButton button = new JButton("Click Me");   button.addActionListener(new MyAction());     p.add(button);   frame.add(p);   frame.setSize(400, 400);   frame.setVisible(true);   frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);   }   public class MyAction implements ActionListener{   public void actionPerformed(ActionEvent e){   JOptionPane.showMessageDialog(frame,"My DialogBox");   }   }  public static void main(String[] args)  {     Dialog db = new Dialog();   } }
Post a Comment
Read more

DATABASE UPDATION CODE IN VB.NET

Private Sub BTNUPDATE_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNUPDATE.Click         connetionString = " Data Source=KEERTIG-PC\SQLEXPRESS;Initial Catalog=GAURAV1;Integrated Security=True"         connection = New SqlConnection(connetionString)         sql = "UPDATE ROOM_BOOKING SET FIRST_NAME= '" & TXTBSFNAME.Text & "',MIDDLE_NAME= '" & TXTBSMNAME.Text & "',LAST_NAME= '" & TXTBSLNAME.Text & "',NUM_OF_ROOM= '" & TXTBSNOROOM.Text & "',NUM_OF_DAYS= '" & TXTBSNODAYS.Text & "',MOBILE_NO= '" & TXTBSMOBNO.Text & "',ADDERESS= '" & TXTBSADDRESS.Text & "',ROOMBK_PRICE= '" & TXTBSPRICE.Text & "' WHERE ROOMBK_ID = '" & TXTBSBID.Text & "'  "         Try             connection.Open()             MsgBox(...
Post a Comment
Read more

ABOUT VB6.0

Introduction Þ Visual Basic is a tool that allows you to develop Windows (Graphic User Interface – GUI ) applications. The applications have a familiar appearance to the user. Þ Visual Basic is event-driven ; event driven meaning code remains idle until called upon to respond to some event (button pressing, menu selection). Visual Basic is governed by an event processor. Þ The original Visual Basic for DOS and Visual Basic for Windows were introduced in 1991. Steps in Developing Application There are three primary steps involved in building a Visual Basic application: 1. Draw the user interface 2. Assign properties to controls 3. Attach code to controls Rule for Variable Variables are used by Visual Basic to hold information. Þ No more than 40 characters Þ They may include letters, numbers, and underscore (_) Þ The first character must be a letter Þ You cannot use a reserved wor...
Post a Comment
Read more