Syllabus
Professional Electives
Other Branches
Unit I
An Overview of the Computer System-The Parts of a Computer System, Operating System, Input, Output and storage devices, Basics of Networking – Types of Networks and Topology,Introduction to Programming using Scratch and Flowgorithm, Introduction to Object Oriented Paradigm: Abstraction, Encapsulation and Data Hiding, Classes and Objects, Methods, Inheritance and Polymorphism, Introduction to Python programming: Python data variables and operators, Control Structures, Strings, Functions – Built-in functions, User-defined functions and Recursion. Data Structures – List.
Unit II
Database fundamentals: Data and Need for DBMS, Relational Model and Keys: Data representation and keys in RDBMS, Logical database Design: ER Modeling and notations, Physical Database Design: Converting ER model to Relational Schema. Normalization- Introduction – 1NF, 2NF, 3NF.Implementation with SQL – Introduction, Data types and operators in SQL, SQL statements, Built-in Functions, Group-By and CSE clause, Joins and sub queries. Transaction Management: ACID properties.
Unit III
Introduction to Software Engineering, UML Diagrams: Object Oriented Analysis and Design, Role of UML in Object Oriented Analysis and Design, UML Building blocks: Structural Things, Behavioral, Grouping and Annotational. Relationships – Dependency, Association, generalization and Realization, UML- Class diagrams, Testing strategies
Objectives and Outcomes
Course Objectives
- This course covers the basic concepts in computer science and engineering but not limited to object-oriented programming, database design and software engineering that aids the students of non-CSE to develop applications to solve real world problems.
Course Outcomes
CO1: Understand and Apply the fundamental concepts of Computer System and Computer Programming.
CO2: Apply Object Oriented Paradigm.
CO3: Design Relational Database Management system for a scenario.
CO4: Understand and Apply Software Engineering Principles.
CO5: Apply OOAD principles, Design UML and understand Testing Tools
CO-PO Mapping
|
PO/PSO
|
PO1
|
PO2
|
PO3
|
PO4
|
PO5
|
PO6
|
PO7
|
PO8
|
PO9
|
PO10
|
PO11
|
PO12
|
PSO1
|
PSO2
|
|
CO
|
|
CO1
|
2
|
2
|
|
|
|
|
|
|
|
|
|
|
3
|
2
|
|
CO2
|
2
|
2
|
|
|
|
|
|
|
|
|
|
|
3
|
2
|
|
CO3
|
2
|
2
|
|
2
|
|
|
|
|
|
|
|
|
3
|
2
|
|
CO4
|
2
|
1
|
|
|
|
|
|
|
|
|
|
|
3
|
2
|
|
CO5
|
2
|
1
|
|
|
|
|
|
|
|
|
|
|
3
|
2
|
Evaluation Pattern
Evaluation Pattern: 70:30
|
Assessment
|
Internal
|
End Semester
|
|
MidTerm Exam
|
20
|
|
|
Continuous Assessment – Theory (*CAT)
|
10
|
|
|
Continuous Assessment – Lab (*CAL)
|
40
|
|
|
**End Semester
|
|
30 (50 Marks; 2 hours exam)
|
*CAT – Can be Quizzes, Assignments, and Reports
*CAL – Can be Lab Assessments, Project, and Report
**End Semester can be theory examination/ lab-based examination/ project presentation
Text Books / References
Textbook(s)
Electronic Resources at http://campusconnect.infosys.com/
Phillips D. “Python 3 Object Oriented Programming”. Packt Publishing Ltd; 2010.
Swaroop C H. “A Byte of Python”, ebshelf Inc; 2013.
Silberschatz A, Korth HF, Sudarshan S. “Appendix E: Hierarchical Model. Database System concepts”, 6th edn. McGraw-Hill. 2010.
Pressman RS. Software engineering: a practitioner’s approach. Palgrave Macmillan; 2014.
