Author Topic: a minidatabase management system  (Read 3078 times)

Offline kanika

  • STP Newbie
  • *
  • Thank You
  • -Given: 0
  • -Receive: 3
  • Posts: 5
  • Rating : +3/-0
a minidatabase management system
« on: October 05, 2007, 07:02 AM »
==============================================================================================================================================================================================================================================
The objective of this project is to design and implement a prototype database management system(named IOTA), which, along with answering different queries, such as create, insert, select; also maintains indexes for fast retrieval of output.
==============================================================================================================================================================================================================================================


Our database management system takes the input in the following form:

1. CREATE TABLE query
  -------------------- 

        Create table <table name>
          { att1  data_type1  constr1  constr2 ? const n,
            att2  data_type2  constr1  constr2 ? const n,
                  ?.
            attn data_typen  constr1  constr2 ? const n
          } ;


2. INSERT INTO query
   ------------------

      Insert into <tablename> values
         ( val1, val2, val3, ?. Valn) ;


3. DESCRIBE schema query
   ----------------------

      Describe <table-name> ;


4. SELECT FROM TABLE query ( max 3 clauses in "where" condition with AND and OR)
   --------------------------
   
      select <att 1>, <att 2>,  ?   <att n>
      from   <tablename1>   ,<tablename2>
      where   <attname> = <val>
            AND <attname>= <attname>
            OR <tablename1.attname> = <tablename2.attname> ;
         
5. UPDATE TABLE query
   -------------------

      update <table name>
      set    <attribute name> = <value>
      where  <attribute2 name> = <value2> ;

6. DELETE FROM TABLE query
   -------------------------

      delete from <tablename>
      where <attribute name> = <value> ;


      
=======================================================================================================================

Language used    :  C++
Platform         :  Windows XP
GUI              :  command line interface
Compiler         :  Dev C++ 4.9.9.2


P.S. Compile all the files and then run them.
=======================================================================================================================   

FOR ANY PROBLEM REGARDING SOURCE CODE OR IN RUNNING THE CODE PLZ ASK.....

 
« Last Edit: October 05, 2007, 07:04 AM by kanika »

   

Offline narasimhaiah

  • STP Newbie
  • *
  • Thank You
  • -Given: 0
  • -Receive: 0
  • Posts: 1
  • Rating : +0/-0
Re: a minidatabase management system
« Reply #1 on: December 22, 2007, 07:08 AM »
pls send me source code for securing web communications project (documentation is available in google but source code is not availlable) pls urgent

Tags:
 

Related Topics

  Subject / Started by Replies Last post
0 Replies
2161 Views
Last post June 26, 2009, 09:08 PM
by sarkozy
1 Replies
3068 Views
Last post November 07, 2010, 10:26 PM
by maravinda
0 Replies
1002 Views
Last post March 25, 2011, 10:43 PM
by onimbomark
0 Replies
817 Views
Last post August 05, 2011, 01:34 AM
by james_tan
0 Replies
1045 Views
Last post August 09, 2011, 01:36 AM
by vishusonawane
0 Replies
549 Views
Last post December 07, 2011, 06:30 AM
by brameshnift
0 Replies
356 Views
Last post March 29, 2012, 01:47 AM
by Creespy

Jokes on Sardar