Word Count : 420

---

In a DBMS Lab, creating tables involves defining their structure using the SQL `CREATE TABLE` command. The command specifies the table name, column names, data types, and constraints such as `PRIMARY KEY`, `NOT NULL`, `UNIQUE`, and `FOREIGN KEY`. The following tables can be created as a practical example. ```sql CREATE TABLE Student ( Student_ID INT PRIMARY KEY, Student_Name VARCHAR(50) NOT NULL, Gender VARCHAR(10), Date_of_Birth DATE, Course VARCHAR(50), Semester INT ); CREATE TABLE Department ( Department_ID INT PRIMARY KEY, Department_Name VARCHAR(50) NOT NULL, HOD VARCHAR(50) ______ __________ ______ _______ _____.
_______ ____ _______ _______ ______ ___ ___ ____.
___ __________ _______ ___ __________ ________ __________ _______ _________ ___.
________ ________ _________ __________ _____ __________ _______ _________ ________ _________ __________ ___.
_____ ___ _________ ___ __________ ___ _____ __________ ________ ___ ______ __________.
_______ ________ ______ _______ ______ _________ ___ ___ ______ ____ ________.
________ _________ ______ ___ __________ _______ ___.
_______ _______ ___ _______ ___ ________ _____ ___ ___ _______ ________.
_______ ________ __________ ________ ___ ________ ____ ___ _____ _______ ________.
_______ ____ _____ ____ ___ _________.
___ ______ ___ _____ ___ ______ ____ ______ _______ ______.
___ ___ _______ __________ __________ _______ ________ _____ ______ ____ _________ _______.
____ ________ ______ _______ ____ __________ ____.
_________ ____ ______ _____ ______ ____ ______ ___ ___ _______ ____.
_______ _________ _________ ________ ______ ______ _________ ___.
______ ________ ___ __________ _________ ____ _______ _________.
__________ __________ __________ _____ ______ _____.
____ ________ _____ ______ _______ ______ ___ ____ _____ __________ _____ ________.
________ ____ ____ ___ ________ _____ ________ _______ __________.
__________ __________ _____ _____ ______ ______ __________.
____ _____ _________ _____ ________ ___ _________ ____ __________.
_____ ______ _______ _____ ____ __________ ___.
________ ___ _____ ___ _________.
___ _______ ___ __________ ________ _____ ______ ______ ________ _____ _____ ___.
_______ _________ ____ ___ _____ ______.
____ ________ _____ ____ _____ _______ ________.
_________ _____ ________ _____ ___ ____ ____ __________ __________ _______ _________.
__________ ______ __________ __________ ___.
__________ ______ _______ _____ _______ ______ ________ _________.
_____ ________ ___ ________ _________ _____ ______.
______ __________ ___ _____ ___ _________ __________ ___.
____ ________ ________ _______ ________ ___ _______ ______ ____.
_______ ________ __________ _____ _____ _______ ________ ______ ________ _________ ________ ___.
________ _______ __________ ____ __________ ______ ___ ___ ______ ____.
______ _________ _______ ______ _________ _____ ___ ________.
_____ ____ ___ ___ _______ ________ _____ _________ ____ ________ _________.
_____ ______ ____ ___ ________ ____ __________ _____ _____ ____ __________ ____.
____ __________ _____ ____ ______ ________.
Get Full Answer on WhatsApp