Description

UPRTOU Foundation Course in Information Technology SECT-02 (Skill Enhancement Course in Computer Technology) Solved Assignment 2024-2025

UPRTOU BA Solved Assignment 2024-25

Uttar Pradesh Rajarshi Tandon Open University, Prayagraj, Uttar Pradesh
Foundation Course in Information Technology Programme Assignment 2024-25

Course Code: SECT-02
Course Title: Skill Enhancement Course in Computer Technology

Section-A
(Instructions): Section A consists of long answer questions. Answer should be in 800 to 1000 words

1. Draw the block diagram of a computer and briefly explain the functions of each unit.
2. Explain the function of following DOS commands:
i) ATTRIB
ii) CHKDSK
iii) DELTREE
iv) UNFORMAT
v) FDISK
vi) MSAV
3. You need to create a database for a public library to store book details (Write the steps involved and also attach a copy of the screenshot.
3. You need to create a database for a public library to store book details (Write the steps involved and also attach a copy of the screenshot)
a. Create a table called “Books” with the following fields.
Field Name Type Field size Constraints
ID Number Primary Key
Title Text field 50 characters
Description Text field 30 characters
Category Number
No of copies Number

b. Create a form to enter details about books and save it as “Books Form”.
Section-B
(Instructions): Section B consists of short answer questions. Answer should be in 200 to 300 words.
4. Convert ( 2 1 . 2 1 )8= ( ? )10
5. How will you align a table to the right or left? Write the steps.
6. You are required to design an html page in which a few lines of a paragraph are to be formatted differently from the rest of the lines. Which tag will assist in this?
7. Briefly explain how e-mail works.