Computer Science – 8.3 Data Definition Language (DDL) and Data Manipulation Language (DML) | e-Consult
8.3 Data Definition Language (DDL) and Data Manipulation Language (DML) (1 questions)
Login to see all questions.
Click on a question to view the answer
Model Answer
The following SQL DDL statements create the Students and Courses tables:
CREATE TABLE Students (
StudentID INT PRIMARY KEY,
Name VARCHAR(255),
Major VARCHAR(100)
);
CREATE TABLE Courses (
CourseID INT PRIMARY KEY,
CourseName VARCHAR(255),
Credits INT
);