BSC-IT Sem 2
The Second semester of your exam is the SEM 2 of FirstYear.
Every Year there are two semesters.
Every Year there are two semesters.
SEM 2 contains following Subjects
1. Web Designing & programming (WD OR WP) 2. Applied Mathematics -2 (AM-2) 3. Microprocessor & controller (MPMC) 4.Database Management System (DBMS) 5. Data Communication & Networking
STANDARDS (DCN)
STANDARDS (DCN)
WD oR WP
INTRODUCTION TO WEB DESIGNING JAVASCRIPT & XML
Html Includes Various Html Tags-standalone and container tags.Frames,Forms,Table ,Image ,Image mapping and Other Concepts and Css Includes Inline,Internal and External Css and also Class and Id selectors of Css.
JAVASCRIPT :
Javascript is a Scripting Language.
It is a client side scripting language.
It is Used with Web browsers to interact with the users,control the browser,communicate Asynchronously.Javascript is the Most Popular Scripting language for website developing..
XML :
XML (extensible Markup Language) is a meta-language; that is, it is a language in which other languages are created.
It a language used to store data.. In XML, data is "marked up" with tags, similar to HTML tags..XML was designed to describe data. XML is used to store data or information..Xml includes DTD ,Schemas ,etc
PHP & MYSQL :
PHP stands for PHP Preprocessor HyPertext.
It is a server-side scripting language, like ASP.
All PHP scripts are executed on the server. It supports many databases (MySQL, Informix, Oracle, Sybase, Solid,PostgreSQL, Generic ODBC, etc.). It is open source software.PHP runs on different platforms (i.e., Windows, LINUX, UNIX,etc.) and is compatible with almost all servers used today including APACHE, IIS, etc. MySQL is a free to download and use database server that is ideal for both small and large applications. It supports standard SQL and compiles on a number of platforms.
Html Includes Various Html Tags-standalone and container tags.Frames,Forms,Table ,Image ,Image mapping and Other Concepts and Css Includes Inline,Internal and External Css and also Class and Id selectors of Css.
JAVASCRIPT :
Javascript is a Scripting Language.
It is a client side scripting language.
It is Used with Web browsers to interact with the users,control the browser,communicate Asynchronously.Javascript is the Most Popular Scripting language for website developing..
XML :
XML (extensible Markup Language) is a meta-language; that is, it is a language in which other languages are created.
It a language used to store data.. In XML, data is "marked up" with tags, similar to HTML tags..XML was designed to describe data. XML is used to store data or information..Xml includes DTD ,Schemas ,etc
PHP & MYSQL :
PHP stands for PHP Preprocessor HyPertext.
It is a server-side scripting language, like ASP.
All PHP scripts are executed on the server. It supports many databases (MySQL, Informix, Oracle, Sybase, Solid,PostgreSQL, Generic ODBC, etc.). It is open source software.PHP runs on different platforms (i.e., Windows, LINUX, UNIX,etc.) and is compatible with almost all servers used today including APACHE, IIS, etc. MySQL is a free to download and use database server that is ideal for both small and large applications. It supports standard SQL and compiles on a number of platforms.
DOWNLOAD NOTES TO STUDY
1_css_complete_reference.pdf | |
File Size: | 284 kb |
File Type: |
2_html_complete_reference.pdf | |
File Size: | 73 kb |
File Type: |
3_html_important_codes.pdf | |
File Size: | 50 kb |
File Type: |
4_html_lessons_learning_from_start.pdf | |
File Size: | 1432 kb |
File Type: |
5_introduction_to_xml.ppt | |
File Size: | 390 kb |
File Type: | ppt |
6_javascript_beginning.pdf | |
File Size: | 1004 kb |
File Type: |
7_php_learning.pdf | |
File Size: | 766 kb |
File Type: |
8_web_prgm.pdf | |
File Size: | 3402 kb |
File Type: |
9_xml_oriel.pdf | |
File Size: | 356 kb |
File Type: |
wt.zip | |
File Size: | 2409 kb |
File Type: | zip |
am -2
INTRODUCTION TO APPLIED MATHEMATICS 2
Applied Mathematics-2
Includes Higher Order Of Derivatives And Integrations Like double and triple Integrations and It Applications.
It Includes Complex Numbers And Complex Variables and Calculus,Fourrier Series and Laplace Transforms and Inverse Laplace Transforms
Reference Books:
1. Differential Calculus by Shanti Narayan.
2. B. S. Grewal, “Higher Engineering Mathematics.
3. Engineering Mathematics : T Veerajan, Tata McGraw-Hill
4. Integral Transforms: A. R. Vasishta, Dr. R.K. Gupta, Krishna Prakashan Mandir.
Practicals:
Practical Exam is Conducted before the Semester 1 Examination. It Includes Any 2-3 Units Of the Portion.
Applied Mathematics-2
Includes Higher Order Of Derivatives And Integrations Like double and triple Integrations and It Applications.
It Includes Complex Numbers And Complex Variables and Calculus,Fourrier Series and Laplace Transforms and Inverse Laplace Transforms
Reference Books:
1. Differential Calculus by Shanti Narayan.
2. B. S. Grewal, “Higher Engineering Mathematics.
3. Engineering Mathematics : T Veerajan, Tata McGraw-Hill
4. Integral Transforms: A. R. Vasishta, Dr. R.K. Gupta, Krishna Prakashan Mandir.
Practicals:
Practical Exam is Conducted before the Semester 1 Examination. It Includes Any 2-3 Units Of the Portion.
DOWNLOAD NOTES TO STUDY
MPMC
INTRODUCTION TO MICROPROCESSOR AND MICRO-CONTROLLER
In This Subjects Students will Learn about Microprocessor 8085 which is made by Intel and also Microcontroller 8051 and about Programming of 8085 Microprocessor and 8051 microprocontroller programming.
Microprocessor Doesnt have Ram,Rom and other peripherals on the chip while microcontroller has Ra.Rom and Other Peripherals on the chip.
Reference Books:
1. Microprocessor Architecture and Programming and Applications with the 8085, R.S. Gaonkar,
PRI (3rd Edition)
2. The 8051 Microcontroller and Embedded systems by M. A. Mazidi, J. G. Mazidi and R. D.
McKinlay, Pearson Education.
3. William Stallings, “Computer Organisation and Architecture” ( 4th Edition ) - PHI, 1998.
Practicals:
8085 Programs
1. Simple 8-bit and 16-bit addition and subtraction
2. Transfer a block of data from one location to another.
3. Find the largest/smallest of the numbers stored at one location.
4. Addition of 10 numbers.
5. Multiplication of 8-bit and 16-bit numbers.
6. Sorting of numbers.
7. BCD addition
8. Division
9. Find GCD and LCM of two numbers
10.Swapping a block of data
8051 Programs
1. To search a number from a given set of numbers. The end of the data is indicated by 00.
2. Finding the average of signed numbers.
3. Multiplication of signed numbers.
4. Convert the BCD 0111 0101 number to two binary numbers and transfer this number to registers.
5. To find y where y = x2 + 2x + 5 and x is between 0 and 9.
6. Write a program to show the use of the BIT directive.
7. Write a program to find the number of zeros in register R2
8. Write a program to check if the accumulator is divisible by 8.
9. To check whether a character string is a palindrome or not.
10.To check the number is prime or not.
In This Subjects Students will Learn about Microprocessor 8085 which is made by Intel and also Microcontroller 8051 and about Programming of 8085 Microprocessor and 8051 microprocontroller programming.
Microprocessor Doesnt have Ram,Rom and other peripherals on the chip while microcontroller has Ra.Rom and Other Peripherals on the chip.
Reference Books:
1. Microprocessor Architecture and Programming and Applications with the 8085, R.S. Gaonkar,
PRI (3rd Edition)
2. The 8051 Microcontroller and Embedded systems by M. A. Mazidi, J. G. Mazidi and R. D.
McKinlay, Pearson Education.
3. William Stallings, “Computer Organisation and Architecture” ( 4th Edition ) - PHI, 1998.
Practicals:
8085 Programs
1. Simple 8-bit and 16-bit addition and subtraction
2. Transfer a block of data from one location to another.
3. Find the largest/smallest of the numbers stored at one location.
4. Addition of 10 numbers.
5. Multiplication of 8-bit and 16-bit numbers.
6. Sorting of numbers.
7. BCD addition
8. Division
9. Find GCD and LCM of two numbers
10.Swapping a block of data
8051 Programs
1. To search a number from a given set of numbers. The end of the data is indicated by 00.
2. Finding the average of signed numbers.
3. Multiplication of signed numbers.
4. Convert the BCD 0111 0101 number to two binary numbers and transfer this number to registers.
5. To find y where y = x2 + 2x + 5 and x is between 0 and 9.
6. Write a program to show the use of the BIT directive.
7. Write a program to find the number of zeros in register R2
8. Write a program to check if the accumulator is divisible by 8.
9. To check whether a character string is a palindrome or not.
10.To check the number is prime or not.
DOWNLOAD NOTES TO STUDY
DBMS
INTRODUCTION TO DATABASE MANAGEMENT SYSTEM
DBMS Subject Includes Knowledge About Working of a Database Management System and Several Types of database.
Also the How to Databases Are Created By Data Models .. Sql is Structured Query Language which is used to manipulate,add,delete data from the Databases..
Reference Books:
1. A Silberschatz, H Korth, S Sudarshan, “Database System and Concepts”, Sixth Edition
2. Database Management Systems Book By Vipul Prakashan For Bsc-IT
Practicals:
1.Design a Database and create required tables. For e.g. Bank, College Database
2. Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables.
3. Write a sql statement for implementing ALTER,UPDATE and DELETE
4. Write the queries to implement the joins
5. Write the query for implementing the following functions:
MAX(),MIN(),AVG(),COUNT()
6. Write the query to implement the concept of Intergrity constrains
7. Write the query to create the views
8. Perform the queries for triggers
9. Perform the following operation for demonstrating the insertion , updation and
deletion using the referential integrity constraints
10. Write the query for creating the users and their role.
DBMS Subject Includes Knowledge About Working of a Database Management System and Several Types of database.
Also the How to Databases Are Created By Data Models .. Sql is Structured Query Language which is used to manipulate,add,delete data from the Databases..
Reference Books:
1. A Silberschatz, H Korth, S Sudarshan, “Database System and Concepts”, Sixth Edition
2. Database Management Systems Book By Vipul Prakashan For Bsc-IT
Practicals:
1.Design a Database and create required tables. For e.g. Bank, College Database
2. Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables.
3. Write a sql statement for implementing ALTER,UPDATE and DELETE
4. Write the queries to implement the joins
5. Write the query for implementing the following functions:
MAX(),MIN(),AVG(),COUNT()
6. Write the query to implement the concept of Intergrity constrains
7. Write the query to create the views
8. Perform the queries for triggers
9. Perform the following operation for demonstrating the insertion , updation and
deletion using the referential integrity constraints
10. Write the query for creating the users and their role.
DOWNLOAD NOTES TO STUDY
DCN
INTRODUCTION TO DATA COMMUNICATION AND NETWORK STANDARDS
Data Communication and Network Standards Includes Communication Between Networks ,Information About Networking Devices and their working..Network Topologies,Network Types,Different Devices Like Routers,Modems,Switches,Bridge,etc and their working.
Different Types of Addresses Like phsical,Logical,Special...and The working of Ipv4 and ipv6...
Reference:
1. Behrouz A Forouzan, “Data communications and Networking”, Fourth Edition , Mc-Graw Hill
2. Achyut Godbole, “Data communications and Networks, TMH
3. Data Communication and Network Standards Book By Vipul Prakhashan
Practicals/Case Study's :
Students Are Required to Give Presentation on Case Study Topics Given To Them..Some of the Topics are Listed Below -
i) Case study on implementation of TCP/IP model in different OS
ii) Case study on errors in data transmission
iii) Case study on transmission media
iv) Case study on static IP addressing
v) Case study on dynamic IP addressing
vi) Case study on network devices: Routers, Switches, Bridges
vii) Case study on IPv6
viii) Case study on IPv4
Data Communication and Network Standards Includes Communication Between Networks ,Information About Networking Devices and their working..Network Topologies,Network Types,Different Devices Like Routers,Modems,Switches,Bridge,etc and their working.
Different Types of Addresses Like phsical,Logical,Special...and The working of Ipv4 and ipv6...
Reference:
1. Behrouz A Forouzan, “Data communications and Networking”, Fourth Edition , Mc-Graw Hill
2. Achyut Godbole, “Data communications and Networks, TMH
3. Data Communication and Network Standards Book By Vipul Prakhashan
Practicals/Case Study's :
Students Are Required to Give Presentation on Case Study Topics Given To Them..Some of the Topics are Listed Below -
i) Case study on implementation of TCP/IP model in different OS
ii) Case study on errors in data transmission
iii) Case study on transmission media
iv) Case study on static IP addressing
v) Case study on dynamic IP addressing
vi) Case study on network devices: Routers, Switches, Bridges
vii) Case study on IPv6
viii) Case study on IPv4
DOWNLOAD NOTES TO STUDY
NOTE : THE CONTENT WHICH I ADDED TO MY SITE I GOT IT FROM DIFFERENT SITES AND IT IS CREDITED TO THEM. I AM JUST SHARING FOR THE EDUCATIONAL PURPOSE.