http://msdn.microsoft.com/vstudio/express/visualc/

Visual C++ Express - download for free

1. New Project
2. Win32 -> Console Application
3. Application Settings  Empty Project
4. Right Click on Source Files -> Add Item
5. Code -> C++ (.cpp)

Object Oriented Database

• Designing a database using concepts of OO:
•     Encapsulation   (class)
•     Inheritance       (a class can inherit from another class)
  
                     General Class (Student)
  
                     Subclasses  (Undergraduate Student, Graduate Student)
   
•     Polymorphism  (same name, many implementations)
  
                     Add (student or course)
  
  Represent Database Objects as Programming Objects
  Tables -> Class
  Fields -> Attributes
  Record -> Object
  
  Relational Databases
  Entity Relationship Diagram (ER Diagram)
    Defining Entities and their Relationships (1-1, 1-M*, M-M )
                                                                           zero or more
  
  Implement Relationship in Object Oriented Database
   Classes must share common data member
        (for example, Student class may contain Course id)
  Pointers (for example, include a reference (pointer) to course  object)
   

  class student{

              public:

                          string fname, lname, major;

                          double gpa;
  
                          int courseId[3]; //course ids *primary key

  }; //student

   
     Add to Student Class the courseID
     Modify:
                addStudent() - Ask the id of courses taken
  
                load() - for student.txt, read courseIds
                  ex.  studentFile>>s[n].fname>>s[n].lname>>s[n].major>>s[n].gpa>>s[n].courseId[0]>>s[n].courseId[1]>>s[n].courseId[2]
  
                store() - for students.txt, write courseIds
                  ex. 
  studentFile<<s[i].fname<<" "<<s[i].lname<<" "<<s[i].major<<" "<<s[i].gpa
  <<" "<<s[i].courses[0]<<" "<<s[i].courses[1]<<" "<<s[i].courses[2]<<endl;
  
  students.txt - add course ids to student record
  
  Create Report (ex. Transcript listing Student Info and Courses)
   

  Menu Example:
                              
   

            Welcome to SUNY OW Database

          Student Menu (S)

          Course Menu (C)

          Exit (E)

  ---

  Student Menu

          Add (A)

          Update (U)

          Search by Last Name (L)

          Search by ID (I)

          Save (S)

  ---

   

  Course Menu

          Add (A)

          Update (U)

          Search by CRN (L)

          Save (S)