Course Contents
Theory: Basic computing; Use of MS Office Package (MS Word, Excel, Access, Power Point etc.); Visio; Basic concepts in database development and management; Entity Relationship modeling, Relational data model and algebra, Structured Query language; Database design, functional dependencies and normal forms; Transaction processing and optimization concepts; concurrency control and recovery techniques; Database recovery techniques; Database security and authorization. Introduction to Statistical Package for Social Sciences (SPSS). Questionnaire coding and data preparation for analysis on computer Data entry into SPSS. Editing data values and controlling the display of data. Defining variables and selection of a procedure from the menus to calculate statistics. Re-coding of existing variables and computing of new variables. Assigning variable labels and value labels. Constructing simple frequency tables and cross-tables. Elementary Graphics; Creating statistical diagrams and charts; Editing the results display in the output navigator.
Practical: Hands-on practice in using a database system to create files, tables, forms and queries; enter and manipulate data; and generate reports. Statistical analysis survey data using SPSS and preparation of tables and cross tables and charts. Small Group Project implementing a database.
Course Learning Outcomes
To impart basic skills and techniques in information technology and its use in database development and management
SQL
View Now
MS Access 2016 - Create Simple Database
View Now
Book Title : Practical Database Management (Management Information Systems)
Author : Tony F., Robert S.
Edition : Latest Edition
Publisher : Pws Pub Co
Book Title : Computer Use In Planning and Urban Management
Author : Sikander, P.K.etal
Edition : Latest Edition
Publisher : Naosa Publishing House, New Delhi
Book Title : Database Systems
Author : C.J. Date (2004)
Edition : Latest Edition
Publisher : Addison Wesley Pub. Co
Book Title : Database Systems: A Practical Approach to Design, Implementation and Management
Author : R.Connolly and P. Begg (2003)
Edition : Latest Edition
Publisher : Addison-Wesley Pub. Co.
Book Title : “Fundamentals of Database Systems”
Author : Elmasri, R. and Navathe, S.B (2004)
Edition : Latest Edition
Publisher : Addison-Wesley Pub. Co
Book Title : Fundamentals of Database Management Systems
Author : Mark L. Gillenson (2005)
Edition : Latest Edition
Publisher : John Wiley & Sons
Book Title : Data Analysis with Excel®: An Introduction for Physical Scientists
Author : Les Kirkup (2002)
Edition : Latest Edition
Publisher : Cambridge University Press.
Title : Information Technology and Database Management System(SQL 1)
Type : Presentation
View Information Technology and Database Management System(SQL 1)
Title : Information Technology and Database Management System(SQL 2)
Type : Presentation
View Information Technology and Database Management System(SQL 2)
Title : Information Technology and Database Management System(SQL 3)
Type : Presentation
View Information Technology and Database Management System(SQL 3)
Title : Information Technology and Database Management System(SQL 4)
Type : Presentation
View Information Technology and Database Management System(SQL 4)
Title : Information Technology and Database Management System(SQL 5)
Type : Presentation
View Information Technology and Database Management System(SQL 5)
Title : Information Technology and Database Management System(SQL 9)
Type : Presentation
View Information Technology and Database Management System(SQL 9)
Title : Information Technology and Database Management System(SQL 10)
Type : Presentation
View Information Technology and Database Management System(SQL 10)
Title : Information Technology and Database Management System(SQL 11)
Type : Presentation
View Information Technology and Database Management System(SQL 11)
Title : Information Technology and Database Management System(SQL 12)
Type : Presentation
View Information Technology and Database Management System(SQL 12)
Title : Information Technology and Database Management System(SQL 2)
Type : Presentation
View Information Technology and Database Management System(SQL 2)
Title : Information Technology and Database Management System(SQL)
Type : Presentation
View Information Technology and Database Management System(SQL)