IGNOU MLIL 3 SOLVED ASSIGNMENT

Included:

MLIL 3 2025 - English

MLIL-003: Information Systems

TMA - Practical

Coverage:

Course Code: MLIL-003

Course: Information Systems

Assignment Code: AST/TMA-T/Jan. & July 2025

Blocks: 1 to 4

Units: 1to 14

Total Marks: 50

General Instructions for Practical Assignment:

i) Documents, data, database, etc. to work on for the practical assignments will be provided by the Counsellor/Practical Supervisor in the Study/Tele Learning Centre.

ii) You are required to do the practical assignment in the Study/Tele Learning Centre. Evaluation of the assignment will be done by the Counsellor/Practical Supervisor on the spot.

iii) Make Screen Captures for all the answers and save them in one file. The Counsellor/ Practical Supervisor will evaluate these screen captures and give marks accordingly.

iv) Attempt the questions using SQL commands or MS-Access.

v) All questions are compulsory.

1) Design a blank database “LIBRARY” using MS-ACCESS and add to it the following tables:

(i) JOURNALS

(ii) VENDORS

Add the following fields in the ‘JOURNAL table in the ‘Design View’

(a) JOURNAL_ID Auto Number

(b) JOURNAL_TITLE Text 255 Null Not Allowed

(c) JOURNAL_SPONSOR Text 255 Null Not Allowed  Now add 15 records in it using Data Sheet View.

2) Add the following fields in the Table ‘SUBJECT’ – SUBJECT_ID, SUBJECT_NAME, AUTHOR_ID. Add 15 records in the table.

3) Make a relationship of JOURNAL_ID field in VENDORS table to the JOURNALS table using ‘Look Up Wizard’ in Design View.

4) Design E-R diagram for the database ‘DOCUMENTS’ to show relationship among the tables. Add 15 records in VENDORS table in Data Sheet View.

MLIL 3 2026 - English

MLIL-003: Information Systems

TMA - Practical

Coverage:

Course Code: MLIL-003

Course: Information Systems

Assignment Code: AST/TMA-T/Jan. & July 2026

Blocks: 1 to 4

Units: 1to 14

Total Marks: 50

General Instructions for Practical Assignment:

i) Documents, data, database, etc. to work on for the practical assignments will be provided by the Counsellor/Practical Supervisor in the Study/Tele Learning Centre.

ii) You are required to do the practical assignment in the Study/Tele Learning Centre. Evaluation of the assignment will be done by the Counsellor/Practical Supervisor on the spot.

iii) Make Screen Captures for all the answers and save them in one file. The Counsellor/Practical Supervisor will evaluate these screen captures and give marks accordingly.

iv) Attempt the questions using SQL commands or MS-Access.

All questions are compulsory.

1) Design a blank database 'RESOURCES' with the following tables:

(i) STAFF AND

(ii) DIVISION

Add the following fields in the table 'STAFF':

STAFF_ID, STAFF_NAME, STAFF_AGE, STAFF_ADDRESS and DIVISION ID

Add 15 records in the table 'AUTHORS'

2) Add the following fields in the Table 'DIVISION'

DIVISION_ID, DIVISION_NAME, DIVISION HEAD_ID

Add 15 records in the table.

3) Display information about all the staff (in the above table)

4) Design E-R diagram for the database 'RESOURCES' to show relationship among the tables.

5) Add 15 records in each of the above tables using FORM views.

 

Q: How will I receive the PDF?
A: Immediately after payment, the download link will appear and be sent to your email.

Q: Is this hand-written or typed?
A: This is a professional typed computer PDF. You can use it as a reference for your handwritten submission.