GIDForums  

Go Back   GIDForums > Computer Programming Forums > C++ Forum
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread
  #1  
Old 16-Nov-2006, 19:38
shinx shinx is offline
New Member
 
Join Date: Nov 2006
Posts: 2
shinx is on a distinguished road

need help - simple database in c++


i'm not asking about the complete code.. but i have no idea how to design it.
it would be nice if someone can explain me in uml diagram..

thanks

Design and implement a simple school grade report system.


1. An administrator can assign a class to an instructor
2. A student can enroll a class
3. An instructor can submit grades for a class he/she is teaching.
4. A student can request for a complete grades report of all courses he/she has enrolled.

You need following basic tables for this report system:
1. Student table that contains all students with following information:
a. Id (key, must be unique within this table)
b. First name
c. Last name
2. Instructor table that has all instructors with following columns
a. Id (key, must be unique within this table)
b. First name
c. Last name
5. A class table has following information:
a. Id (key, must be unique within this table)
b. CourseNumber ( i.e. CS555 )
c. InstructorId
d. Year
e. Term

You need following relationship table:

6. ClassStudent
a. ClassId
b. StudentId
c. CourseNumber
d. Grade
Note: ClassId + StudentId must be unique within this table

You need to design different indices to handle searching this system needs.

Hint: student and instructor have many similarities.
  #2  
Old 20-Nov-2006, 21:34
davis
 
Posts: n/a

Re: need help - simple database in c++


Quote:
Originally Posted by shinx
i'm not asking about the complete code.. but i have no idea how to design it.
it would be nice if someone can explain me in uml diagram..

thanks

Design and implement a simple school grade report system.


1. An administrator can assign a class to an instructor
2. A student can enroll a class
3. An instructor can submit grades for a class he/she is teaching.
4. A student can request for a complete grades report of all courses he/she has enrolled.

You need following basic tables for this report system:
1. Student table that contains all students with following information:
a. Id (key, must be unique within this table)
b. First name
c. Last name
2. Instructor table that has all instructors with following columns
a. Id (key, must be unique within this table)
b. First name
c. Last name
5. A class table has following information:
a. Id (key, must be unique within this table)
b. CourseNumber ( i.e. CS555 )
c. InstructorId
d. Year
e. Term

You need following relationship table:

6. ClassStudent
a. ClassId
b. StudentId
c. CourseNumber
d. Grade
Note: ClassId + StudentId must be unique within this table

You need to design different indices to handle searching this system needs.

Hint: student and instructor have many similarities.


Take a look at SQLite.


:davis:
 
 

Recent GIDBlogUS Elections and the ?Voter?s Responsibility? by crystalattice

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Classes and database arrays brookeville C++ Forum 1 13-Apr-2005 01:26
Limit combo box and date time picker choice according to database created in folder shinyhui C++ Forum 0 22-Feb-2005 21:16
Limit combo box and date time picker choice according to database created in folder shinyhui MS Visual C++ / MFC Forum 0 22-Feb-2005 03:13
Limit combo box choice according to database created in folder shinyhui MS Visual C++ / MFC Forum 3 21-Feb-2005 22:58
cgi txt database to mysql erhanharputlu MySQL / PHP Forum 0 27-Sep-2004 02:30

Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The

All times are GMT -6. The time now is 18:10.


vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.