Major Practical 1 Notes | B.Sc. (Information Technology) Semester 1 | Mumbai University | munotes

Contents

Module I Programming with C

1. How This Paper Is Examined, and What Your Journal Must Contain 1
2. Your First Program: Writing It, Compiling It and Running It 5
3. Writing the Algorithm, and Drawing the Flowchart 9
4. Practical 1(a): Simple Interest 13
5. Practical 1(b): The Greatest of Three Numbers, with the Conditional Operator 17
6. Practical 1(c): Is This a Leap Year? 20
7. Practical 2(a): The Roots of a Quadratic Equation 23
8. Practical 2(b): A Menu Driven Calculator, with switch 27
9. Practical 2(c): Patterns of Asterisks 31
10. Practical 3(a): Reversing the Digits of a Number 34
11. Practical 3(b): The Factorial of a Number 38
12. Practical 3(c): The Fibonacci Series 41
13. Practical 4(a): The Area of a Square, Using a Function 44
14. Practical 4(b): A Recursive Function 47
15. Practical 4(c): sqrt and abs, and the Headers They Need 51
16. Practical 4(d): The goto Statement 54
17. Practical 5(a): Ten Students' Roll Numbers and Names 57
18. Practical 5(b): Sorting an Array 61
19. Practical 6(a): Extracting Part of a String 65
20. Practical 6(b): Is This String a Palindrome? 68
21. Practical 6(c): strlen and strcmp 72
22. Practical 7: Swapping Two Numbers, by Value and by Reference 76
23. Practical 8(a): Reading a Matrix of m Rows and n Columns 80
24. Practical 8(b): Multiplying Two Matrices in a Function 83
25. Practical 9: A Structure, and Two Records of It 87
26. Practical 10: Designing the Bank Management System 91
27. Practical 10: The Bank Management System, Written and Run 95

Module II

1. Getting Into MySQL, and What a Database Is 100
2. Practical 1: The ER Diagram: Entities, Attributes and Keys 104
3. Practical 1: Relationships and Cardinality 109
4. Practical 1: Generalization and Specialization 112
5. Practical 2: Viewing Databases, Creating One and Listing Its Tables 115
6. Practical 2: Creating a Table, and Choosing Its Data Types 118
7. Practical 2: The Constraints, and What Each One Refuses 122
8. Practical 2: Inserting, Updating and Deleting Rows 127
9. Practical 3: Altering a Table That Already Holds Data 131
10. Practical 3: Dropping, Truncating and Renaming 136
11. Practical 3: Backing Up a Database, and Restoring It 140
12. Practical 4: Simple Queries 144
13. Practical 4: Aggregate Functions, GROUP BY and HAVING 149
14. Practical 5: Date Functions 153
15. Practical 5: String Functions 157
16. Practical 5: Math Functions 161
17. Practical 6: The Inner Join 165
18. Practical 6: The Outer Join 170
19. Practical 7: Subqueries with IN 175
20. Practical 7: Subqueries with EXISTS 180
21. Practical 8: Turning the ER Model Into Tables 184
22. Practical 8: Normalizing to Third Normal Form 189
23. Practical 9: Views 194
24. Practical 10: Granting and Revoking Permissions 199
25. Practical 10: COMMIT and ROLLBACK 203