Question

Create the following tables.

07 Aug 2026
Answer :
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)
___ ___ _________ __________ ___ ______ ________ ______ ______ _______.
_____ _______ __________ _______ ____ ____ __________ ___.
_________ ____ _______ ________ _____ ________ _______ ____ __________.
____ _______ ______ _________ ______ _________ ______ _______ _________.
___ _________ ____ ________ _________ _______ ___ ______.
______ ______ _______ _________ _______ _____ _______ _______ ________ ______.
____ ___ ______ _____ __________ __________ ___ __________ _________.
__________ ______ _______ ___ ___.
_________ ______ ________ ________ ______ ______ _____ _____ _____ ______ _______ ______.
_____ _______ ________ ________ ____ _____ ___.
___ ______ ___ _______ _______.
_____ _______ ________ ___ _________ _________ ______ __________ _______.
___ ____ __________ _______ ______.
____ ___ ______ __________ _____ ________ _______ ________ ___ _______ _______ ____.
___ _________ ________ __________ ______ _________ ___.
_____ ___ _________ ________ _______ ____ _________ ________ ______.
____ _______ __________ __________ ________ _________ _____ ________ _______.
______ _______ ________ ________ _________ ________.
_______ ____ ______ ______ _______ __________ _____ _____.
_____ __________ _________ ________ ____.
________ ______ __________ ______ __________ ______ ________ ______ _____.
__________ ______ __________ _______ ___ __________ ______ _____ ___ ____ _______ ____.
____ ____ ___ _______ ______ _________ _____ __________ _________ ________ ___.
___ ______ ____ ____ ______ ______ _________ _____ ______ _________.
______ ________ ____ _______ ____ _________ ____ ___ __________ _____ _____.
__________ _______ ___ ____ _________ _______ _______ _____ ____.
____ ___ ______ ___ __________ ________ __________ _________ _________ _____.
____ __________ ______ ___ ___ ________ ______ ________ ________ _______ ____ _________.
______ _________ _______ _____ __________ ________.
_____ _____ _____ _____ ______ ______ ________ _________ ____ ____ _______.
__________ _______ ______ __________ _____ _______ ________ _______ _______ _______.
_______ _______ _________ ______ _________ _________ ________ _______ __________ _________.
______ _____ ____ ____ _____.
___ ______ ______ _________ _____ ______ __________ ______ _________ _______ _________ ____.
_______ ____ ________ __________ ___ ________ ___ ______ ____ ___.
_________ __________ __________ __________ _________.
______ ________ __________ _____ _________ _________ _____ _____.
___ ______ ___ ____ _______ _________ _________ ______ _______ __________.
__________ ___ ________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Call Us WhatsApp
STUDY • PREPARE • SUCCEED
Skip in 10
Related Questions

patient_id (Foreign Key

doctor_name (VARCHAR)

Design and implement a database system using any relational DBMS for an Online Hospital Appointment Management System, demonstrating fundamental DBMS concepts such as database design, entity relationships, CRUD operations and SQL queries for data retrieval and analysis.

patient_name (VARCHAR)

This assignment has only one question. Answer the question. This question carries 40 marks. Rest 10 marks are for viva voce. You may use illustrations and diagrams to enhance the explanation. Assumptions can be made wherever required. Please go through the guidelines regarding the assignments given in the programme guide for the format of presentation

experience (INT)

doctor_id (Primary Key, INT, Auto Increment)

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers
Login
Top
📞
Call Support Instant phone assistance IGNOU BCSL 34 2026 2027 - Create the following tables. | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→