+- +-

Stats

Members
Total Members: 26
Latest: Elio63
New This Month: 5
New This Week: 0
New Today: 0
Stats
Total Posts: 237
Total Topics: 90
Most Online Today: 5
Most Online Ever: 25
(February 16, 2020, 02:51:53 pm)
Users Online
Members: 0
Guests: 0
Total: 0

DD's Top Posters

Michael
Posts: 270
ComputerTech
Posts: 2
ranman256
Posts: 1
Elio63
Posts: 1
jall
Posts: 1

Author Topic: Concept of design  (Read 22 times)

Offline Michael

  • Administrator
  • Sr. Member
  • *****
  • Posts: 270
  • Karma: +0/-0
  • Db Dreams Owner
  • Location: Margate, Kent, UK
  • Referrals: 2
Concept of design
« on: January 05, 2020, 01:08:18 pm »
Taken from my project manager.

This may change over the life time of this project.

This project is not expected to be started until We return from 2 weeks in spain in feb 2020

Quote
It's not expeced to have access to the Contestants info except there names and maybe a postcode this could then be used to see if questions have been put to that person before.

Quiz nights can be run as questions put to a group/Team and the correct answer applied to that group/team or questions could be put to individual
contestants with a score beng allied to each person, The questions can be of a number of topics which may or may not be worth x points depending on the perceived difficulty of the question.

The person running the quix should have to option of a running total I.E. marking a person as who answers a question with a correct or incorrect or
 using a paper system and totalling everything at the end of the quiz.


Basic stucture as of 05/01/2020 this  is pre paper layout with basic keys

Code: [Select]
Tables
1. tblQuestions: Fields: QID(K), Question (Txt), Answer(Txt), CategoryID (fk)(Lng), LevelID (fk)(Lng),
 Qpicture (Txt), Qstatus (Bo), Used (Lng)
        Holds all questions that can be asked at events.
 
3. tblQuestionSets: Fields: QSID(K), QID (FK)(lng), QEID(FK)(lng)
 
5. tblQuestionsEvents: Fields: QEID (k), EID (fk)(lng),
 
7. tblEvents: Fields: EID (K), EventDate (Date)
 
9. tblLocations: Fields: LocID(k)

11. tblCategories: Fields: CategoryID (k), CategoryName (txt)

13. tblPreferences: Fields: PrefID (Number) SecuritySet (Int)

15. tblLevels: Fields: LevelID (k), LevelName (txt), Points (int),

17. tblUsers: Fields: UserID (k),LoginName (txt), Password (txt)
 
19. tblAttendees: Fields: AttID (k)

21. tblAttendeesEvents: Fields: AttEvID (K)
« Last Edit: January 26, 2020, 10:34:23 pm by Michael »

Share on Facebook Share on Twitter


 

Downloads

Free To Use Programs

Chart Tracker Elite 2020

Works Manager

Contact Manager

Simple Home Accounts

Book Library

Picture Library

 

Under Development

Quiz Master 2020

 

Developer Tools

Style Manager

 

Open Code Examples

Employee Example V4

Small Examples

 

Recent Topics

Project Status by Michael
Today at 12:48:57 pm

Validating Form (Require Entry in fields) by Michael
February 21, 2020, 09:13:44 pm

Re: UK Singles/Albums Charts 14 Feb 2020 To 20 Feb 2020 Analysis by Michael
February 17, 2020, 09:46:45 pm

UK Singles/Albums Charts 07 Feb 2020 To 13 Feb 2020 Analysis by Michael
February 16, 2020, 09:03:32 pm

64 Bit Versions by Michael
February 15, 2020, 03:18:42 pm