Question

Create a database of 10 national and international periodicals. Generate reports for the list of national and international journals by subject.  

10 Mar 2023
Answer :
Word Count : 486

Creating a database of 10 national and international periodicals involves defining the database structure, entering data, and generating subject-specific reports. Below is a practical guide to accomplish this:

1. Database Design:

  • Table Name: Periodicals
  • Fields:
    • ID (Primary Key, Auto-increment)
    • Title (VARCHAR, 255)
    • Type (ENUM: 'National', 'International')
    • Subject (VARCHAR, 255)
    • Publisher (VARCHAR, 255)
    • Frequency (ENUM: 'Weekly', 'Monthly', 'Quarterly', 'Yearly')

2. Data Entry (Sample Data):

ID Title Type Subject Publisher Frequency
1 The Hindu National General News Kasturi & Sons Daily
2 Economic and Political ________ _________ _________ ___ _____ ________ ______ _________ ______.
_______ ___ __________ _______ _______ ________ ______ _______ ______ _______ ____ ________.
_________ _____ _____ _______ ___.
__________ ____ ___ _________ _____ ______ ______ ____ ________ _________ _________ _____.
________ __________ _________ _________ ________ ______ ___ ______ _____ ___ ______.
__________ __________ _________ ____ __________ ___ _____ ____.
_________ _______ _______ _____ __________ __________ ________.
_________ _______ ________ _____ ______ ____ ______ _____.
____ ________ _______ ___ _____ ___ _____ __________.
_________ ____ _______ _______ _________.
______ __________ ______ ______ ________ ________ ________ ____ ______ _________ __________.
_________ _________ _____ __________ _____ ____ ______.
_______ ____ ___ ____ __________ ________ _____ ________ __________ ______ _________.
________ ___ _______ _____ __________ ___ _________ ___ ______ ________ ____.
______ ________ _____ _________ _____ ___ __________ ______ __________.
_______ ______ _____ __________ _________ __________.
______ ____ ______ _________ _______ _____ __________ ___.
________ ________ _________ _______ _________.
________ _________ __________ _____ ____ _____ ___ __________.
_______ __________ _______ _____ _____ ________ _________ __________ _________ ____.
________ ___ ___ _______ ____.
____ _________ _____ ________ __________ _____.
___ _________ ______ ___ _____ ___ _________ ______ _____ ____ ____.
_________ _______ ________ _____ ________ _____ ____ _____ _____.
_____ ________ ______ ____ ______ _______ _____ __________ _____ _______.
___ _______ __________ _________ _________.
__________ ___ _____ __________ _____ ___ _____ ______.
__________ _________ ____ ____ _________ _________ _________ ________ __________ ____ _______ ______.
_____ _______ _____ _______ _________.
_____ _____ ______ ______ ______ _____ _______ ___ _____ _______ _________ ______.
____ _______ __________ ______ _______ _________ _____ _____.
___ ____ _________ ________ __________ _________ _____ _______.
___ _________ _________ __________ ________ ___ __________.
___ _____ _____ _____ __________ _________.
_____ ____ ____ ______ __________ ____ ___ _________ _________ ______ ___ _______.
______ _________ _____ _____ _________ ____ _____.
_____ ________ _________ _______ ____ _____.
_________ _________ ____ __________ __________.
_______ _______ ___ _________ _______ _________ ______ ______.
_________ _______ __________ ____ ________ ________ __________ _____ _______ ____ _________ ___.
___ _____ _____ __________ __________ _________ __________ _________ ______ _______.
__________ _______ ___ ____ ________ ___ ___ __________ ________ ________ __________.
________ _________ ____ _____ ______ _______ ___ __________ ____ ____ _________ ______.
___ _________ ____ _____ _____ _____ _________ _______ ____ ________ ____.
________ ____ ___ __________ ______ ______ ________ ___ _______ __________ _____.
______.
Get Full Answer on WhatsApp
Related Questions

Create a database for 5 departmental budget heads and allocate Rs.l lakh each for every head. Generate reports for the list of budget heads and the amount allocated. 

Create a database of 10 national and international periodicals. Generate reports for the list of national and international journals by subject.  

Write down the steps involved in (a) checking duplicate (b) preparing supply orders (c) merging acquisition record with OPAC with the help of a library software package. 

Add 10 publishers in the Master Database and generate a list thereof. 

Generate Barcode Labels after entering the data for books and theses (minimum 10 entries each).  

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers
Login Cart
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★
Top