B.Sc. (Information Technology) Major Practical 1 Syllabus - Mumbai University

This is the FY BSc IT syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.

Loading syllabus...

Syllabus for Major Practical 1

Major · Semester 1 · FY BSc IT · 2 credits · 50 marks

Module I: Programming with C

1. Practical 1:-
a To calculate simple interest taking principal, rate of interest and number of years as input from user. Write algorithm & draw flowchart for the same.
b Write a program to find greatest of three numbers using conditional operator. Write algorithm & draw flowchart for the same.
c Write a program to check if the year entered is leap year or not. Write algorithm & draw flowchart for the same. 2. Practical 2:-
a Write a program to calculate roots of a quadratic equation.
b Write a menu driven program using switch case to perform add / subtract / multiply / divide based on the users choice.
c Write a program to print the pattern of asterisks. 3. Practical 3
a Write a program using while loop to reverse the digits of a number.
b Write a program to calculate the factorial of a given number.
c Write a program to print the Fibonacci series. 4. Practical 4
a Write a program to print area of square using function.
b Write a program using recursive function.
c Write a program to square root, abs() value using function.
d Write a program using goto statement . 5. Practical 5
a Write a program to print rollno and names of 10 students using array.
b Write a program to sort the elements of array in ascending or descending order 6. Practical 6
a Write a program to extract the portion of a character string and print the extracted part.
b Write a program to find the given string is palindrome or not.
c Write a program to using strlen(), strcmp() function . 7. Practical 7 Write a program to swap two numbers using a function. Pass the values to be swapped to this function using call-by-value method and call-by- reference method. 8. Practical 8
a Write a program to read a matrix of size m*n.
b Write a program to multiply two matrices using a function. 9. Practical 9 Write a program to print the structure using Title Author Subject Book ID Print the details of two students. 10. Practical 10 Create a mini project on “Bank management system”. The program should be menu driven.

Module II

1. Conceptual Designing using ER Diagrams (Identifying entities, attributes, keys and relationships between entities, cardinalities, generalization, specialization etc.) 2. Perform the following:
Viewing all databases
Creating a Database
Viewing all Tables in a Database
Creating Tables (With and Without Constraints)
Inserting/Updating/Deleting Records in a Table 3. Perform the following:
Altering a Table
Dropping/Truncating/Renaming Tables
Backing up / Restoring a Database 4. Perform the following:
Simple Queries
Simple Queries with Aggregate functions 5. Queries involving
Date Functions
String Functions
Math Functions 6. Join Queries
Inner Join
Outer Join 7. Subqueries
With IN clause
With EXISTS clause 8. Converting ER Model to Relational Model and apply Normalization on database. (Represent entities and relationships in Tabular form, Represent attributes as columns, identifying keys and normalization up to 3rd Normal Form). 9. Views
Creating Views (with and without check option)
Dropping views
Selecting from a view 10. DCL statements
Granting and revoking permissions
Saving (Commit) and Undoing (rollback)

Text Books

1 “Fundamentals of Database System”, Elmasri Ramez, Navathe Shamkant, Pearson Education, Seventh edition, 2017 .
2 Database Management Systems”, Raghu Ramakrishnan and Johannes Gehrke, 3rd Edition, 2014
1 MASTERING C, K. R. Venugopal and Sudeep R. Prasad, Tata McGraw-Hill Publications.
2 “A Computer Science –Structure Programming Approaches using C”, Behrouz Forouzan, Cengage Learning.
3 Schaum’s outlines “Programming with C”, Byron S. Gottfried, Tata McGraw-Hill Publications.
4 “Basics of Computer Science”, Behrouz Forouzan , Cengage Learning.
5 “Programming Techniques through C”, M. G. Venkateshmurthy, Pearson Publication.
6 “Programming in ANSI C”, E. Balaguruswamy, Tata McGraw-Hill Education.
7 “MySQL: The Complete Reference”, Vikram Vaswani , McGraw Hill, 2017.
8 “Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease”, Ashwin Pajankar, BPB Publications, 2020.

Reproduced from the University of Mumbai syllabus for B.Sc. (Information Technology) under NEP 2020, in force from the academic year 2024-25. Wording is as printed in that syllabus. Module numbering is as printed there too.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF BSc IT SEM I & II (2024 25) NEP NEP 2020 syllabus, in force from 2024-25 Read full PDF Read

PDF BSc IT V & VI 2024 25 Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read

PDF SY BSc IT 23 24 Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read

BSc IT Syllabus Study Path

Start with the year folder.
Use FYBSc IT, SYBSc IT, or TYBSc IT first so your syllabus check matches the semester you are preparing for.

Check units before opening notes.
Use the syllabus to confirm topics, then open BSc IT notes for the same semester.

Practice after the syllabus check.
Move to BSc IT question papers after reviewing the module scope.

FYBSc IT Syllabus SYBSc IT Syllabus TYBSc IT Syllabus BSc IT Notes BSc IT Papers

Report or request