Prepare for your exams
Get points
Guidelines and tips

Prepare for your exams

Study with the several resources on Docsity

Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips

Sell on Docsity

Log in Sign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents

20 Points

For each uploaded document

Answer questions

5 Points

For each given answer (max 1 per day)

All the ways to get free points

Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study

Go to the blog

Data programming science, Cheat Sheet of Database Programming

Thiruvalluvar University Database Programming

Data processing easy way this o

Typology: Cheat Sheet

2022/2023

Uploaded on 04/20/2023

steeve-jerry 🇮🇳

1 document

1 / 65

This page cannot be seen from the preview

Don't miss anything!

THIRUVALLUVARUNIVERSITY

B.Sc. COMPUTER SCIENCE

CBCS PATTERN

(With effect from 2020-2021)

S. No.

Part

Study Components Ins. Hrs

/ week

Credit

Title of the Paper Maximum Marks

Course Title

SEMESTER I CIA

Uni.

Exam

Total

1. I Language Paper-1 6 4 Tamil/Other Languages

25 75 100

2.

II

English (CE) Paper-1 6 4 Communicative English I

25 75 100

3.

III

Core Theory Paper-1 6 4 Programming in C

25 75 100

4.

III

Core Practical Practical-1 3 2 Programming in C Lab 25 75 100

5.

III

Allied -1 Paper-1 7 3

(to choose any one)

1. Mathematics I

2. Mathematical

Foundations I

25 75 100

6.

III

PE Paper 1 6 3 Professional English I

25 75 100

7.

IV

Environmental

Studies 2 2 Environmental studies

25 75 100

Sem. Total 36 22 175 525 700

SEMESTER II CIA

Uni.

Exam

Total

8. I Language Paper-2 6 4 Tamil/Other Languages

25 75 100

9.

II

English (CE) Paper-2 6 4 Communicative English II

25 75 100

10.

III

Core Theory Paper-2 5 4 C++ & Data Structure

25 75 100

11.

III

Core Practical Practical-2 2 2 C++ and Data Structures

Lab

25 75 100

12.

III

Allied-1 Paper-2 7 5

(to choose any one)

1. Mathematics II

2. Mathematical

Foundations II

25 75 100

13.

III PE Paper 1 6 3 Professional English II

25 75 100

14.

IV

Value Education 2 2 Value Education

25 75 100

15.

IV

Soft Skill 2 1 Soft Skill

25 75 100

Sem. Total 36 25 200 600 800

Partial preview of the text

Download Data programming science and more Cheat Sheet Database Programming in PDF only on Docsity!

THIRUVALLUVARUNIVERSITY

B.Sc. COMPUTER SCIENCE

CBCS PATTERN

(With effect from 2020-2021) S. No. Part Study Components (^) Ins. Hrs / week Credit Title of the Paper Maximum Marks Course Title SEMESTER I CIA Uni. Exam Total

I Language Paper-1 6 4 Tamil/Other Languages 25 75 100
II English (CE) Paper-1 6 4 Communicative English I 25 75 100
III Core Theory Paper-1 (^6 4) Programming in C 25 75 100
III Core Practical Practical-1 (^3 2) Programming in C Lab 25 75 100
III Allied -1 Paper-1 7 3 ( to choose any one)
Mathematics I
Mathematical Foundations I 25 75 100 6. III PE Paper 1 6 3 Professional English I 25 75 100
IV Environmental Studies 2 2 Environmental studies 25 75 100 Sem. Total 36 22 175 525 700 SEMESTER II CIA Uni. Exam Total
I Language Paper-2 6 4 Tamil/Other Languages 25 75 100
II English (CE) Paper-2 6 4 Communicative English II 25 75 100
III Core Theory Paper-2 (^5 4) C++ & Data Structure 25 75 100
III Core Practical Practical-2 2 2 C++ and Data Structures Lab 25 75 100
III Allied-1 Paper-2 7 5 (to choose any one)
Mathematics II
Mathematical Foundations II 25 75 100 13. III PE Paper 1 6 3 Professional English II 25 75 100
IV Value Education 2 2 Value Education 25 75 100
IV Soft Skill 2 1 Soft Skill 25 75 100 Sem. Total 36 25 200 600 800

S.NO. Part Study Components (^) Ins. hrs /week Credit Title of the Paper Maximum Marks Course Title SEMESTER III CIA Uni. Exam Total

I Language^ Paper-3 6 4 Tamil/ OtherLanguages 25 75 100
II English^ Paper-3 6 4 English 25 75 100
III (^) Core Theory Paper-3 3 3 Programming in JAVA 25 75 100
III (^) Core Practical Practical-3 3 3 Programming in JAVA Lab 25 75 100
III Allied II Paper-3 4 3 ( Choose any one)
1. Physics I
2. Statistical Methods and Their Applications I 25 75 100 III Allied II Practical 3 0 Physics/Statistics Practical 0 0 0
IV Skill Based Subject Paper-1 3 2 Digital Logic Design and Computer Organization 25 75 100
IV Non-Major Elective Paper-1 2 2 Introduction to Information Technology 25 75 100 Sem. Total (^30 21 175 525 ) SEMESTER IV CIA Uni. Exam Total
I Language^ Paper-4 6 4 Tamil/Other Languages 25 75 100
II English^ Paper-4 6 4 English 25 75 100
III (^) Core Theory Paper-4 3 3 Relational Database Management Systems 25 75 100
III (^) Core Practical Practical-4^3 3 RDBMS Lab 25 75 100
III Allied II Paper-4 4 3 (to choose any one)
Physics II
Statistical Methods and their Applications II 25 75 100
III Allied II Practical (^3 2) Physics/Statistics Practical 25 75 100
IV^ Skill Based Subject Paper-2 3 2 Wireless Data Communication 25 75 100
IV Non-Major Elective Paper-2 2 2 Internet Technology 25 75 100 Sem. Total 30 23 200 600 800

V Extension Activities 0 1 100 0 100 Sem. Total (^30 27 300 600 ) 140 4600 Part Subject Papers Credit Total Credits Marks Total Marks Part I Languages 4 4 16 100 400 Part II Communicative English & English 4 4 16 100 400 Part III Allied (Odd Semester) 2 3 6 100 200 Allied (Even Semester) 2 5 10 100 200 Allied Practical 1 100 100 Electives 3 3 9 100 300 Core 9 (3-5) 34 100 900 Core practical 8 (2-3) 21 100 800 Professional English 2 3 6 100 200 Compulsory Project (Group/Individual Project) 1 5 5 100 100 Part IV Environmental Science 1 2 2 100 100 Soft skill 1 1 1 100 100 Value Education 1 2 2 100 100 Lang. & Others /NME 2 2 4 100 200 Skill Based 4 2 8 100 400 Part V Extension Activities 1 1 1 100 100 Total 0 00 0

THIRUVALLUVARUNIVERSITY

B.Sc. COMPUTER SCIENCE

CBCS PATTERN

(With effect from 2020-2021)

SEMESTER III

CORE PAPER - 3

PROGRAMMING IN JAVA

COURSE OBJECTIVES:

 Knowing about a General-purpose and Purely object-oriented programming language including data types, control statements, and classes  Secured, well-suited for internet programming using applets and GUI-based UNIT I Declarations and Access Control: Identifiers and Keywords: Oracle‘s Java Code Conventions. Define Classes: Import Statements and the Java API - Static Import Statements. Use Interfaces: Declaring an Interface- Declaring Interface Constants. Declare Class Members: Access Modifiers

Non access Member Modifiers - Constructor Declarations - Variable Declarations. Declare and Use enums: Declaring enums. Object Orientation: Encapsulation - Inheritance and Polymorphism- Polymorphism - Overriding / Overloading: Overridden Methods -Overloaded Methods. UNIT II Object Orientation: Casting - Implementing an Interface - Legal Return Types: Return Type Declarations - Returning a Value. Constructors and Instantiation: Overloaded Constructors - Initialization Blocks. Statics: Static Variables and Methods. Assignments: Stack and Heap - Literals, Assignments, and Variables: Literal Values for All Primitive Types. Scope - Variable Initialization - Passing Variables into Methods: Passing Object Reference Variables - Passing Primitive Variables. Garbage Collection. Operators: Java Operators - Assignment Operators
Relational Operators - instanceof Comparison - Arithmetic Operators - Conditional Operator - Logical Operators. UNIT III Working with Strings, Arrays, and Array Lists: Using String and StringBuilder: The String Class - The StringBuilder Class - Important Methods in the StringBuilder Class. Using Arrays: Declaring an Array - Constructing an Array - Initializing an Array. Using ArrayList:ArrayList Methods in Action - Important Methods in the ArrayList Class. Flow Control and Exceptions: Using if and switch Statements -Creating Loops Constructs - Handling Exceptions - Catching an Exception Using try and catch - Using finally. String Processing, Data Formatting Resource Bundles: String, StringBuilder, and StringBuffer -Dates, Numbers, Currencies, and Locales.

CORE PRACTICAL - Practical-

PROGRAMMING IN JAVA LAB

List of Practical’s

Implementation of Classes and Objects
Implementation of Inheritance and Polymorphism
Implementation of Interface and Package concepts
Implementation of Flow, Border ,Grid Layouts
Implementation of Tic-Tac Toe Application Using Applets
Implementation of Frames, Menus, Dialog
Implementation of Swing concepts
Implementation of Exception Handling
Implementation of Multi Threading
Implementation of I/O Streams
Implementation of Java Networking concepts
Implementation of Java Servlets ( Connecting Database)
Implementation of RMI
Implementation of Java Beans

ALLIED - 2

PAPER -

PHYSICS I

Course Objectives

To understand the basics of gravitation and to study the properties of matter.
To learn the law of thermoelectric circuits and thermoelectric diagrams.
To teach the growth and decay of a transient current and magnetometer.
To explain production of ultrasonics and reverberation time.
To know the basics of laser and fibre optics principles and applications. UNIT-1: Properties of Matter Gravitation: Acceleration due to gravity -Determination of ‘g’ by Simple pendulum - Drawbacks of simple pendulum –Determination of time period of compound pendulum - ‘g’ by compound pendulum -Centre of Oscillation and Centre of Suspension are interchangeable-Determination of ‘g’ by Bar/compound pendulum. Elasticity: Bending of beams -Expression for bending moment - Cantilever Depression at the loaded end of a cantilever Expression forYoung's modulus -non–uniform bending-Pin and microscope method. Torsion : Torsion couple – Potential energy in a twisted wire – Torsional pendulum – Time period - Determination of rigidity modulus by Torsional oscillation (without masses). Viscosity: Viscosity of a liquid -Viscous force - Co-efficient of viscosity of a liquid – Poiseuille’s formula -Experimental method using Burette- Effect of temperature and pressure on viscosity- applications. Surface Tension: Surface tension of a liquid-Surface Tension and interfacial surface tension by the method of drops-applications. UNIT-2: Thermo Electricity Seeback, Peltier and Thomson effects - laws of thermoelectric circuits -Peltier coefficient - Thomson coefficient -application of thermodynamics to a thermocouple and expressions for Peltier and Thomson coefficients -thermo electric power and thermo electric diagrams. UNIT-3: Transient Current and Magnetism Growth and decay of current in a circuit containing resistance and inductance- Growth and decay of charge in circuit containing resistance and capacitor - growth and decay of charge in a LCR circuit – condition for the discharge to be oscillatory – frequency of oscillation. Magnetism -Magnetic moment and pole strength of a magnet – Deflection magnetometer – Tan C Position- Vibration magnetometer – Theory – Period of Oscillation – Determination of M and BH using the deflection magnetometer and the vibration magnetometer.

E-MATERIALS

https://courses.lumenlearning.com/physics/chapter/16-4-the-simple-pendulum/
https://www.youtube.com/watch?v=aw0_seEt4v
https://en.wikipedia.org/wiki/Thermoelectric_effect
https://www.youtube.com/watch?v=S0I37M2sx_
https://physicscatalyst.com/elecmagnetism/growth-and-delay-charge-R-C-circuit.php
https://www.youtube.com/watch?v=PLQQPXot6vE
https://www.youtube.com/watch?v=d0_Eff4MXwM
https://www.techglads.com/cse/sem1/production-of-ultrasonics-by-piezoelectric-methods/
https://thefactfactor.com/facts/pure_science/physics/optical-fibre/5159/
https://www.youtube.com/watch?v=auk1OS0SVWc (Tamil video) Course Objectives
After studied unit-1, the student will be able to find the acceleration due to gravity at a place using simple pendulum and compound pendulum. Also can know the properties of matter like elasticity, viscosity and surface tension.
After studied unit-2, the student will be able to learn thermo emf using Seebeck and Peltier effects and hence understand thermoelectric circuits.
After studied unit-3, the student will be able to explain growth and decay of a transient current in a circuit containing resistance-inductance, resistance-capacitance and LCR in series. Also will be able to determine the horizontal components of earth’s magnetic induction at a place using deflection magnetometer in Tan C position.
After studied unit-4, the student will be able to derive the expression for the velocity of a sound in a stretched string and hence they can determine the frequency of A.C mains.
After studied unit-5, the student will be able to understanding the principle of laser and can demonstrate the working of He-Ne laser and applications of laser. Also, the student will be able to learn the fibre optics, structure and application in communication.

ALLIED - 2

PAPER -

STATISTICAL METHODS AND THEIR APPLICATIONS XI

Objective To understand and computing statistical Methods by which to develop the programming Skills. UNIT-I Introduction - scope and limitations of statistical methods - classification of data -Tabulation of data - Diagrammatic and Graphical representation of data - Graphical determination of Quartiles ,Deciles and Percentiles. UNIT-II Measures of location : Arithmetic mean, median, mode, geometric mean and Harmonic mean and their properties. UNIT-III Measures of dispersion : Range, Quartile deviation, mean deviation, Standard deviation, combined Standard deviation, and their relative measures. UNIT-IV Measures of Skewness Karl Pearson’s, Bowley’s, and kelly’s and co-efficient of Skewness and kurtosis based on moments. UNIT-V Correlation - Karl Pearson - Spearman’s Rank correlation - concurrent deviation methods. Regression Analysis: Simple Regression Equations. Note : The proportion between theory and problems shall be 20: Books for Reference:

1. Fundamental of Mathematical Statistics - S.C. Gupta & V.K. Kapoor - Sultan Chand

2. Statistical Methods - Snedecor G.W. & Cochran W.G. oxford & +DII

3. Elements of Statistics - Mode. E.B. - Prentice Hall

4. Statistical Methods - Dr. S.P. Gupta - Sultan Chand & Sons

UNIT V- INPUT OUTPUT AND MEMORY ORGANIZATION

Objective: To understand the basic concepts of Input Output and Memory

Organization

Peripheral Devices- I/O Interface - Asynchronous Data Transfer- -Priority Interrupt –

Direct Memory Access – I/O Processor.Memory Organization– Main Memory-

Auxiliary Memory – Associative Cache and Virtual Memory.

TEXT BOOKS:

1. M. Morris Mano -Digital Logic and Computer Design- PHI.

2. M. Morris Mano, Computer System Architecture, Pearson Education.

REFERENCE BOOKS:

1 Thomas C. Bartee Digital Computer Fundamentals- McGraw HillPub.

2 Malvino& Leach- Digital Principles and Applications –McGraw HillPub.

3. S. Ramalatha - Digital Computer Fundamentals, MeenakshiAgency.

4. V. Carl Hamacher, Zvonko G. Vranesic, Safwat G. Zaky, Computer

Organization, McGraw Hill HigherEducation.

5. John P. Hayes, Computer System Architecture, McGraw Hill HigherEducation

NON-MAJOR ELECTIVE

PAPER-

Introduction to Information Technology

OBJECTIVES:

The subject aims to build the concepts regarding:  Major components of Computer System and its working principles.  Role of an Operating System and basic terminologies of networks.  How the Information Technology aids for the Current Scenario.  To understand the Computer Software.  To understand internet applications UNIT-I Introduction: Characteristics of Computers-Technological Evolution of Computers-The Computer Generations-Categories of Computer. Data and Information: Introduction-Types of Data-A Simple Model of a Computer-Data Processing Using a Computer-Desktop Computer. Acquisition of Number and Textual Data: Introduction- Input Units-Internal Representation of Numeric Data-Representation of Characters in Computers–Error-Detecting Codes. UNIT-II Data Storage: Introduction-Memory Cell-Physical Devices Used as Memory Cells-Random Access Memory-Read Only Memory- Secondary Memory- Floppy Disk Drive- Compact Disk Read Only Memory (CDROM)-Archival Memory. Central Processing Unit: The Structure of a Central Processing Unit-Specification of a CPU-Interconnection of CPU with Memory and I/O Units. UNIT-III Computer Networks: Introduction-Local Area Network (LAN)- Applications of LAN-Wide Area Network (WAN)–The Future of Internet Technology. Output Devices: Introduction- Video Display Devices-Flat Panel Displays–Printers. UNIT-IV Computer Software: Introduction-Operating System-Programming Languages–A Classification of Programming Languages. Data Organization: Introduction-Organizing a Database-Structure of a Database- Database Management System-Example of Database Design. UNIT-V Some Internet Applications: Introduction- E-mail- Information Browsing Service- The World Wide Web- Information Retrieval from the World WideWeb-Other Facilities Provided by Browsers - Audio on the Internet. Societal Impactsof Information Technology: CareersinInformation Technology. TEXTBOOKS:

Rajaraman,V. 2008_._ IntroductiontoInformationTechnology. [SixthPrinting]. PrenticeHall of India Pvt. Limited, New Delhi.(UNIT I toV)
Nagpal,D.P .2010. ComputerFundamentals .[FirstEdition,Revised].S.Chand

SEMESTER IV

Data programming science, Cheat Sheet of Database Programming

Related documents

Partial preview of the text

Download Data programming science and more Cheat Sheet Database Programming in PDF only on Docsity!

THIRUVALLUVARUNIVERSITY

B.Sc. COMPUTER SCIENCE

CBCS PATTERN

THIRUVALLUVARUNIVERSITY

B.Sc. COMPUTER SCIENCE

CBCS PATTERN

SEMESTER III

CORE PAPER - 3

PROGRAMMING IN JAVA

COURSE OBJECTIVES:

CORE PRACTICAL - Practical-

PROGRAMMING IN JAVA LAB

ALLIED - 2

PAPER -

PHYSICS I

E-MATERIALS

ALLIED - 2

PAPER -

STATISTICAL METHODS AND THEIR APPLICATIONS XI

1. Fundamental of Mathematical Statistics - S.C. Gupta & V.K. Kapoor - Sultan Chand

2. Statistical Methods - Snedecor G.W. & Cochran W.G. oxford & +DII

3. Elements of Statistics - Mode. E.B. - Prentice Hall

4. Statistical Methods - Dr. S.P. Gupta - Sultan Chand & Sons

UNIT V- INPUT OUTPUT AND MEMORY ORGANIZATION

Objective: To understand the basic concepts of Input Output and Memory

Organization

Peripheral Devices- I/O Interface - Asynchronous Data Transfer- -Priority Interrupt –

Direct Memory Access – I/O Processor.Memory Organization– Main Memory-

Auxiliary Memory – Associative Cache and Virtual Memory.

TEXT BOOKS:

1. M. Morris Mano -Digital Logic and Computer Design- PHI.

2. M. Morris Mano, Computer System Architecture, Pearson Education.

REFERENCE BOOKS:

1 Thomas C. Bartee Digital Computer Fundamentals- McGraw HillPub.

2 Malvino& Leach- Digital Principles and Applications –McGraw HillPub.

3. S. Ramalatha - Digital Computer Fundamentals, MeenakshiAgency.

4. V. Carl Hamacher, Zvonko G. Vranesic, Safwat G. Zaky, Computer

Organization, McGraw Hill HigherEducation.

5. John P. Hayes, Computer System Architecture, McGraw Hill HigherEducation

NON-MAJOR ELECTIVE

PAPER-

Introduction to Information Technology

OBJECTIVES:

CORE PAPER-

RELATIONAL DATABASE MANAGEMENT SYSTEMS

Objective:

 The students are able to understand database concepts and database

management system software and have a high-level understanding of major

DBMS components and their function.

 The students are able to understand the E R model and relational model.

 The students are able to be able to write SQL commands to create tables and

indexes, insert/update/delete data, and query data in a relational DBMS.

 The students are able to Understand Functional Dependency and Functional

Decomposition.

 The students are able to understand the architecture of database

management system and also understand the various different architecture

such as server system architecture, parallel sytems and distributed database

systems.

UNIT- I : DATABASE ARCHITECTURE AND ER DIAGRAM 12 Hours

Database system applications - Purpose of database systems - View of data-

Database languages - Database architecture - Database users and administrators -

History of database systems-Entity relationship modeling: entity types, entity set,

attribute and key, relationships, relation types, roles and structural constraints,

weak entities, enhanced E-R and object modeling, sub classes; super classes,

inheritance, specialization and generalization

UNIT- II: RELATIONAL DATA MODEL 12 Hours

Relational model concepts, Relational constraints, Relational Languages : Relational

Algebra, The Tuple Relational Calculus - The Domain Relational Calculus - SQL: Basic

Structure-Set Operations- Aggregate Functions-Null Value-Nested Sub Queries-

Views Complex QueriesModification Of Database-Joined Relations-DDL-Embedded

SQL-Dynamic SQL-Other SQL Functions- -Integrity and Security.

UNIT - III: DATA NORMALIZATION 12 Hours

Pitfalls in relational database design – Decomposition – Functional dependencies –

Normalization – First normal form – Second normal form – Third normal form –

Boyce-codd normal form – Fourth normal form – Fifth normal form.

UNIT- IV: STORAGE AND FILE ORGANIZATION 12 Hours