Question

 

Implement the database design (create tables) that you have created in question 1 using a RDBMS with proper integrity constraints. Enter about 8-10 meaningful records in each of your table.

04 Aug 2025
Answer :
Word Count : 645
To implement the database design using a Relational Database Management System (RDBMS), we will assume a sample project based on a Student Management System. The schema includes the following tables: 1. Students 2. Courses 3. Enrollments 4. Instructors Each table will be created with appropriate primary keys, foreign keys, data types, and integrity constraints. After that, we will insert 8-10 meaningful records into each table using SQL commands. --- ### Step 1: Create the Tables ```sql -- Table 1: Students CREATE TABLE Students ( student_id INT PRIMARY KEY, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, dob DATE, gender CHAR(1) CHECK (gender IN ('M', 'F', 'O')) ); -- Table 2: Courses CREATE TABLE Courses ( course_id INT PRIMARY KEY, course_name VARCHAR(100) NOT NULL, credits INT CHECK (credits >= 1 AND credits <= 5), department VARCHAR(50) NOT NULL ); -- Table 3: Instructors CREATE TABLE Instructors ( instructor_id INT PRIMARY KEY, name VARCHAR(100) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, hire_date DATE, department VARCHAR(50) NOT NULL ); -- Table 4:
______ ___ ________ _____ __________ _______.
______ ___ _____ ______ __________ ____ __________ ___.
________ _________ __________ ___ __________ _______ __________ _______.
___ _______ ______ _____ ___ _______ __________ ________ __________ _______ __________ _______.
________ _________ _____ ____ __________ __________ ____ ____ ______.
__________ ______ ___ _________ ______ _____ _______ _____ __________ ________ __________ ________.
_____ _____ _________ ___ _______ ______ ____ __________ _________ ____ _________ ______.
________ __________ _______ _______ ______ _________ __________.
______ _____ _____ ___ _______ ______ ______ ______.
__________ _______ ___ ________ ________ _______ _________.
__________ ______ ___ _________ ____ ___ _______ ______ _________ _________ _______.
_____ ___ _________ ___ ________ ________ _____.
_________ __________ _________ _____ ___ _______ ___ __________ _______.
__________ ____ __________ __________ _______ _______ __________ ________ _____.
________ _________ _______ ____ ______ ____ _____ _____ ___ _________.
________ _______ _________ ____ ________ _________.
_________ _______ __________ __________ __________ ________ ___ _____ ___ ______ ___.
________ ___ _____ ____ _______ _______ ____ ________ ____ ____ ____.
_____ _____ ___ ____ _____ _____ _________ ___ ______ ______ ___ _____.
________ _______ ________ _____ __________ ______ __________ ____ ___.
____ ____ ______ ____ _________.
_____ _______ __________ _____ ________ ____ _______.
_______ _____ ______ ______ _____ ____ __________.
_________ _________ ______ _____ _________.
_________ __________ _______ ____ _________ ___ ____ ______ ______ ________ ____ __________.
_________ ____ ________ ____ ________ ______ _____ _________ __________ _______ _______.
_______ _____ ____ __________ ______.
___ ____ ____ _____ _______ _______ __________ _________ ________.
_____ ______ ___ _____ _________ ____.
_______ _________ _________ ________ _________ __________ ______ ____ _________ ______.
________ ________ __________ __________ ________ _________.
______ ___ _________ __________ _________ _____ _________.
________ _________ ____ ________ ________ ________ ________ ____ _______ _______ _______ ______.
___ _________ _____ ___ ________ ________ ______ ___ ________ _______ ______ _________.
____ _____ _________ __________ _____ ___ _______ _________ _____ ____ ___.
_________ _____ _____ ________ _____ ______ ________ ________ ___.
___ _______ ______ ______ __________ ___ _______.
__________ ___ ___ ____ __________ __________ _______.
__________ _________ _________ _________ _________ _______.
_________ _______ _____ ___ _____ ________ ______.
_______ _____ _______ _____ ___ __________.
_________ ________ _________ ______ ________ ________ _______ ___ ________.
______ _____ __________ ______ _________ ____ __________ _______.
______ ______ __________ ______ ______.
_____ ________ __________ ________ ____ _________ _________.
_____ ________ _____ _____ __________ _________ ___ _______ __________.
_____ ______ ____ _____ ______ __________.
_________ ______ ______ _____ _________ __________.
______ _________ _____ _______ __________ ______ _____ ________ _______ ________.
_________ _________ ____ __________ ____.
________ ______ ____ ______ __________.
________ __________ ___ ___ ___ _________ _________ __________ ________ ________ ________ _____.
______ ________ ________ ___ ________ ______ ____ _______ ___ ________.
_____ ________ ___ ______ _______ ___ ____ _________ ____ __________ ______ ______.
_________ ______ _______ ___ _______ __________.
_______ _____ ______ _____ __________ _______ _________ _______ _____ ________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MCSL 210 2025 2026 -  Implement the database design (create tables) that you have | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→