What do you get
- All the notes of all the subjects in Semester 1, as per the latest syllabus 2026.
- Your own dashboard, where you can track everything you have read, subject by subject.
- Valid for one year, 365 days from the day you pay.
- If the University revises the syllabus while your year is running, the notes are rewritten to match and you read the new version at no extra cost. You are never asked to buy the same semester twice.
-
LINUX Operating System
Official Notes munotes.in
LINUX Operating System
B.SC. (COMPUTER SCIENCE) · SEMESTER 1
Strictly as per the University of Mumbai NEP syllabus in force for B.Sc. (Computer Science)
For B.Sc. (Computer Science) students of the University of Mumbai and all its affiliated colleges
munotes.in First Year
LINUX Operating System
Copyright © 2026 munotes.in. All rights reserved.
Written and first published by munotes.in, 2026.
This book is free for individual students to read at munotes.in. No part of it may be reproduced, distributed, stored, translated or used for institutional or classroom purposes in any form without a prior written licence from munotes.in.
Licensing and permissions: contact@munotes.in
The text of statutes and of judgments reproduced in this book is in the public domain under section 52(1)(q) of the Copyright Act 1957. The commentary, arrangement, examples and questions are the original work of munotes.in.
munotes.in is an independent study resource for MU students. It is not affiliated with, endorsed by, or officially connected to the University of Mumbai. Course names and university references describe the students and syllabus the material relates to.
Contents
Module I
- What an Operating System Is, and Where Linux Fits 1
- The History of Linux: Unix, MINIX, GNU and a Student's Kernel 4
- Linux Distributions, and Why There Are So Many 7
- The Architecture of a Unix or Linux System 10
- The Features of Unix and Linux 13
- Installing Ubuntu: Making the USB and Booting From It 17
- Installing Ubuntu: The Installer, Step by Step 20
- Installing Software: App Center, Synaptic and apt 23
- Packages, Repositories and the Software Worth Having 27
- Administering System and User Settings 30
- Keyboard Shortcuts, and the Story of Unity 33
- The Terminal: Where the Rest of This Book Happens 36
- Starting the Shell: Which Shell Are You Running 39
- The Shell Prompt, and How to Change It 42
- The Structure of a Command: Options and Arguments 44
- The File System: One Tree That Starts at / 47
- What Each Top-Level Directory Holds 50
- Paths: Absolute, Relative, Dot, Dot Dot and Tilde 53
- man Pages: Reading the Manual 55
- The Other Documentation: help, --help, info and apropos 58
Contents continued
Module I continued
- pwd and cd: Moving Around the Tree 61
- ls: Listing What Is There 63
- ls -l: Reading the Long Listing 65
- mkdir and rmdir: Making and Removing Directories 68
- touch: Making a File, and Changing Its Times 70
- find: Searching the Tree 73
- du, df and stat: How Much Space, and What Exactly Is This File 77
- cat: Reading, Making and Joining Files 80
- more and less: Reading a File That Will Not Fit 82
- cp: Copying Files and Directories 84
- mv: Moving and Renaming 86
- rm: Removing, and Why There Is No Undo 88
- file: What Kind of File Is This 91
- wc: Counting Lines, Words and Characters 93
- od: Looking at the Bytes Inside a File 95
- cmp, diff and comm: Comparing Two Files 98
- gzip and gunzip: Compressing One File 101
- zip and unzip: The Archive Windows Can Open 104
- tar: Packing a Whole Directory Into One File 106
Contents continued
Module I continued
- ln: Hard Links and Symbolic Links 109
- cal and date: The Calendar and the Clock 112
- echo and printf: Printing a Line 116
- who, whoami, uname and hostname: Who and Where Am I 118
- tty and stty: The Terminal Itself 121
- passwd: Changing Your Password 124
- script: Recording a Session, Which Is How the Journal Is Kept 127
- history, alias, which and clear: Working Faster 130
- Environment Variables: PATH, HOME and export 133
- File Permissions: Who Can Do What 137
- Reading the Ten Characters of ls -l 140
- Users and Groups 143
- chmod: Changing Permissions 146
- chown and chgrp: Changing the Owner and the Group 149
- umask: The Permissions a New File Is Born With 152
- The Special Bits: setuid, setgid and the Sticky Bit 155
Module II
- Understanding Linux Security 159
Contents continued
Module II continued
- root: What the Superuser Can Do 163
- sudo: Borrowing root for One Command 166
- Working With Passwords 169
- ssh: Logging In to Another Machine 173
- Keys Instead of Passwords, and Copying Files With scp 177
- who, whoami and w: Who Is On This Machine 181
- ping: Is That Machine There 184
- telnet and ftp: The Old Pair, and What Replaced Them 188
- ip, hostname, wget and curl 191
- Standard Input, Standard Output and Standard Error 195
- Redirection: >, >>, < and 2> 199
- Pipes: Joining Commands Together 202
- head and tail: The Beginning and the End 205
- cut and paste: Columns In and Out 208
- sort: Putting Lines in Order 211
- uniq: Collapsing and Counting Repeats 214
- tr: Translating and Deleting Characters 217
- tee: Saving the Middle of a Pipeline 220
- Regular Expressions: The Basic Set 223
Contents continued
Module II continued
- Extended Regular Expressions 228
- grep and the grep Family 232
- vi: The Three Modes 236
- vi: Moving, Editing, Searching and Saving 242
- sed: The Stream Editor 249
- awk: Records, Fields and Actions 254
- Your First Shell Script 260
- Variables, Quoting and Command Substitution 265
- read: Asking the User a Question 270
- exit and the Exit Status 274
- Arithmetic: expr, $(( )) and bc 278
- test and [ ]: Asking Questions About Files, Strings and Numbers 282
- if, elif and else 287
- Logical Operators: &&, || and ! 290
- case and Functions: the Other Control Structures 294
- The for Loop 299
- The while and until Loops 303
- Redirection Inside a Script, and Here Documents 307
- Creating Your Own Redirection: exec and File Descriptors 311
Contents continued
Module II continued
- Processes: What One Is, and ps 315
- Foreground, Background and Jobs 319
- kill and Signals 323
- nice and renice: Choosing a Priority 327
- top and the Other Process Tools 330
- at and batch: Running a Command Once, Later 334
- cron and the crontab: Running a Command Again and Again 339
- Installing the C and C++ Compilers 344
- A First C Program on Linux 348
- Installing Java, and a First Java Program 353
- Python on Linux, and a Virtual Environment 357
Module J The journal and the practical examination
- Keeping the Certified Journal 361
- The Practical Examination: What Q.1 and Q.2 Look Like 365
- Twelve Practicals on Module 1, Worked 369
- Twelve Practicals on Module 2, Worked 376
- The Viva: What You Will Be Asked, and the Answer 383
Page 1 onwards
389 pages in this book. The cover and the contents are above. Everything from page one is in the pass.
- Notes
- 2026 Edition, as per the latest syllabus. 389 pages.
Every chapter in the notes: 110 chapters across 3 modules
Module I 55 chapters
- 1 What an Operating System Is, and Where Linux Fits pages 1–3
- 2 The History of Linux: Unix, MINIX, GNU and a Student's Kernel pages 4–6
- 3 Linux Distributions, and Why There Are So Many pages 7–9
- 4 The Architecture of a Unix or Linux System pages 10–12
- 5 The Features of Unix and Linux pages 13–16
- 6 Installing Ubuntu: Making the USB and Booting From It pages 17–19
- 7 Installing Ubuntu: The Installer, Step by Step pages 20–22
- 8 Installing Software: App Center, Synaptic and apt pages 23–26
- 9 Packages, Repositories and the Software Worth Having pages 27–29
- 10 Administering System and User Settings pages 30–32
- 11 Keyboard Shortcuts, and the Story of Unity pages 33–35
- 12 The Terminal: Where the Rest of This Book Happens pages 36–38
- 13 Starting the Shell: Which Shell Are You Running pages 39–41
- 14 The Shell Prompt, and How to Change It pages 42–43
- 15 The Structure of a Command: Options and Arguments pages 44–46
- 16 The File System: One Tree That Starts at / pages 47–49
- 17 What Each Top-Level Directory Holds pages 50–52
- 18 Paths: Absolute, Relative, Dot, Dot Dot and Tilde pages 53–54
- 19 man Pages: Reading the Manual pages 55–57
- 20 The Other Documentation: help, --help, info and apropos pages 58–60
- 21 pwd and cd: Moving Around the Tree pages 61–62
- 22 ls: Listing What Is There pages 63–64
- 23 ls -l: Reading the Long Listing pages 65–67
- 24 mkdir and rmdir: Making and Removing Directories pages 68–69
- 25 touch: Making a File, and Changing Its Times pages 70–72
- 26 find: Searching the Tree pages 73–76
- 27 du, df and stat: How Much Space, and What Exactly Is This File pages 77–79
- 28 cat: Reading, Making and Joining Files pages 80–81
- 29 more and less: Reading a File That Will Not Fit pages 82–83
- 30 cp: Copying Files and Directories pages 84–85
- 31 mv: Moving and Renaming pages 86–87
- 32 rm: Removing, and Why There Is No Undo pages 88–90
- 33 file: What Kind of File Is This pages 91–92
- 34 wc: Counting Lines, Words and Characters pages 93–94
- 35 od: Looking at the Bytes Inside a File pages 95–97
- 36 cmp, diff and comm: Comparing Two Files pages 98–100
- 37 gzip and gunzip: Compressing One File pages 101–103
- 38 zip and unzip: The Archive Windows Can Open pages 104–105
- 39 tar: Packing a Whole Directory Into One File pages 106–108
- 40 ln: Hard Links and Symbolic Links pages 109–111
- 41 cal and date: The Calendar and the Clock pages 112–115
- 42 echo and printf: Printing a Line pages 116–117
- 43 who, whoami, uname and hostname: Who and Where Am I pages 118–120
- 44 tty and stty: The Terminal Itself pages 121–123
- 45 passwd: Changing Your Password pages 124–126
- 46 script: Recording a Session, Which Is How the Journal Is Kept pages 127–129
- 47 history, alias, which and clear: Working Faster pages 130–132
- 48 Environment Variables: PATH, HOME and export pages 133–136
- 49 File Permissions: Who Can Do What pages 137–139
- 50 Reading the Ten Characters of ls -l pages 140–142
- 51 Users and Groups pages 143–145
- 52 chmod: Changing Permissions pages 146–148
- 53 chown and chgrp: Changing the Owner and the Group pages 149–151
- 54 umask: The Permissions a New File Is Born With pages 152–154
- 55 The Special Bits: setuid, setgid and the Sticky Bit pages 155–158
Module II 50 chapters
- 56 Understanding Linux Security pages 159–162
- 57 root: What the Superuser Can Do pages 163–165
- 58 sudo: Borrowing root for One Command pages 166–168
- 59 Working With Passwords pages 169–172
- 60 ssh: Logging In to Another Machine pages 173–176
- 61 Keys Instead of Passwords, and Copying Files With scp pages 177–180
- 62 who, whoami and w: Who Is On This Machine pages 181–183
- 63 ping: Is That Machine There pages 184–187
- 64 telnet and ftp: The Old Pair, and What Replaced Them pages 188–190
- 65 ip, hostname, wget and curl pages 191–194
- 66 Standard Input, Standard Output and Standard Error pages 195–198
- 67 Redirection: >, >>, < and 2> pages 199–201
- 68 Pipes: Joining Commands Together pages 202–204
- 69 head and tail: The Beginning and the End pages 205–207
- 70 cut and paste: Columns In and Out pages 208–210
- 71 sort: Putting Lines in Order pages 211–213
- 72 uniq: Collapsing and Counting Repeats pages 214–216
- 73 tr: Translating and Deleting Characters pages 217–219
- 74 tee: Saving the Middle of a Pipeline pages 220–222
- 75 Regular Expressions: The Basic Set pages 223–227
- 76 Extended Regular Expressions pages 228–231
- 77 grep and the grep Family pages 232–235
- 78 vi: The Three Modes pages 236–241
- 79 vi: Moving, Editing, Searching and Saving pages 242–248
- 80 sed: The Stream Editor pages 249–253
- 81 awk: Records, Fields and Actions pages 254–259
- 82 Your First Shell Script pages 260–264
- 83 Variables, Quoting and Command Substitution pages 265–269
- 84 read: Asking the User a Question pages 270–273
- 85 exit and the Exit Status pages 274–277
- 86 Arithmetic: expr, $(( )) and bc pages 278–281
- 87 test and [ ]: Asking Questions About Files, Strings and Numbers pages 282–286
- 88 if, elif and else pages 287–289
- 89 Logical Operators: &&, || and ! pages 290–293
- 90 case and Functions: the Other Control Structures pages 294–298
- 91 The for Loop pages 299–302
- 92 The while and until Loops pages 303–306
- 93 Redirection Inside a Script, and Here Documents pages 307–310
- 94 Creating Your Own Redirection: exec and File Descriptors pages 311–314
- 95 Processes: What One Is, and ps pages 315–318
- 96 Foreground, Background and Jobs pages 319–322
- 97 kill and Signals pages 323–326
- 98 nice and renice: Choosing a Priority pages 327–329
- 99 top and the Other Process Tools pages 330–333
- 100 at and batch: Running a Command Once, Later pages 334–338
- 101 cron and the crontab: Running a Command Again and Again pages 339–343
- 102 Installing the C and C++ Compilers pages 344–347
- 103 A First C Program on Linux pages 348–352
- 104 Installing Java, and a First Java Program pages 353–356
- 105 Python on Linux, and a Virtual Environment pages 357–360
Module J The journal and the practical examination 5 chapters
- 106 Keeping the Certified Journal pages 361–364
- 107 The Practical Examination: What Q.1 and Q.2 Look Like pages 365–368
- 108 Twelve Practicals on Module 1, Worked pages 369–375
- 109 Twelve Practicals on Module 2, Worked pages 376–382
- 110 The Viva: What You Will Be Asked, and the Answer pages 383–389
-
Statistics with R Programming
Official Notes munotes.in
Statistics with R Programming
B.SC. (COMPUTER SCIENCE) · SEMESTER 1
Strictly as per the University of Mumbai NEP syllabus in force for B.Sc. (Computer Science)
For B.Sc. (Computer Science) students of the University of Mumbai and all its affiliated colleges
munotes.in First Year
Statistics with R Programming
Copyright © 2026 munotes.in. All rights reserved.
Written and first published by munotes.in, 2026.
This book is free for individual students to read at munotes.in. No part of it may be reproduced, distributed, stored, translated or used for institutional or classroom purposes in any form without a prior written licence from munotes.in.
Licensing and permissions: contact@munotes.in
The text of statutes and of judgments reproduced in this book is in the public domain under section 52(1)(q) of the Copyright Act 1957. The commentary, arrangement, examples and questions are the original work of munotes.in.
munotes.in is an independent study resource for MU students. It is not affiliated with, endorsed by, or officially connected to the University of Mumbai. Course names and university references describe the students and syllabus the material relates to.
Contents
Module I The R language and its environment: expressions, decisions, loops, data structures and strings
- What R Is, and Why Statistics Is Done in It 1
- A Short History of R, and What Open Source Means Here 4
- The Words R Uses: Object, Mode, Class and Attribute 7
- Installing R on Windows, macOS and Linux 10
- The R Environment: Console, Workspace and Working Directory 12
- Getting Help, and Installing Packages 15
- The R Graphical User Interface (R GUI) 18
- RStudio: Installing It and Reading Its Four Panes 21
- Customising RStudio 24
- R Commander: Statistics From a Menu 27
- Working With R Scripts 30
- Data Management in RStudio 33
- Reading Data In and Writing It Out 36
- Expressions: Arithmetic, Relational and Logical Operators 39
- Operator Precedence, and How R Reads an Expression 42
- Assignment, and the Rules for a Name 44
- Numbers, Logicals and the Values NA, NULL, NaN and Inf 47
- Decision Making: if, else and else if 50
- switch(), and the Vectorised ifelse() 52
- Loops: The for Loop 54
Contents continued
Module I continued The R language and its environment: expressions, decisions, loops, data structures and strings
- Loops: while, repeat, break and next 57
- Why R Prefers Vectorisation to a Loop 60
- Dates in R 63
- Times, Time Zones and Date Arithmetic 66
- Vectors: The Thing R Is Actually Made Of 69
- Indexing a Vector: Five Ways to Pick Elements 72
- Recycling, Coercion and Vectorised Arithmetic 75
- Matrices: Creating, Naming and Indexing 78
- Matrix Arithmetic and Matrix Algebra 81
- Row and Column Work: apply, rowSums, cbind and rbind 84
- Arrays: Three Dimensions and More 88
- Lists: The Container That Holds Anything 91
- Data Frames: The Table Statistics Works On 94
- Subsetting a Data Frame, and Adding or Dropping a Column 98
- Factors: How R Stores a Category 102
- Sorting, Ordering, Merging and Reshaping a Data Frame 105
- Writing Your Own Function 109
- Arguments, Defaults, and What a Function Returns 112
- Scope: Where R Looks a Name Up 115
Contents continued
Module I continued The R language and its environment: expressions, decisions, loops, data structures and strings
- The apply Family: apply, lapply, sapply, tapply and mapply 118
- Character Strings in R 121
- Strings and R Objects 124
- Printing Characters: print, cat and format 127
- sprintf(), and Building a Line of Output 130
- Basic String Manipulations 133
- Changing Case, Trimming and Padding 136
- String Operations: Searching and Replacing 139
- Regular Expressions, From Scratch 142
- Practical Session 1: Setting Up and Your First Script 145
- Practical Session 2: Expressions, Decisions and Loops 148
- Practical Session 3: Vectors, Matrices, Lists and Data Frames 152
- Practical Session 4: Functions, Strings and Dates 156
- Module 1: Viva Questions and Their Answers 160
Module II Statistics in R: summaries, regression, distributions, time series, tables and graphics
- What a Statistic Is: Population, Sample and Summary 164
- The mean() Function 167
- The Median 170
Contents continued
Module II continued Statistics in R: summaries, regression, distributions, time series, tables and graphics
- Standard Deviation and Variance 173
- Other Built-in Statistical Functions 176
- Quantiles, summary() and the Five-Number Summary 179
- Correlation, Covariance and scale() 182
- The Mode, and Why R Has No Function For It 186
- What Regression Analysis Is 189
- The Least Squares Line, Worked by Hand 192
- Linear Regression in R: lm(), Coefficients and Residuals 195
- Reading an lm() Summary 199
- Predicting From a Fitted Model 203
- Multiple Regression 207
- Checking a Regression: Residual Plots and What They Say 211
- The Normal Distribution 215
- dnorm(): The Normal Density 218
- pnorm(): The Normal Cumulative Probability 221
- qnorm(): The Normal Quantile 224
- rnorm(): Random Normal Samples, and set.seed() 227
- The Binomial Distribution 230
- dbinom(): The Exact Binomial Probability 233
Contents continued
Module II continued Statistics in R: summaries, regression, distributions, time series, tables and graphics
- pbinom(): The Cumulative Binomial Probability 236
- qbinom(): The Binomial Quantile 239
- rbinom(): Simulating Binomial Trials 242
- Choosing Which Distribution Function to Call 245
- Time Series Analysis: The ts Object 248
- Trend, Seasonality and Decomposition 252
- Moving Averages and a Simple Forecast 255
- Tabulation: Counting With table() 259
- Contingency Tables: What They Show 262
- Making R Contingency Tables 266
- Making Custom Contingency Tables 270
- Selecting Parts of a Table Object 274
- Converting an Object Into a Table 277
- Testing Table Objects, and the Chi-Squared Test 280
- Complex Tables: Margins, Proportions and ftable 283
- Representing Data Through Cross Tabulation 287
- How an R Plot Is Built: Devices, High-Level and Low-Level 291
- Plots of a Single Variable: Histogram and Density 295
- Plots of a Single Variable: Bar, Pie and Dot Chart 299
Contents continued
Module II continued Statistics in R: summaries, regression, distributions, time series, tables and graphics
- Plots of a Single Variable: Box Plot and Stem-and-Leaf 302
- Plots of Two Variables: The Scatter Plot and Its Line 305
- Plots of Multiple Variables 308
- Special Plots: QQ, Mosaic, Coplot and curve 311
- Labels, Legends, Colours and Layout 315
- Storing Graphics 319
- Practical Session 5: Summary Statistics on a Data Frame 322
- Practical Session 6: Regression, End to End 326
- Practical Session 7: The Distribution Functions 330
- Practical Session 8: Tables and Cross Tabulation 334
- Practical Session 9: Plots and Saving Them 338
- Module 2: Viva Questions and Their Answers 342
Page 1 onwards
346 pages in this book. The cover and the contents are above. Everything from page one is in the pass.
- Notes
- 2026 Edition, as per the latest syllabus. 346 pages.
Every chapter in the notes: 106 chapters across 2 modules
Module I The R language and its environment: expressions, decisions, loops, data structures and strings 53 chapters
- 1 What R Is, and Why Statistics Is Done in It pages 1–3
- 2 A Short History of R, and What Open Source Means Here pages 4–6
- 3 The Words R Uses: Object, Mode, Class and Attribute pages 7–9
- 4 Installing R on Windows, macOS and Linux pages 10–11
- 5 The R Environment: Console, Workspace and Working Directory pages 12–14
- 6 Getting Help, and Installing Packages pages 15–17
- 7 The R Graphical User Interface (R GUI) pages 18–20
- 8 RStudio: Installing It and Reading Its Four Panes pages 21–23
- 9 Customising RStudio pages 24–26
- 10 R Commander: Statistics From a Menu pages 27–29
- 11 Working With R Scripts pages 30–32
- 12 Data Management in RStudio pages 33–35
- 13 Reading Data In and Writing It Out pages 36–38
- 14 Expressions: Arithmetic, Relational and Logical Operators pages 39–41
- 15 Operator Precedence, and How R Reads an Expression pages 42–43
- 16 Assignment, and the Rules for a Name pages 44–46
- 17 Numbers, Logicals and the Values NA, NULL, NaN and Inf pages 47–49
- 18 Decision Making: if, else and else if pages 50–51
- 19 switch(), and the Vectorised ifelse() pages 52–53
- 20 Loops: The for Loop pages 54–56
- 21 Loops: while, repeat, break and next pages 57–59
- 22 Why R Prefers Vectorisation to a Loop pages 60–62
- 23 Dates in R pages 63–65
- 24 Times, Time Zones and Date Arithmetic pages 66–68
- 25 Vectors: The Thing R Is Actually Made Of pages 69–71
- 26 Indexing a Vector: Five Ways to Pick Elements pages 72–74
- 27 Recycling, Coercion and Vectorised Arithmetic pages 75–77
- 28 Matrices: Creating, Naming and Indexing pages 78–80
- 29 Matrix Arithmetic and Matrix Algebra pages 81–83
- 30 Row and Column Work: apply, rowSums, cbind and rbind pages 84–87
- 31 Arrays: Three Dimensions and More pages 88–90
- 32 Lists: The Container That Holds Anything pages 91–93
- 33 Data Frames: The Table Statistics Works On pages 94–97
- 34 Subsetting a Data Frame, and Adding or Dropping a Column pages 98–101
- 35 Factors: How R Stores a Category pages 102–104
- 36 Sorting, Ordering, Merging and Reshaping a Data Frame pages 105–108
- 37 Writing Your Own Function pages 109–111
- 38 Arguments, Defaults, and What a Function Returns pages 112–114
- 39 Scope: Where R Looks a Name Up pages 115–117
- 40 The apply Family: apply, lapply, sapply, tapply and mapply pages 118–120
- 41 Character Strings in R pages 121–123
- 42 Strings and R Objects pages 124–126
- 43 Printing Characters: print, cat and format pages 127–129
- 44 sprintf(), and Building a Line of Output pages 130–132
- 45 Basic String Manipulations pages 133–135
- 46 Changing Case, Trimming and Padding pages 136–138
- 47 String Operations: Searching and Replacing pages 139–141
- 48 Regular Expressions, From Scratch pages 142–144
- 49 Practical Session 1: Setting Up and Your First Script pages 145–147
- 50 Practical Session 2: Expressions, Decisions and Loops pages 148–151
- 51 Practical Session 3: Vectors, Matrices, Lists and Data Frames pages 152–155
- 52 Practical Session 4: Functions, Strings and Dates pages 156–159
- 53 Module 1: Viva Questions and Their Answers pages 160–163
Module II Statistics in R: summaries, regression, distributions, time series, tables and graphics 53 chapters
- 54 What a Statistic Is: Population, Sample and Summary pages 164–166
- 55 The mean() Function pages 167–169
- 56 The Median pages 170–172
- 57 Standard Deviation and Variance pages 173–175
- 58 Other Built-in Statistical Functions pages 176–178
- 59 Quantiles, summary() and the Five-Number Summary pages 179–181
- 60 Correlation, Covariance and scale() pages 182–185
- 61 The Mode, and Why R Has No Function For It pages 186–188
- 62 What Regression Analysis Is pages 189–191
- 63 The Least Squares Line, Worked by Hand pages 192–194
- 64 Linear Regression in R: lm(), Coefficients and Residuals pages 195–198
- 65 Reading an lm() Summary pages 199–202
- 66 Predicting From a Fitted Model pages 203–206
- 67 Multiple Regression pages 207–210
- 68 Checking a Regression: Residual Plots and What They Say pages 211–214
- 69 The Normal Distribution pages 215–217
- 70 dnorm(): The Normal Density pages 218–220
- 71 pnorm(): The Normal Cumulative Probability pages 221–223
- 72 qnorm(): The Normal Quantile pages 224–226
- 73 rnorm(): Random Normal Samples, and set.seed() pages 227–229
- 74 The Binomial Distribution pages 230–232
- 75 dbinom(): The Exact Binomial Probability pages 233–235
- 76 pbinom(): The Cumulative Binomial Probability pages 236–238
- 77 qbinom(): The Binomial Quantile pages 239–241
- 78 rbinom(): Simulating Binomial Trials pages 242–244
- 79 Choosing Which Distribution Function to Call pages 245–247
- 80 Time Series Analysis: The ts Object pages 248–251
- 81 Trend, Seasonality and Decomposition pages 252–254
- 82 Moving Averages and a Simple Forecast pages 255–258
- 83 Tabulation: Counting With table() pages 259–261
- 84 Contingency Tables: What They Show pages 262–265
- 85 Making R Contingency Tables pages 266–269
- 86 Making Custom Contingency Tables pages 270–273
- 87 Selecting Parts of a Table Object pages 274–276
- 88 Converting an Object Into a Table pages 277–279
- 89 Testing Table Objects, and the Chi-Squared Test pages 280–282
- 90 Complex Tables: Margins, Proportions and ftable pages 283–286
- 91 Representing Data Through Cross Tabulation pages 287–290
- 92 How an R Plot Is Built: Devices, High-Level and Low-Level pages 291–294
- 93 Plots of a Single Variable: Histogram and Density pages 295–298
- 94 Plots of a Single Variable: Bar, Pie and Dot Chart pages 299–301
- 95 Plots of a Single Variable: Box Plot and Stem-and-Leaf pages 302–304
- 96 Plots of Two Variables: The Scatter Plot and Its Line pages 305–307
- 97 Plots of Multiple Variables pages 308–310
- 98 Special Plots: QQ, Mosaic, Coplot and curve pages 311–314
- 99 Labels, Legends, Colours and Layout pages 315–318
- 100 Storing Graphics pages 319–321
- 101 Practical Session 5: Summary Statistics on a Data Frame pages 322–325
- 102 Practical Session 6: Regression, End to End pages 326–329
- 103 Practical Session 7: The Distribution Functions pages 330–333
- 104 Practical Session 8: Tables and Cross Tabulation pages 334–337
- 105 Practical Session 9: Plots and Saving Them pages 338–341
- 106 Module 2: Viva Questions and Their Answers pages 342–346
-
Introduction to Programming with Python
Official Notes munotes.in
Introduction to Programming with Python
B.SC. (COMPUTER SCIENCE) · SEMESTER 1
Strictly as per the University of Mumbai NEP syllabus in force for B.Sc. (Computer Science)
For B.Sc. (Computer Science) students of the University of Mumbai and all its affiliated colleges
munotes.in First Year
Introduction to Programming with Python
Copyright © 2026 munotes.in. All rights reserved.
Written and first published by munotes.in, 2026.
This book is free for individual students to read at munotes.in. No part of it may be reproduced, distributed, stored, translated or used for institutional or classroom purposes in any form without a prior written licence from munotes.in.
Licensing and permissions: contact@munotes.in
The text of statutes and of judgments reproduced in this book is in the public domain under section 52(1)(q) of the Copyright Act 1957. The commentary, arrangement, examples and questions are the original work of munotes.in.
munotes.in is an independent study resource for MU students. It is not affiliated with, endorsed by, or officially connected to the University of Mumbai. Course names and university references describe the students and syllabus the material relates to.
Contents
Module I Overview and basic elements, control statements, arrays, functions and strings
- What Python Is, and the Features That Made It Popular 1
- Installing Python and Running Your First Program 7
- How a Python Program Is Executed: Source, Bytecode and the PVM 11
- The Flavours of Python 15
- The Python Interpreter: The Prompt and the Command Line 18
- Comments and Docstrings 22
- IDLE: Python's Own Editor and Shell 26
- The Data Types Python Gives You 30
- Dictionaries, Sets and Mappings: A First Look 35
- The Basic Elements of a Python Program 39
- Variables and How Python Stores a Value 44
- Reading Input: The input() Function 48
- Printing Output: The print() Function 52
- Command Line Arguments 56
- Operators, Part One: Arithmetic, Relational and Logical 59
- Operators, Part Two: Bitwise, Assignment, Membership and Identity 63
- Precedence and Associativity of Operators 68
- The if Statement 73
- The if...else Statement 77
Contents continued
Module I continued Overview and basic elements, control statements, arrays, functions and strings
- The if...elif...else Statement 80
- The while Loop 84
- The for Loop and range() 88
- Infinite Loops and Nested Loops 92
- The else Suite on a Loop 97
- break, continue and pass 100
- The assert Statement 104
- The return Statement 108
- Arrays: Creating Them with the array Module 112
- Indexing and Slicing an Array 116
- Basic Array Operations and Array Processing 120
- Mathematical Operations on an Array with NumPy 125
- Aliasing, Viewing and Copying an Array 129
- Slicing and Indexing a NumPy Array 134
- Advanced Indexing: Integer Arrays and Boolean Masks 138
- The Dimensions and Attributes of an Array 143
- Defining a Function and Calling It 148
- Returning Results, and Returning More Than One 152
- The Built-in Functions 156
Contents continued
Module I continued Overview and basic elements, control statements, arrays, functions and strings
- A Function and a Method: The Difference 160
- How Python Passes a Value: Object Reference 164
- Parameters and Arguments 168
- Recursive Functions 172
- Anonymous Functions: lambda 177
- Modules in Python 181
- Creating Strings 186
- The Functions and Methods of a String 190
- Working with Strings 194
- Formatting Strings 198
- Counting Characters and Words in a String 202
- Inserting a Substring into a String 206
- Module 1 Practicals: The Programs for Your Journal 210
Module II Lists, tuples and dictionaries, files, regular expressions, and date and time
- Lists: What They Are and How to Make One 217
- List Functions and Methods 222
- List Operations 226
- List Slices 231
- Nested Lists, and the Matrix 235
Contents continued
Module II continued Lists, tuples and dictionaries, files, regular expressions, and date and time
- Tuples 240
- The Functions That Work on a Tuple 244
- Creating a Dictionary 248
- Operators in a Dictionary 253
- Dictionary Methods 257
- Looping Over a Dictionary 261
- Operations on Dictionaries 265
- Opening and Closing a File 269
- Working with Text Files 273
- The with Statement 277
- Working with Binary Files 281
- Pickle: Storing an Object in a File 285
- seek() and tell(): Where You Are in a File 290
- Random Access to a Binary File 295
- Zipping and Unzipping Files 300
- Working with Directories 305
- Regular Expressions: What They Are and Why 310
- Sequence Characters in a Regular Expression 315
- Special Characters in a Regular Expression 320
Contents continued
Module II continued Lists, tuples and dictionaries, files, regular expressions, and date and time
- Using a Regular Expression on a File 325
- Retrieving Information from an HTML File 330
- Time in Python 335
- Dates 339
- The Date and Time Now, and Combining Them 343
- Formatting a Date and a Time 347
- Finding and Comparing Dates 352
- Sorting Dates 357
- Knowing the Time a Program Takes 362
- Working with the Calendar Module 367
- Module 2 Practicals: The Programs for Your Journal 373
- The Practical Examination, the Journal and the Viva 383
Page 1 onwards
389 pages in this book. The cover and the contents are above. Everything from page one is in the pass.
- Notes
- 2026 Edition, as per the latest syllabus. 389 pages.
Every chapter in the notes: 87 chapters across 2 modules
Module I Overview and basic elements, control statements, arrays, functions and strings 51 chapters
- 1 What Python Is, and the Features That Made It Popular pages 1–6
- 2 Installing Python and Running Your First Program pages 7–10
- 3 How a Python Program Is Executed: Source, Bytecode and the PVM pages 11–14
- 4 The Flavours of Python pages 15–17
- 5 The Python Interpreter: The Prompt and the Command Line pages 18–21
- 6 Comments and Docstrings pages 22–25
- 7 IDLE: Python's Own Editor and Shell pages 26–29
- 8 The Data Types Python Gives You pages 30–34
- 9 Dictionaries, Sets and Mappings: A First Look pages 35–38
- 10 The Basic Elements of a Python Program pages 39–43
- 11 Variables and How Python Stores a Value pages 44–47
- 12 Reading Input: The input() Function pages 48–51
- 13 Printing Output: The print() Function pages 52–55
- 14 Command Line Arguments pages 56–58
- 15 Operators, Part One: Arithmetic, Relational and Logical pages 59–62
- 16 Operators, Part Two: Bitwise, Assignment, Membership and Identity pages 63–67
- 17 Precedence and Associativity of Operators pages 68–72
- 18 The if Statement pages 73–76
- 19 The if...else Statement pages 77–79
- 20 The if...elif...else Statement pages 80–83
- 21 The while Loop pages 84–87
- 22 The for Loop and range() pages 88–91
- 23 Infinite Loops and Nested Loops pages 92–96
- 24 The else Suite on a Loop pages 97–99
- 25 break, continue and pass pages 100–103
- 26 The assert Statement pages 104–107
- 27 The return Statement pages 108–111
- 28 Arrays: Creating Them with the array Module pages 112–115
- 29 Indexing and Slicing an Array pages 116–119
- 30 Basic Array Operations and Array Processing pages 120–124
- 31 Mathematical Operations on an Array with NumPy pages 125–128
- 32 Aliasing, Viewing and Copying an Array pages 129–133
- 33 Slicing and Indexing a NumPy Array pages 134–137
- 34 Advanced Indexing: Integer Arrays and Boolean Masks pages 138–142
- 35 The Dimensions and Attributes of an Array pages 143–147
- 36 Defining a Function and Calling It pages 148–151
- 37 Returning Results, and Returning More Than One pages 152–155
- 38 The Built-in Functions pages 156–159
- 39 A Function and a Method: The Difference pages 160–163
- 40 How Python Passes a Value: Object Reference pages 164–167
- 41 Parameters and Arguments pages 168–171
- 42 Recursive Functions pages 172–176
- 43 Anonymous Functions: lambda pages 177–180
- 44 Modules in Python pages 181–185
- 45 Creating Strings pages 186–189
- 46 The Functions and Methods of a String pages 190–193
- 47 Working with Strings pages 194–197
- 48 Formatting Strings pages 198–201
- 49 Counting Characters and Words in a String pages 202–205
- 50 Inserting a Substring into a String pages 206–209
- 51 Module 1 Practicals: The Programs for Your Journal pages 210–216
Module II Lists, tuples and dictionaries, files, regular expressions, and date and time 36 chapters
- 52 Lists: What They Are and How to Make One pages 217–221
- 53 List Functions and Methods pages 222–225
- 54 List Operations pages 226–230
- 55 List Slices pages 231–234
- 56 Nested Lists, and the Matrix pages 235–239
- 57 Tuples pages 240–243
- 58 The Functions That Work on a Tuple pages 244–247
- 59 Creating a Dictionary pages 248–252
- 60 Operators in a Dictionary pages 253–256
- 61 Dictionary Methods pages 257–260
- 62 Looping Over a Dictionary pages 261–264
- 63 Operations on Dictionaries pages 265–268
- 64 Opening and Closing a File pages 269–272
- 65 Working with Text Files pages 273–276
- 66 The with Statement pages 277–280
- 67 Working with Binary Files pages 281–284
- 68 Pickle: Storing an Object in a File pages 285–289
- 69 seek() and tell(): Where You Are in a File pages 290–294
- 70 Random Access to a Binary File pages 295–299
- 71 Zipping and Unzipping Files pages 300–304
- 72 Working with Directories pages 305–309
- 73 Regular Expressions: What They Are and Why pages 310–314
- 74 Sequence Characters in a Regular Expression pages 315–319
- 75 Special Characters in a Regular Expression pages 320–324
- 76 Using a Regular Expression on a File pages 325–329
- 77 Retrieving Information from an HTML File pages 330–334
- 78 Time in Python pages 335–338
- 79 Dates pages 339–342
- 80 The Date and Time Now, and Combining Them pages 343–346
- 81 Formatting a Date and a Time pages 347–351
- 82 Finding and Comparing Dates pages 352–356
- 83 Sorting Dates pages 357–361
- 84 Knowing the Time a Program Takes pages 362–366
- 85 Working with the Calendar Module pages 367–372
- 86 Module 2 Practicals: The Programs for Your Journal pages 373–382
- 87 The Practical Examination, the Journal and the Viva pages 383–389
-
Digital System and Architecture
Official Notes munotes.in
Digital System and Architecture
B.SC. (COMPUTER SCIENCE) · SEMESTER 1
Strictly as per the University of Mumbai NEP syllabus in force for B.Sc. (Computer Science)
For B.Sc. (Computer Science) students of the University of Mumbai and all its affiliated colleges
munotes.in First Year
Digital System and Architecture
Copyright © 2026 munotes.in. All rights reserved.
Written and first published by munotes.in, 2026.
This book is free for individual students to read at munotes.in. No part of it may be reproduced, distributed, stored, translated or used for institutional or classroom purposes in any form without a prior written licence from munotes.in.
Licensing and permissions: contact@munotes.in
The text of statutes and of judgments reproduced in this book is in the public domain under section 52(1)(q) of the Copyright Act 1957. The commentary, arrangement, examples and questions are the original work of munotes.in.
munotes.in is an independent study resource for MU students. It is not affiliated with, endorsed by, or officially connected to the University of Mumbai. Course names and university references describe the students and syllabus the material relates to.
Contents
Module I Fundamentals of digital logic, combinational and sequential circuits, and the computer system
- How a Computer Represents Numbers: Bits, Bytes and Number Systems 1
- Converting Between Number Systems 9
- Binary Arithmetic 15
- Signed Numbers and Complements 21
- Codes: BCD, Excess-3, Gray Code, ASCII and Parity 28
- Boolean Algebra: What It Is and Where It Came From 34
- The Laws and Theorems of Boolean Algebra 41
- Logic Gates 50
- Universal Gates: Building Every Gate from NAND or NOR 56
- Canonical Forms: Minterms, Maxterms, SOP and POS 61
- Algebraic Simplification of Logic Circuits 66
- Karnaugh Maps: Two, Three and Four Variables 71
- Karnaugh Maps with Don't-Care Conditions, and POS Simplification 76
- Combinational Circuits, and How One Is Designed 81
- The Half Adder and the Full Adder 86
- The Parallel Binary Adder 90
- The Half Subtractor and the Full Subtractor 93
- Subtraction with an Adder: the 2's Complement Adder-Subtractor 97
- The Magnitude Comparator 101
Contents continued
Module I continued Fundamentals of digital logic, combinational and sequential circuits, and the computer system
- The Multiplexer 104
- Implementing Boolean Functions with a Multiplexer 107
- The Demultiplexer and the Decoder 111
- Implementing Boolean Functions with a Demultiplexer 114
- Sequential Circuits: Memory and the Clock 117
- The SR Latch and the SR Flip-Flop 121
- The JK Flip-Flop, the Race-Around Condition and the Master-Slave JK 125
- The D Flip-Flop 129
- Triggering, Characteristic Tables and Excitation Tables 132
- Asynchronous (Ripple) Counters 136
- Synchronous Counters, and How to Design One 139
- Shift Registers 143
- Computer Organization and Computer Architecture 146
- The Components of a Computer and What Each Does 149
- How a Computer Works at the Top Level: Fetch, Execute and Interrupts 153
- Interconnection Structures 156
- Bus Interconnection 159
- Multiple-Bus Hierarchies and the Elements of Bus Design 162
Contents continued
Module I continued Fundamentals of digital logic, combinational and sequential circuits, and the computer system
- The I/O Module 166
- Programmed I/O 169
- Interrupt-Driven I/O 172
- Direct Memory Access 175
Module II Memory system organization, instructions and processor organization (8085 and 8086)
- Memory: How It Is Classified and What Describes It 178
- The Memory Hierarchy and Locality of Reference 182
- Semiconductor Main Memory: RAM and the ROM Family 186
- SRAM and DRAM 190
- Interleaved Memory 194
- Associative Memory 197
- Cache Memory: The Principle and the Elements of Cache Design 201
- Cache Mapping: Direct, Associative and Set-Associative 205
- Replacement Algorithms 209
- Write Policies 214
- Cache Performance 218
- Cache Coherence 222
- Virtual Memory: Paging, Page Tables and the TLB 226
- Segmentation 231
Contents continued
Module II continued Memory system organization, instructions and processor organization (8085 and 8086)
- Magnetic Disks 235
- Optical Memory 239
- Flash Memory and the Solid-State Drive 244
- RAID Levels 248
- Machine Instructions and Their Elements 253
- Instruction Formats: Three, Two, One and Zero Addresses 256
- Instruction Sets: Types of Operands 260
- Instruction Sets: Types of Operations 263
- Addressing Modes 267
- Meet the 8085 and the 8086 271
- Addressing Modes on the 8085, with Assembly Examples 274
- Addressing Modes on the 8086, with Assembly Examples 277
- Processor Organization: Structure and Function 282
- The Control Unit: Hardwired and Microprogrammed 285
- Register Organization 289
- The 8085's Registers and Flags 293
- The 8086's Registers 297
- Data Transfer Operations 301
- Arithmetic Operations 305
Contents continued
Module II continued Memory system organization, instructions and processor organization (8085 and 8086)
- Logical Operations 309
- 8085 Programs: Putting the Groups Together 313
- The Instruction Cycle 318
- Instruction Pipelining 321
- Pipeline Hazards and Branches 324
- RISC and CISC Architecture 328
- Instruction-Level Parallelism and Superscalar Processors 332
- Superscalar Design Issues 336
Page 1 onwards
339 pages in this book. The cover and the contents are above. Everything from page one is in the pass.
- Notes
- 2026 Edition, as per the latest syllabus. 339 pages.
Every chapter in the notes: 82 chapters across 2 modules
Module I Fundamentals of digital logic, combinational and sequential circuits, and the computer system 41 chapters
- 1 How a Computer Represents Numbers: Bits, Bytes and Number Systems pages 1–8
- 2 Converting Between Number Systems pages 9–14
- 3 Binary Arithmetic pages 15–20
- 4 Signed Numbers and Complements pages 21–27
- 5 Codes: BCD, Excess-3, Gray Code, ASCII and Parity pages 28–33
- 6 Boolean Algebra: What It Is and Where It Came From pages 34–40
- 7 The Laws and Theorems of Boolean Algebra pages 41–49
- 8 Logic Gates pages 50–55
- 9 Universal Gates: Building Every Gate from NAND or NOR pages 56–60
- 10 Canonical Forms: Minterms, Maxterms, SOP and POS pages 61–65
- 11 Algebraic Simplification of Logic Circuits pages 66–70
- 12 Karnaugh Maps: Two, Three and Four Variables pages 71–75
- 13 Karnaugh Maps with Don't-Care Conditions, and POS Simplification pages 76–80
- 14 Combinational Circuits, and How One Is Designed pages 81–85
- 15 The Half Adder and the Full Adder pages 86–89
- 16 The Parallel Binary Adder pages 90–92
- 17 The Half Subtractor and the Full Subtractor pages 93–96
- 18 Subtraction with an Adder: the 2's Complement Adder-Subtractor pages 97–100
- 19 The Magnitude Comparator pages 101–103
- 20 The Multiplexer pages 104–106
- 21 Implementing Boolean Functions with a Multiplexer pages 107–110
- 22 The Demultiplexer and the Decoder pages 111–113
- 23 Implementing Boolean Functions with a Demultiplexer pages 114–116
- 24 Sequential Circuits: Memory and the Clock pages 117–120
- 25 The SR Latch and the SR Flip-Flop pages 121–124
- 26 The JK Flip-Flop, the Race-Around Condition and the Master-Slave JK pages 125–128
- 27 The D Flip-Flop pages 129–131
- 28 Triggering, Characteristic Tables and Excitation Tables pages 132–135
- 29 Asynchronous (Ripple) Counters pages 136–138
- 30 Synchronous Counters, and How to Design One pages 139–142
- 31 Shift Registers pages 143–145
- 32 Computer Organization and Computer Architecture pages 146–148
- 33 The Components of a Computer and What Each Does pages 149–152
- 34 How a Computer Works at the Top Level: Fetch, Execute and Interrupts pages 153–155
- 35 Interconnection Structures pages 156–158
- 36 Bus Interconnection pages 159–161
- 37 Multiple-Bus Hierarchies and the Elements of Bus Design pages 162–165
- 38 The I/O Module pages 166–168
- 39 Programmed I/O pages 169–171
- 40 Interrupt-Driven I/O pages 172–174
- 41 Direct Memory Access pages 175–177
Module II Memory system organization, instructions and processor organization (8085 and 8086) 41 chapters
- 42 Memory: How It Is Classified and What Describes It pages 178–181
- 43 The Memory Hierarchy and Locality of Reference pages 182–185
- 44 Semiconductor Main Memory: RAM and the ROM Family pages 186–189
- 45 SRAM and DRAM pages 190–193
- 46 Interleaved Memory pages 194–196
- 47 Associative Memory pages 197–200
- 48 Cache Memory: The Principle and the Elements of Cache Design pages 201–204
- 49 Cache Mapping: Direct, Associative and Set-Associative pages 205–208
- 50 Replacement Algorithms pages 209–213
- 51 Write Policies pages 214–217
- 52 Cache Performance pages 218–221
- 53 Cache Coherence pages 222–225
- 54 Virtual Memory: Paging, Page Tables and the TLB pages 226–230
- 55 Segmentation pages 231–234
- 56 Magnetic Disks pages 235–238
- 57 Optical Memory pages 239–243
- 58 Flash Memory and the Solid-State Drive pages 244–247
- 59 RAID Levels pages 248–252
- 60 Machine Instructions and Their Elements pages 253–255
- 61 Instruction Formats: Three, Two, One and Zero Addresses pages 256–259
- 62 Instruction Sets: Types of Operands pages 260–262
- 63 Instruction Sets: Types of Operations pages 263–266
- 64 Addressing Modes pages 267–270
- 65 Meet the 8085 and the 8086 pages 271–273
- 66 Addressing Modes on the 8085, with Assembly Examples pages 274–276
- 67 Addressing Modes on the 8086, with Assembly Examples pages 277–281
- 68 Processor Organization: Structure and Function pages 282–284
- 69 The Control Unit: Hardwired and Microprogrammed pages 285–288
- 70 Register Organization pages 289–292
- 71 The 8085's Registers and Flags pages 293–296
- 72 The 8086's Registers pages 297–300
- 73 Data Transfer Operations pages 301–304
- 74 Arithmetic Operations pages 305–308
- 75 Logical Operations pages 309–312
- 76 8085 Programs: Putting the Groups Together pages 313–317
- 77 The Instruction Cycle pages 318–320
- 78 Instruction Pipelining pages 321–323
- 79 Pipeline Hazards and Branches pages 324–327
- 80 RISC and CISC Architecture pages 328–331
- 81 Instruction-Level Parallelism and Superscalar Processors pages 332–335
- 82 Superscalar Design Issues pages 336–339
-
Fundamentals of Database Systems
Official Notes munotes.in
Fundamentals of Database Systems
B.SC. (COMPUTER SCIENCE) · SEMESTER 1
Strictly as per the University of Mumbai NEP syllabus in force for B.Sc. (Computer Science)
For B.Sc. (Computer Science) students of the University of Mumbai and all its affiliated colleges
munotes.in First Year
Fundamentals of Database Systems
Copyright © 2026 munotes.in. All rights reserved.
Written and first published by munotes.in, 2026.
This book is free for individual students to read at munotes.in. No part of it may be reproduced, distributed, stored, translated or used for institutional or classroom purposes in any form without a prior written licence from munotes.in.
Licensing and permissions: contact@munotes.in
The text of statutes and of judgments reproduced in this book is in the public domain under section 52(1)(q) of the Copyright Act 1957. The commentary, arrangement, examples and questions are the original work of munotes.in.
munotes.in is an independent study resource for MU students. It is not affiliated with, endorsed by, or officially connected to the University of Mumbai. Course names and university references describe the students and syllabus the material relates to.
Contents
Module I Introduction to DBMS, data models, the ER model and ER to table, DDL and DML statements
- What a Database Is, and What a DBMS Does 1
- Why Not Just Files: the Advantages of a DBMS 6
- The Three Levels of Abstraction 10
- Data Independence 14
- The Architecture of a DBMS 18
- What a Data Model Is 22
- Client/Server Architecture 26
- Object Based Logical Models 30
- Record Based Logical Models: Relational, Hierarchical and Network 34
- The Entity Relationship Model: Entities, Attributes and Entity Sets 38
- Relationships and Relationship Sets 42
- Key Constraints and the Cardinality of a Relationship 46
- Participation Constraints 50
- Weak Entity Sets 54
- Generalization, Specialization and Aggregation 58
- Conceptual Design: Entity or Attribute 62
- Conceptual Design: Entity or Relationship 66
- Conceptual Design: Binary or Ternary 70
- Constraints Beyond the ER Model 73
Contents continued
Module I continued Introduction to DBMS, data models, the ER model and ER to table, DDL and DML statements
- Turning an Entity Set Into a Table 77
- Turning a Relationship Set Into Tables 81
- Meeting MySQL: the Server, the Client and Your First Database 85
- Data Types 89
- Creating a Table 94
- Integrity Constraints: PRIMARY KEY, NOT NULL, DEFAULT and CHECK 98
- Altering a Table 102
- Renaming, Dropping and Truncating Tables 106
- Viewing the Structure of a Table 109
- INSERT: Putting Rows In 112
- UPDATE and DELETE: Changing and Removing Rows 116
- SELECT: All Columns and Named Columns 120
- DISTINCT: Unique Records 124
- The WHERE Clause 127
- IN and BETWEEN 131
- ORDER BY and LIMIT 135
- Aggregate Functions: COUNT, MIN, MAX, AVG and SUM 139
- GROUP BY 142
Contents continued
Module I continued Introduction to DBMS, data models, the ER model and ER to table, DDL and DML statements
- HAVING 146
Module II The relational data model, functions, joins and subqueries, normal forms, database protection, views and DCL
- The Relational Data Model: Domains, Attributes, Tuples and Relations 150
- Relational Model Notation 154
- Characteristics of Relations 157
- Relational Constraints: the Primary Key 161
- Referential Integrity and the Foreign Key 165
- UNIQUE, NOT NULL and CHECK Constraints 170
- String Functions 174
- Math Functions 178
- Date and Time Functions 181
- The Inner Join 185
- The Outer Joins, and What MySQL Does About FULL OUTER 190
- Subqueries with IN and EXISTS 195
- Nested Subqueries, and What a Subquery May Not Do 199
- ANY and ALL 203
- Correlated Subqueries 207
- Functional Dependencies 211
Contents continued
Module II continued The relational data model, functions, joins and subqueries, normal forms, database protection, views and DCL
- First Normal Form 216
- Second Normal Form 220
- Third Normal Form 224
- Boyce Codd Normal Form 228
- Lossless Join Decomposition 233
- Security Issues and Threats to Databases 238
- Security Mechanisms 242
- The Role of the Database Administrator 246
- Discretionary Access Control 250
- Backing Up and Restoring a Database 254
- Views: Creating, Selecting and Dropping 258
- Altering, Renaming and Updating Through a View 262
- Creating and Dropping Users 267
- Granting and Revoking Privileges 271
- Transactions: COMMIT and ROLLBACK 275
- Indexes, and the Part They Play in a Fast Search 279
Module P Computer Science Practical 1: the ten practicals set on this subject
- Practical: Setting Up MySQL and Keeping the Journal 284
- Practical 1: Conceptual Design With an ER Diagram 288
Contents continued
Module P continued Computer Science Practical 1: the ten practicals set on this subject
- Practical 2: Database Management Operations and CRUD 292
- Practical 3: Table Management, Backup and Restore 295
- Practical 4: Simple Queries and Aggregate Functions 298
- Practical 5: Date, String and Math Functions 300
- Practical 6: Inner and Outer Join Queries 303
- Practical 7: Subqueries With IN and EXISTS 306
- Practical 8: ER Model to Relational Model, and Normalization 309
- Practical 9: Views With and Without the Check Option 313
- Practical 10: DCL Statements, COMMIT and ROLLBACK 316
Page 1 onwards
319 pages in this book. The cover and the contents are above. Everything from page one is in the pass.
- Notes
- 2026 Edition, as per the latest syllabus. 319 pages.
Every chapter in the notes: 81 chapters across 3 modules
Module I Introduction to DBMS, data models, the ER model and ER to table, DDL and DML statements 38 chapters
- 1 What a Database Is, and What a DBMS Does pages 1–5
- 2 Why Not Just Files: the Advantages of a DBMS pages 6–9
- 3 The Three Levels of Abstraction pages 10–13
- 4 Data Independence pages 14–17
- 5 The Architecture of a DBMS pages 18–21
- 6 What a Data Model Is pages 22–25
- 7 Client/Server Architecture pages 26–29
- 8 Object Based Logical Models pages 30–33
- 9 Record Based Logical Models: Relational, Hierarchical and Network pages 34–37
- 10 The Entity Relationship Model: Entities, Attributes and Entity Sets pages 38–41
- 11 Relationships and Relationship Sets pages 42–45
- 12 Key Constraints and the Cardinality of a Relationship pages 46–49
- 13 Participation Constraints pages 50–53
- 14 Weak Entity Sets pages 54–57
- 15 Generalization, Specialization and Aggregation pages 58–61
- 16 Conceptual Design: Entity or Attribute pages 62–65
- 17 Conceptual Design: Entity or Relationship pages 66–69
- 18 Conceptual Design: Binary or Ternary pages 70–72
- 19 Constraints Beyond the ER Model pages 73–76
- 20 Turning an Entity Set Into a Table pages 77–80
- 21 Turning a Relationship Set Into Tables pages 81–84
- 22 Meeting MySQL: the Server, the Client and Your First Database pages 85–88
- 23 Data Types pages 89–93
- 24 Creating a Table pages 94–97
- 25 Integrity Constraints: PRIMARY KEY, NOT NULL, DEFAULT and CHECK pages 98–101
- 26 Altering a Table pages 102–105
- 27 Renaming, Dropping and Truncating Tables pages 106–108
- 28 Viewing the Structure of a Table pages 109–111
- 29 INSERT: Putting Rows In pages 112–115
- 30 UPDATE and DELETE: Changing and Removing Rows pages 116–119
- 31 SELECT: All Columns and Named Columns pages 120–123
- 32 DISTINCT: Unique Records pages 124–126
- 33 The WHERE Clause pages 127–130
- 34 IN and BETWEEN pages 131–134
- 35 ORDER BY and LIMIT pages 135–138
- 36 Aggregate Functions: COUNT, MIN, MAX, AVG and SUM pages 139–141
- 37 GROUP BY pages 142–145
- 38 HAVING pages 146–149
Module II The relational data model, functions, joins and subqueries, normal forms, database protection, views and DCL 32 chapters
- 39 The Relational Data Model: Domains, Attributes, Tuples and Relations pages 150–153
- 40 Relational Model Notation pages 154–156
- 41 Characteristics of Relations pages 157–160
- 42 Relational Constraints: the Primary Key pages 161–164
- 43 Referential Integrity and the Foreign Key pages 165–169
- 44 UNIQUE, NOT NULL and CHECK Constraints pages 170–173
- 45 String Functions pages 174–177
- 46 Math Functions pages 178–180
- 47 Date and Time Functions pages 181–184
- 48 The Inner Join pages 185–189
- 49 The Outer Joins, and What MySQL Does About FULL OUTER pages 190–194
- 50 Subqueries with IN and EXISTS pages 195–198
- 51 Nested Subqueries, and What a Subquery May Not Do pages 199–202
- 52 ANY and ALL pages 203–206
- 53 Correlated Subqueries pages 207–210
- 54 Functional Dependencies pages 211–215
- 55 First Normal Form pages 216–219
- 56 Second Normal Form pages 220–223
- 57 Third Normal Form pages 224–227
- 58 Boyce Codd Normal Form pages 228–232
- 59 Lossless Join Decomposition pages 233–237
- 60 Security Issues and Threats to Databases pages 238–241
- 61 Security Mechanisms pages 242–245
- 62 The Role of the Database Administrator pages 246–249
- 63 Discretionary Access Control pages 250–253
- 64 Backing Up and Restoring a Database pages 254–257
- 65 Views: Creating, Selecting and Dropping pages 258–261
- 66 Altering, Renaming and Updating Through a View pages 262–266
- 67 Creating and Dropping Users pages 267–270
- 68 Granting and Revoking Privileges pages 271–274
- 69 Transactions: COMMIT and ROLLBACK pages 275–278
- 70 Indexes, and the Part They Play in a Fast Search pages 279–283
Module P Computer Science Practical 1: the ten practicals set on this subject 11 chapters
- 71 Practical: Setting Up MySQL and Keeping the Journal pages 284–287
- 72 Practical 1: Conceptual Design With an ER Diagram pages 288–291
- 73 Practical 2: Database Management Operations and CRUD pages 292–294
- 74 Practical 3: Table Management, Backup and Restore pages 295–297
- 75 Practical 4: Simple Queries and Aggregate Functions pages 298–299
- 76 Practical 5: Date, String and Math Functions pages 300–302
- 77 Practical 6: Inner and Outer Join Queries pages 303–305
- 78 Practical 7: Subqueries With IN and EXISTS pages 306–308
- 79 Practical 8: ER Model to Relational Model, and Normalization pages 309–312
- 80 Practical 9: Views With and Without the Check Option pages 313–315
- 81 Practical 10: DCL Statements, COMMIT and ROLLBACK pages 316–319
-
Computer Science Practical 1
Official Notes munotes.in
Computer Science Practical 1
B.SC. (COMPUTER SCIENCE) · SEMESTER 1
Strictly as per the University of Mumbai NEP syllabus in force for B.Sc. (Computer Science)
For B.Sc. (Computer Science) students of the University of Mumbai and all its affiliated colleges
munotes.in First Year
Computer Science Practical 1
Copyright © 2026 munotes.in. All rights reserved.
Written and first published by munotes.in, 2026.
This book is free for individual students to read at munotes.in. No part of it may be reproduced, distributed, stored, translated or used for institutional or classroom purposes in any form without a prior written licence from munotes.in.
Licensing and permissions: contact@munotes.in
The text of statutes and of judgments reproduced in this book is in the public domain under section 52(1)(q) of the Copyright Act 1957. The commentary, arrangement, examples and questions are the original work of munotes.in.
munotes.in is an independent study resource for MU students. It is not affiliated with, endorsed by, or officially connected to the University of Mumbai. Course names and university references describe the students and syllabus the material relates to.
Contents
Module I Digital Systems and Architecture: ten exercises in Logisim
- How This Practical Is Examined: the Journal, the Write-Up and the Viva 1
- Logisim from Zero: Installing It and Your First Circuit 6
- Practical 1: Verifying the Truth Tables of the Logic Gates 11
- Practical 2: Simplifying a Boolean Expression and Realising It 15
- Practical 3: The Half Adder and the Full Adder 19
- Practical 4: The Half Subtractor and the Full Subtractor 24
- Practical 5: The 4-Bit Magnitude Comparator 28
- Practical 6: D and JK Flip-Flops Built from Gates 32
- Practical 7: Verifying the Operation of a Counter 37
- Practical 8: The 4-Bit Shift Register 42
- Practical 9: Realising Expressions with Multiplexers and Demultiplexers 46
- Practical 10: A 3-Bit Binary Ripple Counter from JK Flip-Flops 51
Module II Fundamentals of Database Systems: ten exercises in MySQL
- MySQL from Zero: Installing It, Connecting and Saving Your Work 55
- Practical 11: Conceptual Design with an ER Diagram 60
- Practical 12: Databases, Tables, Constraints and CRUD 65
- Practical 13: ALTER, DROP, TRUNCATE, RENAME, and Backup and Restore 71
Contents continued
Module II continued Fundamentals of Database Systems: ten exercises in MySQL
- Practical 14: Simple Queries and the Aggregate Functions 76
- Practical 15: Date, String and Mathematical Functions 81
- Practical 16: Inner and Outer Joins 86
- Practical 17: Subqueries with IN and EXISTS 92
- Practical 18: From ER Model to Tables, and Normalising to 3NF 97
- Practical 19: Views, With and Without CHECK OPTION 103
- Practical 20: GRANT, REVOKE, COMMIT and ROLLBACK 108
Page 1 onwards
113 pages in this book. The cover and the contents are above. Everything from page one is in the pass.
- Notes
- 2026 Edition, as per the latest syllabus. 113 pages.
Every chapter in the notes: 23 chapters across 2 modules
Module I Digital Systems and Architecture: ten exercises in Logisim 12 chapters
- 1 How This Practical Is Examined: the Journal, the Write-Up and the Viva pages 1–5
- 2 Logisim from Zero: Installing It and Your First Circuit pages 6–10
- 3 Practical 1: Verifying the Truth Tables of the Logic Gates pages 11–14
- 4 Practical 2: Simplifying a Boolean Expression and Realising It pages 15–18
- 5 Practical 3: The Half Adder and the Full Adder pages 19–23
- 6 Practical 4: The Half Subtractor and the Full Subtractor pages 24–27
- 7 Practical 5: The 4-Bit Magnitude Comparator pages 28–31
- 8 Practical 6: D and JK Flip-Flops Built from Gates pages 32–36
- 9 Practical 7: Verifying the Operation of a Counter pages 37–41
- 10 Practical 8: The 4-Bit Shift Register pages 42–45
- 11 Practical 9: Realising Expressions with Multiplexers and Demultiplexers pages 46–50
- 12 Practical 10: A 3-Bit Binary Ripple Counter from JK Flip-Flops pages 51–54
Module II Fundamentals of Database Systems: ten exercises in MySQL 11 chapters
- 13 MySQL from Zero: Installing It, Connecting and Saving Your Work pages 55–59
- 14 Practical 11: Conceptual Design with an ER Diagram pages 60–64
- 15 Practical 12: Databases, Tables, Constraints and CRUD pages 65–70
- 16 Practical 13: ALTER, DROP, TRUNCATE, RENAME, and Backup and Restore pages 71–75
- 17 Practical 14: Simple Queries and the Aggregate Functions pages 76–80
- 18 Practical 15: Date, String and Mathematical Functions pages 81–85
- 19 Practical 16: Inner and Outer Joins pages 86–91
- 20 Practical 17: Subqueries with IN and EXISTS pages 92–96
- 21 Practical 18: From ER Model to Tables, and Normalising to 3NF pages 97–102
- 22 Practical 19: Views, With and Without CHECK OPTION pages 103–107
- 23 Practical 20: GRANT, REVOKE, COMMIT and ROLLBACK pages 108–113
Questions
Can I download it?
No, and that is deliberate. Everything is read on the site, on any device you sign in on. There is nothing to lose, and nothing to forward.
How long do I keep it?
365 days from the day you pay.
What if the syllabus changes?
Revisions are written into the same subject, and you keep reading the current version for as long as your access runs.
Can I buy one subject instead of the whole semester?
Not yet. It is sold per semester, one price for the notes of all six subjects.
Is this enough to pass?
It covers the prescribed syllabus. It is not a substitute for your lectures or your textbooks, and we would not claim otherwise.
Can I get a refund?
Once a semester is unlocked it stays unlocked, and there is no way to hand back reading you have already done. That is why this page shows you so much before you pay: the cover of every subject, every chapter in it by name, and the page each one starts on. Read that first and buy only if it is the book you want. If something genuinely went wrong, being charged twice or paying and having nothing unlock, write to us and we refund it: the cancellation and refund policy sets out which cases those are.
Does it renew automatically?
No. It is one payment for one semester. Nothing is charged again unless you choose to buy another semester yourself.
Where our readers study
Students from 169 colleges affiliated to the University of Mumbai read munotes. Here are some of them.