To understand the basics concepts of web threats, legal ethical and professional issues of information security.
- Course creator: Ms. Gurminder Kaur
To understand different storage techniques and database techniques.
- Course creator: Mr. VIKAS KUCHHAL
- Course creator: Mr. PAWAN LATHWAL
UNIT – I
Introduction to Data Warehousing: Overview, Difference between Database System and Data Warehouse, The Compelling Need for data warehousing, Data warehouse – The building Blocks: Defining Features, data warehouses and data marts, overview of the components, Three tier architecture, Metadata in the data warehouse.
Data pre-processing: Data cleaning, Data transformation ETL Process. ETL tools.
Defining the business requirements: Dimensional analysis, information packages – a new concept, requirements gathering methods, requirements definition: scope and content.
UNIT – II
Principles of Dimensional Modeling: Objectives, From Requirements to data design, Multi Dimensional Data Model, Schemas: the STAR schema, the Snowflake schema, fact constellation schema.
OLAP in the Data Warehouse: Demand for Online Analytical Processing, limitations of other analysis methods- OLAP is the answer, OLAP definitions and rules, OLAP characteristics, major features and functions, hyper cubes.
OLAP Operations: Drill-down and roll-up, slice-and-dice , pivot or rotation, OLAP models, overview of variations, the MOLAP model, the ROLAP model, the DOLAP model, ROLAP versus MOLAP, OLAP implementation considerations. Query and Reporting, Executive Information Systems (EIS), Data Warehouse and Business Strategy.
UNIT – III
Data Mining Basics: What is Data Mining, Data Mining Defined, The knowledge discovery process (KDD Process), Data Mining Applications- The Business Context of Data Mining, Data Mining for Process Improvement, Data Mining as a Research Tool, Data Mining for Marketing, Benefits of data mining,
Major Data Mining Techniques: Classification and Prediction: Issues Regarding Classification and Prediction, Classification by Decision Tree Induction, KNN Algorithm. ]
UNIT – IV
Cluster detection, K- means Algorithm, Outlier Analysis, memory-based reasoning, link analysis, Mining Association Rules in Large Databases: Association Rule Mining, genetic algorithms, neural networks.
Data mining tools.
- Course creator: Mr. VIKAS KUCHHAL
- Teacher: Ms. Sneha Choudhary
UNIT I Introduction Software testing: Testing as an Engineering Activity, Role of Process in Software Quality, Testing as a Process, Software Testing Principles, Tester Role in Software Development, Artifacts of testing (Faults, Errors, and Failures), Limitations of Testing, Challenges in Software Testing, Testing and debugging, Verification, Validation, Test levels. Software Quality: Software Quality, Software Control, Quality Assurance, Quality Assurance Analyst, Quality Factor, Quality Management, Methods of Quality Management, Core components of Quality, Cost Aspect of Quality.
[T1][T2][R3][No. of hrs. 10]
UNIT II
White Box and Black Box Testing
Different Testing Techniques, Differences between testing techniques
Black Box Testing: Requirements based testing techniques, Boundary value analysis, Equivalence partitioning, Decision table, State/Graph based testing
White Box Testing: Static testing techniques, Static analysis tools, Unit/Code functional testing, Control flow testing, Code complexity testing, Data flow testing
Integration, System and Acceptance Testing: Integration testing approaches, System testing, Scenario Testing, Deployment testing, Non-functional testing techniques,
Acceptance Testing: Acceptance criteria, types, test cases selection and execution.
[T1][T2][R2][No. of hrs. 10]
UNIT III
Quality Assurance: Quality Planning, Quality plan objectives, Planning process overview, Business Plan and Quality Plan, TQM (Total Quality Management), TQM concepts, Zero defect movement
Quality Standards: Quality Models/Standards, Standards and guidelines, Types of Models, ISO Standards, CMM and CMMI, Six Sigma concepts, Quality Challenge, National Quality Awards.
[T2][R1][R3] [No. of hrs. 10]
UNIT IV
Test Selection & Minimization for Regression Testing
Regression testing, Regression test process, Selection of regression tests, Dynamic Slicing, Test Minimization, Tools for regression testing.
Test Management and Automation
Test Planning, Management, Execution and Reporting, Software Test Automation: Scope of automation, Design & Architecture for automation, Testing tools, Object Oriented Testing.
[T1][R1][R2][No. of hrs. 10]
Text Books:
[T1] Yogesh Singh,‖Software Testing‖, Cambridge University Press, 2011
[T2] Sagar Naik, Piyu Tripathy,‖ Software Testing and Quality Assurance‖, Wiley
REFERENCE BOOKS:
[R1] Effective methods for Software Testing William Perry, Wiley
[R2] Aditya P. Mathur, ―Foundation of Software Testing‖, Pearson Education.
[R3] Milind Limaye,‖Software Quality Assurance, McGraw-Hill publication
[R4] Paul C. Jorgensen, ―Software Testing: A Craftsman‘s Approach‖, Auerbach Publications, 2008
INSTRUCTIONS TO PAPER SETTERS: MAXIMUM MARKS: 75
1. Question No. 1 should be compulsory and cover the entire syllabus. This question should have objective or short answer type questions. It should be of 25 marks.
2. Apart from Question No. 1, rest of the paper shall consist of four units as per the syllabus. Every unit should have two questions. However, student may be asked to attempt only 1 question from each unit. Each question should be of 12.5 marks.
List of Experiments:
1. Eight experiments suggested on kits for GSM, CDMA and any possible experiments covering the subjects.
2. Setting up wireless network with and without infrastructure support.
3. Configuring Access Point with bridging mode (Point to Point and Point to Multi Point).
4. Configuring Routing between wired and wireless Networks.
5. Configuring Security in wireless network with and without infrastructure support.
- Course creator: Ms Babita Antil
UNIT – I
Introduction To Wireless Communication Systems: Evolution of mobile radio communications; examples of wireless comm. systems; paging systems; Cordless telephone systems; overview of generations of cellular systems, comparison of various wireless systems.
Introduction to Personal Communication Services (PCS): PCS architecture, Mobility management, Networks signaling. A basic cellular system, multiple access techniques: FDMA, TDMA, CDMA.
Introduction to Wireless Channels and Diversity: Fast Fading Wireless Channel Modeling, Rayleigh/Ricean Fading Channels, BER Performance in Fading Channels, Introduction to Diversity modeling for Wireless Communications
[T1,T2][No. of Hrs. 11]
UNIT - II
2G Networks: Second generation, digital, wireless systems: GSM, IS_136 (D-AMPS), IS-95 CDMA. Global system for Mobile Communication (GSM) system overview: GSM Architecture, Mobility Management, Network signaling, mobile management, voice signal processing and coding. Spread Spectrum Systems- Cellular code Division Access Systems-Principle, Power Control, effects of multipath propagation on code division multiple access.
[T1,T2][No. of Hrs. 11]
UNIT - III
2.5G Mobile Data Networks: Introduction to Mobile Data Networks, General Packet Radio Services (GPRS): GPRS architecture, GPRS Network nodes, EDGE, Wireless LANs, (IEEE 802.11), Mobile IP.
Third Generation (3G) Mobile Services: Introduction to International Mobile Telecommunications 2000 (IMT 2000) vision, Wideband Code Division Multiple Access (W-CDMA), and CDMA 2000, Quality of services in 3G, Introduction to 4G.
[T1,T2][No. of Hrs. 11]
UNIT – IV
Wireless Local Loop (WLL): Introduction to WLL architecture, WLL technologies. Wireless personal area networks (WPAN): Blue tooth, IEEE 802.15, architecture, protocol stack. Wi-Max, introduction to Mobile Adhoc Networks.
Global Mobile Satellite Systems, Case studies of IRIDIUM and GLOBALSTAR systems.
[T1,T2][No. of Hrs. 11]
Text Books:
[T1] Raj Pandya, ―Mobile & Personnel communication Systems and Services‖, Prentice Hall India, 2001.
[T2] Theodore S. Rappaport, ―Wireless Communication- Principles and practices,‖ 2nd Ed., Pearson Education Pvt. Ltd, 5th Edition, 2008.
Reference Books:
[R1] T.L.Singhal ―Wireless Communication‖, Tata McGraw Hill Publication.
[R2] Jochen Schiller, ―Mobile communications,‖ Pearson Education Pvt. Ltd., 2002.
[R3] Yi –Bing Lin & Imrich Chlamatac, ―Wireless and Mobile Networks Architecture,‖ John Wiley & Sons, 2001.
[R4] Lee, W.C.Y., ―Mobile Cellular Telecommunication‖, 2nd Edition, McGraw Hill,1998.
[R5] Smith & Collins, ―3G Wireless Networks,‖ TMH, 2007
[R6] Schiller, Jochen, ―Mobile Communications‖, 2nd Edition, Addison Wesley
- Course creator: Ms Babita Antil