I have a project from object oriented programming course: I need to make a question bank and exam preparation program with C# language and I need to add a database to this project and I did a little bit, but I need to print the codes I prepared in the exam preparation form to the exam application keran I prepared, how can I do this?
CREATE DATABASE SoruBankasi;
USE SoruBankasi
CREATE TABLE School Levels (
SchoolDuzeyiID INT AUTO_INCREMENT PRIMARY KEY,
SchoolLevelName VARCHAR(255)
);
CREATE TABLE Courses (
DersID INT AUTO_INCREMENT PRIMARY KEY,
CourseName VARCHAR(255),
SchoolLevelID INT,
FOREIGN KEY (OkulDuzeyiID) REFERENCES OkulDuzeyleri(OkulDuzeyiID)
);
CREATE TABLE Classes (
SinifID INT AUTO_INCREMENT PRIMARY KEY,
ClassLevel INT,
SchoolLevelID INT,
FOREIGN KEY (OkulDuzeyiID) REFERENCES OkulDuzeyleri(OkulDuzeyiID)
);
CREATE TABLE Ogretmenler (
OgretmenID INT AUTO_INCREMENT PRIMARY KEY,
OgretmenAdi VARCHAR(255)
);
CREATE TABLE DersOgretmen (
DersOgretmenID INT AUTO_INCREMENT PRIMARY KEY,
DersID INT,
OgretmenID INT,
FOREIGN KEY (DersID) REFERENCES Courses(DersID),
FOREIGN KEY (OgretmenID) REFERENCES Ogretmenler(OgretmenID)
);
CREATE TABLE Ogrenciler (
OgrenciID INT AUTO_INCREMENT PRIMARY KEY,
StudentName VARCHAR(255),
SinifID INT,
FOREIGN KEY (SinifID) REFERENCES Classes(SinifID)
);
CREATE TABLE Questions (
QuestionID INT AUTO_INCREMENT PRIMARY KEY,
QuestionText TEXT,
AnswerA TEXT,
AnswerB TEXT,
AnswerC TEXT,
ANSWERD TEXT,
CorrectAnswer CHAR(1),
DersID INT,
FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);
this code is the database design code I created for the question bank, but I don’t know how to make the exam preparation program.
Ensar Samet Yıldız is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1