Scribd
Upload
132 views5 pages

Data Dictionary

The document contains data dictionaries describing various tables in a database for a practice quiz application. The tables include: 1) A user details table with fields like user ID, name, email, password and status. 2) A practice quiz table with fields like quiz ID, user ID, title, content and creation date. 3) A practice quiz answers table linking answers to quizzes and users with fields like answer, date. 4) A scores table linking user scores to quizzes with fields like score ID, user ID, quiz ID and score. 5) A user management table with basic user data fields. 6) A notifications table to store messages, users

Uploaded by

Eric P. Poblete
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
132 views5 pages

Data Dictionary

The document contains data dictionaries describing various tables in a database for a practice quiz application. The tables include: 1) A user details table with fields like user ID, name, email, password and status. 2) A practice quiz table with fields like quiz ID, user ID, title, content and creation date. 3) A practice quiz answers table linking answers to quizzes and users with fields like answer, date. 4) A scores table linking user scores to quizzes with fields like score ID, user ID, quiz ID and score. 5) A user management table with basic user data fields. 6) A notifications table to store messages, users

Uploaded by

Eric P. Poblete
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

DATA DICTIONARY OF USER DETAILS

Field Index Data Type Size Description

user_id PK INT 100 Unique identifier number for the


user id
first_name VARCHAR 50 First name of the user

last_name VARCHAR 50 Last name of the user

email VARCHAR 100 Email address of the user

password VARCHAR 50 Password for user authentication

otp BIGINT 20 One-Time Password for user


verification
status VARCHAR 20 User Status (Verified, or not)
DICTIONARY OF PRACTICE QUIZ

Field Index Data Type Size Description

quiz_id PK INT 100 Unique identifier number for the


practice quiz
user_id FK INT 100 User ID of the creator of the
practice quiz
quiz_title VARCHAR 100 Title of the practice quiz

quiz_conten Text 100 Content/questions of the practice


t quiz
created_at DATETIME Date and time when the practice
quiz was created

DATA DICTIONARY OF PRACTICE QUIZ ANSWER


Field Index Data Type Size Description

answer_id PK INT 100 Unique identifier number for the


practice quiz answer
quiz_id FK INT 100 Practice Quiz ID associated with
the answer
user_id FK INT 100 User ID of the student answering
the practice quiz
answer VARCHAR 100 Answer provided by the student
for the practice quiz
answered_at DATETIME Date and time when the quiz was
answered
DATA DICTIONARY OF SCORES
Field Index Data Type Size Description

score_id PK INT 100 Unique identifier number for the


score
user_id FK INT 100 User ID of the student for whom the
score is recorded
quiz_id FK INT 100 Practice Quiz ID for which the
score is recorded
score DECIMAL 100 Score obtained by the student for
the practice quiz

DATA DICTIONARY OF USER MANAGEMENT


Field Index Data Type Size Description

user_id PK INT 100 Unique identifier number for the user id

first_name VARCHAR 100 First name of the user

last_name VARCHAR 100 Last name of the user

email VARCHAR 100 Email address of the user

DATA DICTIONARY OF NOTIFICATION


Field Index Data Type Size Description
notification_id PK INT 100 Unique identifier number for the
notification
user_id FK INT 100 User ID for whom the
notification is intended
message VARCHAR 500 Notification message content
created_at DATETIME Date and time when the
notification was created
DATABASE DESIGN
Entity-Relationship Diagram

You might also like