Create the entity relationship diagrams and tables of the relevant database

Watch this thread
G.uye
Badges: 2
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#1
Report Thread starter 2 years ago
#1
Design a database for the online exam system over the internet. The TC identity number, name, surname, username, password, email address, date of birth information of the members are stored on the database. The teacher information is stored on the database, and the ID number, name, surname, date of birth, username, password and branch details of the teachers are stored. There can be more than one teacher in a branch. Lessons and tests for each lesson are stored on the system. The name, code and credit information of the courses are kept. Each lesson has one or more tests. Name and level information of the tests are stored. Each test consists of questions, the text of the questions, the options (5 pieces) and the correct answer are stored. The questions are prepared by the teacher. A teacher can prepare multiple tests and multiple questions. The date and time information that the teachers prepared the questions and tests are also stored in the database. Members can solve the questions in the tests due to their tests. One question can be solved by more than one member, one member can solve more than one question. The answers given by the members to the questions, the date and time of solving the question and the number of threads are stored in the database. Create the entity relationship diagrams and tables of the relevant database
0
reply
uwu :D
Badges: 7
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#2
Report 2 years ago
#2
(Original post by G.uye)
Design a database for the online exam system over the internet. The TC identity number, name, surname, username, password, email address, date of birth information of the members are stored on the database. The teacher information is stored on the database, and the ID number, name, surname, date of birth, username, password and branch details of the teachers are stored. There can be more than one teacher in a branch. Lessons and tests for each lesson are stored on the system. The name, code and credit information of the courses are kept. Each lesson has one or more tests. Name and level information of the tests are stored. Each test consists of questions, the text of the questions, the options (5 pieces) and the correct answer are stored. The questions are prepared by the teacher. A teacher can prepare multiple tests and multiple questions. The date and time information that the teachers prepared the questions and tests are also stored in the database. Members can solve the questions in the tests due to their tests. One question can be solved by more than one member, one member can solve more than one question. The answers given by the members to the questions, the date and time of solving the question and the number of threads are stored in the database. Create the entity relationship diagrams and tables of the relevant database
wait what
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest

Were exams easier or harder than you expected?

Easier (54)
27.14%
As I expected (65)
32.66%
Harder (72)
36.18%
Something else (tell us in the thread) (8)
4.02%

Watched Threads

View All