IGNOU MCS 207 2026 2027 - Perform the following using SQL: Create tables with appropriate pri

Question

Perform the following using SQL:
 Create tables with appropriate primary and foreign keys
 Insert sample data (minimum 5 researchers, 6 publications)
 List publications by a given researcher
 Find researchers who have not authored any publication
 Find the publication with the highest number of authors
 List venues that have more than two publication

05 Aug 2026

Answer :

Word Count : 693

In a research publication database, the main entities can be represented using three tables: `Researcher`, `Publication`, and `Authorship`. The `Researcher` table stores details of researchers, the `Publication` table stores information about publications and their venues, and the `Authorship` table establishes the many-to-many relationship between researchers and publications. A researcher can author many publications, and a publication can have many researchers. Therefore, the `Authorship` table uses a composite primary key and foreign keys to maintain referential integrity. ```sql CREATE TABLE Researcher ( researcher_id INT PRIMARY KEY, researcher_name VARCHAR(100) NOT NULL, department VARCHAR(100), email VARCHAR(100) UNIQUE ); CREATE TABLE Publication ( publication_id INT PRIMARY KEY, title VARCHAR(200) NOT NULL, venue VARCHAR(150) NOT NULL, publication_year INT ); CREATE TABLE Authorship ( researcher_id INT, publication_id INT, author_order INT, PRIMARY KEY (researcher_id, publication_id), FOREIGN KEY (researcher_id) REFERENCES Researcher(researcher_id), FOREIGN KEY (publication_id) REFERENCES Publication(publication_id) ); ``` The `Researcher` table can contain at least five researchers. Six publications are inserted into the `Publication` table. The `Authorship` table contains the associations between researchers and publications. ```sql INSERT INTO Researcher (researcher_id, researcher_name, department, email) VALUES (1, 'Anita Sharma', 'Computer Science', 'anita@example.com'), (2, 'Rahul Verma', 'Information Technology', 'rahul@example.com'), (3, 'Priya Singh', 'Computer Science', 'priya@example.com'), (4, 'Amit Kumar', 'Data Science', 'amit@example.com'), (5,

_________ _________ __________ __________ ___ _______ __________ ______ _________ ____ _____ __________.
____ ____ _____ ____ _______ ___ _____ ___ _____ _________ _________.
_______ ______ ______ ______ _______ ______ _____ _______ __________.
________ _____ _________ __________ ______ ______ ______.
______ _______ ________ ___ ___ ____ _____ ______ _______ __________.
___ ________ __________ __________ __________.
_______ _____ ________ _____ ________ ________ __________ _______ __________ __________ ____.
________ ____ _________ ___ ___ ________ ________.
____ _______ _____ _________ _____ ___ ______ ______ __________ ______.
___ _____ ________ _________ _________ ___ __________ ___.
______ _____ ________ __________ ______ ___ ____ ______ _____ ____ ________ ___.
____ _______ _______ ________ _____.
____ ___ ______ _________ _____ _____ ____ _____ ________ _____.
______ __________ __________ _____ ___ ______ _____ _________ _____.
___ ______ ________ ______ ___ ________ ______.
__________ __________ _______ ___ ____ _______ _________ _____.
______ _________ _______ _____ ____ _______ ____ __________ __________ ___ ____ ___.
___ __________ _____ ______ ______ ___ ____ ____ _______.
__________ ______ _______ ___ _______.
___ _____ ____ ______ ______ _____ _______ __________ _____.
__________ _______ __________ ________ _______ ___ ___ ______.
______ ____ _____ _______ ___ ________.
_______ __________ _________ _______ ___.
__________ _________ _______ __________ ___ ___ _____ ___ _______.
______ ____ _____ ________ _________ ____ ______ ____ _______.
________ _________ _______ ______ _________ __________ ____ ____ _____ ________ ______ ______.
________ __________ _________ _________ _________ ___ ______ ____ ______ _____ ________.
______ ___ ______ _________ __________ ____ _______ __________.
___ ___ _______ __________ _________ ___ _________ __________ ____ ____ ______ ______.
________ ________ _________ ___ ______ ________ ________ _______ __________ ______.
______ _________ __________ _________ __________ ______ _____.
____ _____ ________ ____ _______ _____.
_____ ____ ________ ____ ____ ________.
______ _______ ________ ______ ______ _______ _________ _________ _________ ___ ___.
_____ ______ ______ ________ _________ _________ ____ ___.
_________ ___ ____ __________ ________ _______.
________ _________ _______ _______ ________ ______ ____.
____ ______ __________ _________ __________ _________ ___ ___ _______ _________ _________.
___ _______ ___ ________ _________ ___.
____ _________ ___ ____ ______ __________ _______ ________ ______.
____ _______ _____ _____ _____ _____ _________ ______ ___ __________ ___ _______.
_______ ________ _______ _________ ____ ___ __________ ________.
________ _____ ________ ______ ________ ____ ________ __________ _____ ____ ___.
_______ __________ _______ _____ ________ ___ _______.
________ _____ _________ ________ ________ ___.
_________ __________ ________ _________ _________ __________ ______ ___ ___ _______.
________ _____ __________ _______ ____ _________ _________ _________.
___ ___ ___ __________ _______ _______ ________.
__________ ____ __________ _____ _______ _________ _____ ______.
__________ ____ _________ _________ __________.
___ ___ __________ ______ __________ ______.
___ _______ ______ ___ ________ _________ _____ _________ ___.
____ ________ ________ ____ ___ __________ __________ _____.
___ ________ ____ ________ _________ __________.
________ ________ ________ __________ _____.
_____ _____ __________ ______ ________ ______ __________ __________ ___ _____ ______ __________.
_____ ________ _____ __________ ________ ______ ___ _________.
_______ _____ _____ ____ _____ ____ ______ _________.
________ __________ ____ _______ _______.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10

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