schema for quiz database system

newbie5050 · #1 (**permalink**) 09-13-07, 12:30

hi guys, i am a newbie so sorry if this is a stupid question!!
I need to create a database schema/diagram for a php assignment that incorperates the following criteria...

-user logs in, ie: a user table
- user can attemp one of many quizzes, thus producing a number of results...
- user has extra privileges on a quiz that he is the top scorer on
- quiz has only one master (top scorer)
- there is a large number of quizzes

all i need is the actual database setup, as i am pretty good with php, so any help will be much appreciated!!!

r937 · #2 (**permalink**) 09-13-07, 13:38

"assignment"

LOL

we don't do homework questions on dbforums.com

however, we will gladly guide you as you learn SQL, young paduwan

however, we will not do the work for you

show us your attempt, and we will gladly critique it

Ryker · #3 (**permalink**) 09-14-07, 06:37

Surely this is in the wrong forum ....

The question could apply to any databasing system.

georgev · #4 (**permalink**) 09-14-07, 07:06

Correct. Moved to Database Design & Concepts topic.