In December 2011, Tata Institute of Social Sciences set up the School of Vocational Education (SVE) to provide immediate and definite interventions to improve the lives of the disadvantaged and marginalized youth, especially who are excluded by the formal school education system, through appropriate vocational training programmes. It has been set up with a vision of creating an ecosystem that would bring back the dignity of labour for blue collar streams of work and create sustainable sources of income. This project has been initiated under the aegis of All India Council for Technical Education (AICTE) proposed by the Ministry of HRD, Government of India.
1.1Introduction and Course Objectives:
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views and other objects. A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.
Database management systems are often classified according to the database model that they support; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language
This course is intended to provide you with an understanding of practice of database management systems. The course provides a solid technical overview of database management systems. In addition to technical concerns, more general issues are emphasized. These include data independence, integrity, security, recovery, performance, database design principles, and database administration.
1.2. Eligibility for Admission
The candidate should pass 10+2 in any discipline
1.3. Employability/Skill enhancement
Students successfully completing this course should be able to:
- Understand Fundamentals of Computer including software, hardware and key concepts of Network & Internet.
- Understand the different issues involved in the design and implementation of a database system.
- Understand the physical and logical database designs, database modeling, relational, hierarchical, and network models
- Understand and use data manipulation language to query, update, and manage a database
- Understand essential DBMS concepts such as: database security, integrity, concurrency, distributed database, and intelligent database, Client/Server (Database Server), Data Warehousing.
- Design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS.
Method of Assessment & Weightage:
The assessment of students would be done in written and practical examination
1. Assessment Weightage:
- Written – 50%
- Practical examination – 50%
2. Course Structure
Duration of Course – 2 Months
Credits for course – 6 Credits
Duration of Course – 120 Hours [For Theory (classroom) courses, 1 credit = 15 hours
For Practical training, 1 credit = 30 hours]
|Sr. No.||Subject||Credits||Duration Hrs.|
|1.||IT Foundations & Programming Concepts||2||30|
|2.||Database Management Systems||2||30|
IT Foundations & Programming Concepts
- To create overall generic awareness about scope of the field of IT and to impart basic personal computing skills.
- To create background knowledge for the various courses in the programme.
- To introduce the basic terminology in the field of IT
- To impart functional knowledge about PC hardware, operations and concepts
- To impart functional knowledge about networks and internet.
- To give an overview of computer application in various fields and an overall generic awareness about the scope of the field of IT
- To give an overview about problem solving steps, Develop algorithm for different problems, Draw flow chart, Analyse algorithms
Computer characteristics: Speed, storage, accuracy, diligence; Digital signals, Binary System, ASCII; Historic Evolution of Computers; Classification of computers: Microcomputer, Minicomputer, mainframes, Supercomputers; Personal computers: Desktop, Laptops, Palmtop, Tablet; Hardware & Software; Von Neumann model.
Hardware: CPU, Memory, Input devices, output devices. Memory units: RAM (SDRAM, DDR RAM, RDRAM etc. feature wise comparison only); ROM-different types: Flash memory; Auxiliary storage: Magnetic devices, Optical Devices; Floppy, Hard disk, Memory stick, CD, DVD, CD/DVD-Writer; Input devices – keyboard, mouse, scanner, speech input devices, digital camera, Touch screen Voice Input, Joystick, Optical readers, bar code reader; Output devices: Display device, size and resolution; CRT, LCD, LED; Printers: Dot-matrix, Inkjet, Laser; Plotters, Sound cards & speaker.
Software- System software, Application software; concepts of files and folders, Introduction to Operating systems, Different types of operating systems: single user, multitasking, time-sharing multi-user; Booting, POST; Basic features of two GUI operating systems: Windows & Linux (Basic desk top management); Programming Languages, Compiler, Interpreter, Databases; Application software: Generic Features of Word processors, Spread sheets and Presentation software; Generic Introduction to Latex for scientific typesetting; Utilities and their use; Computer Viruses & Protection, Free software, open source.
Computer Networks and Internet- Connecting computers, Requirements for a network: Server, Workstation, switch, router, network operating systems; Internet: brief history, World Wide Web, Websites, URL, browsers, search engines, search tips; Internet connections: ISP, Dial-up, cable modem, WLL, DSL, leased line Wireless and Wi-Fi connectivity ; email, email software features (send receive, filter, attach, forward, copy, blind copy); characteristics of web-based systems, Web pages, Web Programming Languages.
Information Technology And Society – Indian IT Act, Intellectual Property Rights, issues. Application of information Technology in Railways, Airlines, Banking, Insurance, Inventory Control, Financial systems, Hotel management, Education, Video games, Telephone exchanges, Mobile phones, Information kiosks, special effects in Movies.
Programming Concepts & Techniques – Program Concept, Characteristics of Programme, Stages in Program Development, Tips for Program Designing, Programming Aids, Algorithms, Pseudo code, Notations, Design, Flowcharts, Symbols, Rules, compiler & Interpreter. Introduction to programming techniques, Top-down & Bottom-up approach, Unstructured, & Modular programming, Cohesion, Coupling, Debugging, Syntax & Logical Errors, Linking and Loading, Testing and Debugging, Documentation
- Balaguruswamy, Fundamentals of Computers, McGraw Hill, 2014
- Dennis P Curtain, Information Technology: The Breaking wave, McGrawhill, 2014
- Peter Norton, Introduction to Computers, McGrawhill, Seventh edition
Database Management Systems
- To create generic awareness about general concepts of database management systems.
- To background knowledge for the oracle and SQL & PL/SQL.
- To introduce the basics of database in programming.
- To impart functional knowledge about data models and keys.
- To impart functional knowledge about MS access
Operational data, Purpose of database system, Views of data, Data models: Relational, Network, Hierarchical, Instances & Schemes, Data Dictionary, Types of Database languages : DDL, DML, Entity Relationship Model as a tool of conceptual design : Entities & Entity set, Relationship & Relationship set, Attributes, Mapping Constraints, Keys, Entity-Relationship diagram (E-R diagram) : Strong & weak entities, Generalization, Specialization, Aggregation, Reducing ER diagram to tables
Concepts of Keys : Candidate key, Primary Key, Alternate Key, Super Key, Foreign Key, Fundamental integrity rules : Entity integrity, Referential integrity.
Different types of joins i.e. theta join, equi join, natural join, outer join, set operations .Structured query language(SQL), Codd’s rules,
Functional Dependencies, Good & Bad Decomposition, Anomalies as a database : A consequences of bad design, Universal Relation, Normalization : First, Second, Third & BCNF Normal Forms, Multivalues Dependency, Join Dependency & forth Fifth Normal Form
Popular RDBMS available in the market, Introduction to MS Access, Creating Databases using MS Access, Creating and Using Tables in MS Access, Modifying tables in Access, Query in MS Access, Creating and using reports in MS Access, Printing Reports in MS Access, Importing and exporting in MS Access,
Oracle introduction, Client and server communication (SQL) Data Definition Language (DDL) – Creating, Altering & Dropping Tables, Oracle Data Types, Integrity Constant, Data Manipulation Language (DML) – Select Insert, Update, Delete Commands, Sorting in oracle, Joins in Oracle-Inner,Outer, Cartesian, Self-join, Non-equi joins, Transaction Control Using ,SQL – Commit, Rollback, Savepoint Command, Data Controlling Using SQL – Grant, Revoke, Set Role, SQL functions,Indexes and views
PL/SQL, SQL & PL/SQL, Differences, Blocking Code for Clarity, Using Variables, Constant and Data Types, Assigning Data Base Values to Variables, Select Into ….. Cursors using Flow Control and Loop Statements, Goto Statement. Error handling built in PL / SQL Exceptions, User – Defined Exceptions, Unhandled
Exception, the Raise – Application – Error Procedure. PL / SQL Programs Anonymous PL / SQL Blocks, Stored Procedure,
Function & Packages, Using Database Triggers.
TEXT & REFERENCE BOOKS:
- “DATABASE MANAGEMENT SYSTEM” by Leon & Leon, Vikas Publications
- Oracle Database 12c- Hands on SQL and PL/SQL by Ashis Asnani, PHI
- “AN INTRODUCTION TO DATABASE SYSTEM” by Bipin C.Desai
- “Database Management and Oracle Programming” 2nd Edition By S. S. Khandare , S. Chand Publisher
- “Oracle A Beginners Guide” by Michael Abbey & Michael J. Corey TMH Publications
Trainer at the HUB location is suppose to guide the students for the Practical related to Database Management and Structured Query Language.