| Home | Sign up! | Projects | Seminars | Research Notes | Today's Lecture | About |
Member ID: 42

Sanjay Chopra


Profile: I love programming and I have knowledge of C++, PHP, HTML, JAVA, MYSQL and MFC applications. I also love to read journals and magazines and a few of them are Harvard Business Review, PC Quest etc. I want to become a System Analyst in any reputed software firm and I want to do something for my country (INDIA). I am currently studying at AIT,Gurgaon, which is in collaboration with US universities. I am studying under Tarleton State University (Computer Information Systems). I am also working for an International Magazine"Ready To Go?" as a Student Representative.
I have completed my vocabulary database.If anybody wants to play with it.Here is the link

PROJECT: The Vocabulary Database

Prof. Ashay Dharwadker's Courses (2):

Information SystemsFall 2003View
Database SystemsFall 2003View

Projects (2)

Project ID: 40
Course: Database Systems
Topic: SanjayShop
Description: I have made a MySQL relational database for an automobile service shop. One can store customer information. Then one can calculate the customer’s bill by using queries. We can use many functions like TRIM, CASE and UNION. One problem is how to correctly load files into MySQL. How to one can add entries, sub queries using WHERE clause, HAVING clause, GROUP clause, JOIN clause, SELECT using various functions. I am still working on the security aspect of the database.

Project ID: 41
Course: Information Systems
Topic: Database Interface
Description: Ankit and I are making a project on words, their roots and meanings (etymology). See Ankit's page for a description of the tables. The database will be in MySQL with an Html/PHP frontend. We have prepared PHP code for our Database Project which will look like this:
Root Derived Word Meaning
Ophthalmos (eye) Ophthalmologist The physician whose speciality is disorders of vision
Opsis (sight) Optometrist One who measures vision
Optician One who fills an ophthalmologist’s or optometrists’ prescription
Optical Dealing with the eye or vision
Orthos (straight) Orthopaedist One who treats skeletal deformities
Orthodontist Specialist who straightens teeth
Kardia (heart) Cardiologist Specialist who treats disorders of the heart and circulatory system
Cardiac Pertaining to the heart
Cardiogram Electrically produced record of the heart beat
Cardiograph The instrument which produces a cardiogram
Neuron (nerve) Neurologist One who treats disorders of the brain, spinal cord and nervous system
Neuralgia Acute pain along the nerves and their branches
Neuritis Inflammation of the nerves
Neurosis Emotional or personality disorder
Neurotic A person suffering from neurosis
Geras (old age) Geriatrics Speciality dealing with medical needs of the elderly

Seminars (2)

Seminar ID: 36
Course: Database Systems
Topic: MySQL Queries
Description: Ankit and I gave a seminar on following SQL queries.
  • Update
  • Insert
  • Where
  • Alter

Seminar ID: 37
Course: Information Systems
Topic: Algorithms and Number Theory
Description: Ankit and I gave a seminar on algorithms and number theory. We covered the following topics.
  • Perfect Numbers.
  • Amicable Numbers.
  • Goldbach conjecture.
  • Mersenne Primes.
  • How to swap two values without using temporary variable. Algorithm: Given (a,b). Put a = a + b. Put b = a - b. Put a = a - b. Hence done.

    Research Notes (2)

    Research Note ID: 41
    Course: Information Systems
    Topic: SQL queries using MFC/VC++ Applications
    Description: Here I will step you through a small application that will retrieve rows from your database and display them in a list box conrol.

    ENTER sanjayshop(DATABASENAME) > OK
    The wizard creates a form. The new form has two buttons OK and CANCEL. Add the lines which is given in the step 1 of the table. These lines make access to the ADO Library. Close and Save it.

    2: Add two functions which is given in step 2 of table. close and save it this file. Add list box onto form and declare its variable using class wizard. Change the following things while add it as member variable.
    VARIABLE NAME = m_lbpart.
    CATEGORY = Control.

    3: All you have left to do is write the code that will run a Query and populate the list box. DOUBLE CLICK on button OK and that will open a dialog box ask you , what you want to name the function for its CLICK event.Left name as OnOK()the default pone.
    Add the code which is given in the table. After the variable are declared , a connection string is assigned to bConn and a query string is assigned to vQuery. An instance of a recordset object is created , and then its OPEN method connects to the database , runs query , and stores its results. After that loops is run that moves through each row in the result set. In the loop the description column is copied to a variable and added to the list box. BY , default the list box will automatically sort the strings as they are added.


    STEPS (1-3)

    1: //File view > header file folder > StdAfx.h
    #import"c:\program files\common files\system\ado\msado15.dll"no_namespace rename ("EOF","adoEOF")
    2: // Add two functions for initializing Ado.
    class view > CsanjayshopApp > InitInstance
    BOOL CsanjayshopApp::InitInstance()
    { AfxOleInit();
    (several more lines already exist there) }
    3: After adding function for button write the following code under that.
    void CsanjayshopDlg::OnOK()
    { //CDialog::OnOK();
    _RecordsetPtr pRecordSet;
    _variant_t vRecordSetField;
    Cstring sRecordSetField;
    _bstr_t bConn("Provider=SQLOLEDB.1" Persist Security Info=True; User ID=root; password=;Initial Catalog=sanjayshop;Data Source=local host");
    _variant_t vQuery(" SELECT * from PART ;");
    { vRecordSetField = pRecordSet->GetCollect(L"Description");
    sRecordSetField = vRecordSetField.bstrVAL;

    Research Note ID: 42
    Course: Database Systems
    Topic: Authorization
    Description: In DBMS, DBA (Data Base Administrator) is the central authority for managing a data base systems. The data base administrator’s includes granting privileges to user who needs to use the system and classify user and data in accordance with the policy of the organization . This is known as AUTHORIZATION.
    Authorization is a process that includes all the techniques for protecting the database against persons who are not authorize to access either certain part of the database or the whole database.
    DBA privileged commands include commands for granting and revoking privileges to individual account, user or groups and for performing the following types of action.
    1. Account creation: This creates a new account and password for a user to access Data Base.
      SYNTAX ….
      GRANT USAGE on *.* TO username@localhost identified by password;
      Eg. Grant usage on *.* to sanjay@localhost identified by sanjay;
    2. Privilege granting: This action permits the DBA to grant certain privileges to certain accounts.
      SYNYAX …
      Eg. Grant SELECT, DELETE, UPDATE on sanjayshop to Ankit;
      (By this Ankit can only update, delete, select in my database).
    3. Privileges revocation: This action permits DBA to revoke (cancel) certain privileges that were previously given to certain accounts.
      SYNTAX …
      Eg. REVOKE DELETE, UPDATE on sanjayshop to Ankit;
      (By this now Ankit can only select in my database.because I cancelled his power for delete and update).
      Note : Here queries meant that which function do you want to allow to the user to access Database.

    Last updated on Sunday, 29th February 2004, 09:38:50 AM.

    Prof. Ashay Dharwadker