Implement the database design that you have created in question 1 usin

Question

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

27 Apr 2023

Answer :

Word Count : 444

To implement the database design we created in the previous response, you can use a Relational Database Management System (RDBMS) like MySQL, PostgreSQL, or Oracle. Here's an example implementation using MySQL:

Create the necessary tables in the database:

 CREATE TABLE Student (     enrolment_number INT PRIMARY KEY,     name VARCHAR(50),     father_name VARCHAR(50),     date_of_birth DATE ); CREATE TABLE Programme (     programme_code VARCHAR(10) PRIMARY KEY,     name VARCHAR(100),     min_duration INT,     max_duration INT ); CREATE TABLE Semester (     semester_number INT PRIMARY KEY,     programme_code VARCHAR(10),     FOREIGN KEY (programme_code) REFERENCES Programme(programme_code) ); CREATE TABLE  _____ ___ _______ __________ _____ ________ ____ ______ ______ _________ _________.
 _____ __________ _______ __________ _____ ______ ____ ______ ____ _____ ______ ______.
 _____ ___ __________ _________ _____ _______ __________ ________ _______ ______ ______.
 _________ _______ ________ __________ _________ ______ ______ ____ _______ _______ ______ _____.
 __________ _________ __________ ______ __________ ___ _________.
 ___ ___ __________ _____ ______ _______ ___ ________ ______.
 __________ ____ ________ __________ ____ ____ ________.
 _____ ______ _________ ____ _______ __________ __________ __________ ________ ______ ___.
 __________ ________ __________ ___ ______ ________ _____ __________ __________ _______ ___.
 _______ ___ _______ _______ __________ _______ __________ ________ ____.
 ___ _______ ___ _____ _________ __________ ________ __________ _______ _____.
 ___ _______ __________ __________ ________ ______ ___ __________.
 ___ _________ ________ ____ _____ ______ ____ _______ ______ ______.
 ___ __________ _____ ______ __________ _______ _____ ____.
 _____ ______ _______ ______ _____ _______ __________ ________ ________ __________.
 ___ ______ ________ _______ __________ _____ ______ __________ ____ _______.
 _____ _________ ____ ___ ___ _______ _________ ______ ________ _______.
 _________ ___ ___ ______ _________ ________ ______ ___ _______ _____.
 ____ _____ ________ _______ ____ __________ ___ ______.
 __________ _______ _______ ________ ________ _____ ____ ________ _____ _________ _________ ______.
 _______ __________ _________ ________ ____ ____.
 _______ ____ __________ _____ _______.
 ____ ______ ____ _________ ______ _______ __________ _________ _______.
 ______ ________ __________ __________ ____ ____ _____ _______ _______ ______.
 ____ ________ _____ ________ ___ ____ ______ _________ ___ __________.
 ___ _____ _____ ____ _______ _________ ___.
 _______ ___ __________ ________ ________ ____ ______.
 _________ __________ ________ ______ ___ ________ _______ _____ ____ __________ _________ _____.
 _____ _______ _____ _____ ______ ___ ___.
 _____ __________ _______ __________ _________ _____ _______ ______ _____ _______ __________.
 __________ ________ __________ ___ ______.
 _____ _____ __________ ____ __________ ________ _______ __________ ________.
 _________ ______ _________ ____ __________ _______.
 _______ ____ _________ ___ __________ __________ ____.
 _____ ___ __________ _________ _____ ____ __________ __________.
 _______ __________ __________ ________ ________.
 ___ ______ _______ ______ ____ __________.
 ____ ___ ________ ____ ___ _________ _______.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★