Computer Science Practical 1 Notes | B.Sc. (Computer Science) Semester 1 | Mumbai University | munotes

Contents

Module I Digital Systems and Architecture: ten exercises in Logisim

1. How This Practical Is Examined: the Journal, the Write-Up and the Viva 1
2. Logisim from Zero: Installing It and Your First Circuit 6
3. Practical 1: Verifying the Truth Tables of the Logic Gates 11
4. Practical 2: Simplifying a Boolean Expression and Realising It 15
5. Practical 3: The Half Adder and the Full Adder 19
6. Practical 4: The Half Subtractor and the Full Subtractor 24
7. Practical 5: The 4-Bit Magnitude Comparator 28
8. Practical 6: D and JK Flip-Flops Built from Gates 32
9. Practical 7: Verifying the Operation of a Counter 37
10. Practical 8: The 4-Bit Shift Register 42
11. Practical 9: Realising Expressions with Multiplexers and Demultiplexers 46
12. Practical 10: A 3-Bit Binary Ripple Counter from JK Flip-Flops 51

Module II Fundamentals of Database Systems: ten exercises in MySQL

1. MySQL from Zero: Installing It, Connecting and Saving Your Work 55
2. Practical 11: Conceptual Design with an ER Diagram 60
3. Practical 12: Databases, Tables, Constraints and CRUD 65
4. Practical 13: ALTER, DROP, TRUNCATE, RENAME, and Backup and Restore 71
5. Practical 14: Simple Queries and the Aggregate Functions 76
6. Practical 15: Date, String and Mathematical Functions 81
7. Practical 16: Inner and Outer Joins 86
8. Practical 17: Subqueries with IN and EXISTS 92
9. Practical 18: From ER Model to Tables, and Normalising to 3NF 97
10. Practical 19: Views, With and Without CHECK OPTION 103
11. Practical 20: GRANT, REVOKE, COMMIT and ROLLBACK 108