B.Sc. (Computer Science) Computer Science Practical 1 Syllabus - Mumbai University
This is the FY BSc Computer Science syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it — her Summer 2026 third-year timetables name that scheme — so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Computer Science Practical 1
Module I
- Digital Systems & Architecture – Practical
- Logic Gates Truth Table Verification:
- Study and verify the truth table of various logic gates (NOT, AND, OR, NAND, NOR, EX-OR, EX-NOR) using Logisim.
- Boolean Expression Simplification:
- Simplify given Boolean expressions and realize them using Logisim.
- Half/Full Adder Design:
- Design and verify the operation of a half/full adder using Logisim.
- Half/Full Subtractor Design:
- Design and verify the operation of a half/full subtractor using Logisim.
- 4-Bit Magnitude Comparator:
- Design a 4-bit magnitude comparator using combinational circuits in Logisim.
- Flip-Flop Implementation:
- Verify the operation of flip-flops (e.g., D, JK) using logic gates in Logisim.
- Counter Operation Verification:
- Verify the operation of a counter using Logisim.
- 4-Bit Shift Register Operation:
- Verify the operation of a 4-bit shift register using Logisim.
- Multiplexer/Demultiplexer Design:
- Design and implement expressions using multiplexers/demultiplexers in Logisim.
- 3-Bit Binary Ripple Counter:
- Design and implement a 3-bit binary ripple counter using JK flip-flops in Logisim.
- The above practical can be performed using any open source simulator (like Logisim) (Download it from https://sourceforge.net/projects/circuit/)
Module II
- Fundamentals of Database Systems – Practical
- Conceptual Design Using ER Diagrams:
- Identify entities, attributes, keys, and relationships. Apply generalization and specialization.
- Database Management Operations:
- View all databases, create a database, view all tables in a database, create tables with and without constraints, perform CRUD operations.
- Table Management Operations:
- Alter a table, drop/truncate/rename tables, perform backup/restore operations on a database.
- Basic Queries and Aggregate Functions:
- Execute simple queries and utilize aggregate functions (e.g., COUNT, SUM, AVG).
- Advanced Query Functions:
- Utilize date, string, and math functions in queries.
- Join Queries:
- Execute inner and outer join queries.
- Subqueries:
- Apply subqueries with IN and EXISTS clauses.
- ER Model to Relational Model Conversion and Normalization:
- Convert ER model to a relational model and apply normalization up to 3rd Normal Form.
- Views:
- Create views with and without check options, drop views, select data from views.
- Data Control Language (DCL) Statements:
- Implement DCL statements for granting and revoking permissions. Demonstrate COMMIT and ROLLBACK statements.
- These experiments can be implemented using a database management system like MySQL.
Text Books
- 1 R P Jain, Modern Digital Electronics, Tata McGraw Hill Education Pvt. Ltd. , 4th Edition, 2010
- 2 Murach's MySQL, Joel Murach, 3rd Edition, 3rd Edition, 2019
- 1 MySQL: The Complete Reference, VikramVaswani , McGraw Hill, 2017
- 2 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. (Computer Science) 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.