Scribd
Upload
36 views3 pages

Data Dictionaries: Admin - Master

The document defines several data dictionaries containing fields for storing user, course, content, quiz, and result data. The ADMIN_MASTER, LEARNER_MASTER, and INSTRUCTOR_MASTER dictionaries contain identifying and contact information for administrators, learners, and instructors. The COURSE_MASTER dictionary contains course details, the CONTENT_MASTER contains associated content, the QUIZ_MASTER contains quiz properties, and the QUESTION and RESULT dictionaries contain quiz questions and learner results. Primary and foreign keys are indicated to show field relationships across the different tables.

Uploaded by

SamarRaguvanshi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
36 views3 pages

Data Dictionaries: Admin - Master

The document defines several data dictionaries containing fields for storing user, course, content, quiz, and result data. The ADMIN_MASTER, LEARNER_MASTER, and INSTRUCTOR_MASTER dictionaries contain identifying and contact information for administrators, learners, and instructors. The COURSE_MASTER dictionary contains course details, the CONTENT_MASTER contains associated content, the QUIZ_MASTER contains quiz properties, and the QUESTION and RESULT dictionaries contain quiz questions and learner results. Primary and foreign keys are indicated to show field relationships across the different tables.

Uploaded by

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

Data Dictionaries

ADMIN_MASTER
P/F Field Name Data Type Comment

P admin_id INTEGER ADMIN ID

Name VARCHAR NAME

Email VARCHAR EMAIL ADDRESS

Password VARCHAR PASSWORD

phone_no NUMERIC CONTACT NO

LEARNER_MASTER
P/F Field Name Data Type Comment

P LID INTEGER LEARNER

FIRST_NAME VARCHAR FIRST NAME

LAST_NAME VARCHAR LAST NAME

EMAIL VARCHAR EMAIL

PASSWORD VARCHAR PASSWORD

PHONE_NO NUMERIC CONTACT NUMBER

CITY VARCHAR CITY

STATE VARCHAR STATE

COUNTRY VARCHAR COUNTRY

PINCODE NUMERIC PINCODE

BLOCKED INTEGER IF USER IS BLOCKED 1

INSTRUCTOR_MASTER
P/F Field Name Data Type Comment

P IID INTEGER LEARNER

FIRST_NAME VARCHAR FIRST NAME

LAST_NAME VARCHAR LAST NAME

EMAIL VARCHAR EMAIL

PASSWORD VARCHAR PASSWORD

PHONE_NO NUMERIC CONTACT NUMBER

COUNTRY VARCHAR COUNTRY

PINCODE NUMERIC PINCODE


P/F Field Name Data Type Comment

CERTIFIED NUMERIC USER IS CERTIFIED BY ADMIN

BLOCKED INTEGER IF USER IS BLOCKED 1

COURSE_MASTER
P/F Field Name Data Type Comment

P COURESE_ID INTEGER COURSE ID

F IID INTEGER INSTRUCTOR ID

COURSE_TITLE VARCHAR COURSE TITLE

COURSE_DESCRIPTION VARCHAR DESCRIPTION

CONTENT_MASTER
P/F Field Name Data Type Comment

F COURESE_ID INTEGER COURSE ID

COURSE_NO INTEGER INSTRUCTOR ID

CONTENT_TITLE VARCHAR COURSE TITLE

VIDEO_LINK VARCHAR DESCRIPTION

QUIZ_MASTER
P/F Field Name Data Type Comment

P QUIZ_ID INTEGER COURSE ID

F COURSE_ID INTEGER INSTRUCTOR ID

NO_OF_QUES INTEGER COURSE TITLE

QUESTION
P/F Field Name Data Type Comment

P QUIZ_ID INTEGER COURSE ID

F QUESTION_NO VARCHAR INSTRUCTOR ID

QUESTION VARCHAR COURSE TITLE

OPTION1 VARCHAR

OPTION2 VARCHAR

OPTION3 VARCHAR

OPTION4 VARCHAR

ANSWER INTEGER
RESULT
P/F Field Name Data Type Comment

P QUIZ_ID INTEGER COURSE ID

F LID INTEGER INSTRUCTOR ID

MARKS INTEGER COURSE TITLE

You might also like