Create a database that contains two tables Students [username: text, password te

Question

Create a database that contains two tables Students [username: text, password text, mark number] Quizzes [question# number. c1:text.c2 text. c3 text. c4 text, answer text] Develop a form to allow the student to access the quiz Write a script check that user name and password are required Write a script to check whether the username and password keyed by a user are correct by comparing them to the values registered in the database, if so; forward the student to the quizForm A student is forwarded to the registrationForm if s/he clicks on the button sign In. Write a script to display a question from the database every 10 seconds. Populate the select options from the database. Render the correct answer when a user selects an option and Increment the mark if the answer is correct or Write a sorry message

Explanation / Answer

               ( StudentID int(9) NOT NULL auto_increment,

                username VARCHAR(40) NOT NULL,

password VARCHAR(08) NOT NULL,

mark int(9)NOT NULL,

PRIMARY KEY(StudentID) );

CREATE TABLE 1 Quizzes

(question int(9)NOT NULL,

C1 VARCHAR(40) NOT NULL,

C2 VARCHAR(40) NOT NULL,

C3 VARCHAR(40) NOT NULL,

answer VARCHAR(40) NOT NULL,);

CREATE TABLE users (

username VARCHAR(16) PRIMARY KEY,

password VARCHAR(8),

email VARCHAR(255),

birthday DATE,

gender ENUM('M', 'F')

);

CREATE TABLE quiz_answers (

username VARCHAR(16) REFERENCES users,

question1 VARCHAR(10),

question2 INT,

question3 ENUM('YES', 'NO', 'MAYBE'),

question4 BOOLEAN,

question5 VARCHAR(25),

submitted_at DATETIME,

PRIMARY KEY (username, submitted_at)

);

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.