3rd Sem CSE Syllabus - Advanced Python Programming

# Advanced Python Programming ## Subject code - CSE301 ## 1. RATIONALE - In previous semester (Semester II) students have learned basics of python programming. - Python is a modern language useful for writing compact codes specifically for programming in the areas of: - Server-side web development. - Data analytics. - AI, and scientific computing. - Production tools. - Game programming. - This course deals with some advanced features of the 'Python' language. - The student will be able to develop programs with adequate advanced concepts using python language. ## 2. COMPETENCY - Develop a program using advanced python language concepts to solve the givenproblem. ## 3. COURSE OUTCOMES (COS) - Develop python programs by applying data structures - dictionary, tuple, and set concepts. - Develop modules and packages in python programs for modular programming approach. - Implement error handling techniques using exception handling. - Develop python programs using file input/output operations. - Draw graphics using the turtle module. ## 4. CONTENT | Unit | Outcomes | Topics and Sub-topics | |---|---|---| | **Unit - I Basic of python data structure - Dictionary, Tuple and Set** | 1.1 Use of String and listoperations in python programs. 1.2 Use built-in functions for Set manipulation. 1.3 Use of Tuple operations in python programs. 1.4 Use built-in functions for Dictionary manipulation. | 1.1.1 Introduction to Strings, Lists 1.2.1 Set - Sets in Python - Create a Set, Accessing Python Sets, Delete from sets, Update sets - Python Set Operations 1.3.1 Tuple - Tuples in Python - Creating Tuples - Accessing Tuple - Iterate over tuples - Slicing tuples - Tuples are Immutable - Python Tuple Operations - Built-In Tuple Functions andmethods 1.4.1 Dictionary - Dictionaries in Python - Creating Dictionaries - Accessing Items in Python Dictionaries - Add, Update, Remove in Dictionaries - Properties of Dictionary Keys - Built-In Dictionary Methods andfunctions | | **Unit - II Modules and Packages** | 2.1 Describe creating and importing module 2.2 Describe creating and importing package 2.3 PIP - Package Installer for Python | 2.1.1 Introduction to module 2.1.2 Creating user defined module 2.1.3 Importing a module in python - Normal import - From import - From import with * 2.1.4 Module search path 2.2.1 Introduction to Packages 2.2.2 Creating user defined package 2.2.3 Importing a package in python - Normal import - From import - From import with * 2.2.4 Intra-package References 2.3.1 Installing PIP 2.3.2 Installing/uninstalling python packages | | **Unit-III Exception handling** | 3.1 Explain errors & exceptions 3.2 List types of Exceptions 3.3 Implement Raising Exceptions 3.4 Implement Handling Exceptions | 3.1.1 Introduction to Exception 3.2.1 Types of Exceptions : - Built-in Exceptions - User defined Exceptions 3.3.1 Raising Exceptions 3.4.1 Handling Exceptions - Try clause - Except clause - Finally clause | | **Unit-IV Files Handling** | 4.1 List types of file 4.2 Explain basics of file creation, reading and writing in context to file handling. 4.3 Explain setting file offsets 4.4 Explain Object Serialization. | 4.1.1 Introduction to files and its types. - Binary files - Text files 4.2.1 Opening and Closing Text File 4.2.2 Reading and Writing Files 4.3.1 Setting Offsets in File 4.4.1 Object Serialization - Pickle Module | | **Unit- V Graphics with Turtle** | 5.1 Explain turtle graphics module 5.2 Implement graphics using turtle 5.3 Use loops and conditional statements to draw graphics | 5.1.1 Introduction to turtle graphics 5.2.1 Turtle methods 5.2.2 Turtle Screen Methods 5.3.1 Turtle programming - loops and conditional statements. | # Computer Hardware, Maintenance and Administration ## Subject code - CSE302 ## 1. Rationale - Professional computer maintenance ensures computer hardware and software systems run efficiently to increase productivity while lowering the chances of downtime. - This course aims to help understand the internal working of computers/laptops and prepare the student for a role as an entry-level IT support technician. - This course sets a basis for different facets of information technology like computer hardware, software, trouble shooting and customer service. ## 2. Course Outcomes: At the end of this course, students will be able to: | CO | Description | |---|---| | CO-01 | Assemble a computer as per given technical specifications following all necessary safety protocols and install, configure and setup an administrator for a Windows Operating System. | | CO-02 | Diagnose a computer using the right diagnostic tools, identify the hardware problem and troubleshoot to resolve the problem following all safety protocols. | | CO-03 | Diagnose an installed software using the right diagnostic tools, identify the bug/issue, troubleshoot to resolve bugs/issues and ensure all data and applications are backed up before troubleshooting. | | CO-04 | Explain e-waste protocols to be followed while disposing computer hardware, to ensurecompliance with all required state pollution control board regulations. | ## 3. Course Content | Week | CO | PO| Lecture (Knowledge Criteria) | Tutorial (Activity Criteria) | Practice (Performance Criteria) | |---|---|---|---|---|---| | 1 | 01 | 1, 4 | I/O devices and Interfaces Types of I/O devices and ports on a standard PC for connecting I/O devices. Function of serial port, parallel port, and brief principle of communication through these ports, types of devices that can be connected and interface standards Explain basic cable types, features and their purposes. Importance of USB and HDMI interfaces- Types and Features. Working of Common Input/Outputdevices- Keyboard, Mouse, display monitor, printer and speaker. | Refer Table 1 | 1. Hardware Identification: - Computer Case- Types, Features- Front panel, back panel; A look inside the computer case. - Identify the front and rear panel controls andports on a PC cabinet. - Identify and understand different cables and connectors: Video cables- VGA, HDMI, Mini-HDMI, Display port, DVI; Peripheral cables- Serial; Hard drive cables- SATA, PATA, IDE, SCSI; Adap HDMI, USE to VGA. - Installation of a localprinter. - Shared printer. - Installing wireless andcloud printers. | | 2 | 01 | 1,4 | Power supplies Safety Basics: safety protocols; anti- static basic hand tools, Know the danger of static electricity, power variation; Precautions to be taken while mounting and unmounting power supply into/ from the cabinet;DC power source to PC - Need for SMPS, Specifications, Ratingof SMPS based on type of motherboard and devices used (AT/ATX, Micro ATX, mini ATX, higher watts PSU for gaming PC), color coding adopted, Types of connectors used- ATX, ATX12V, Molex, SATA, PCIe; Output voltage levels, measuring technique; choosingpower supply based on wattage rating; Heat sink; 80 plus rating system; Modular power supply. Symptoms of SMPS failure; Commonproblems from a faulty SMPS. Trouble shooting Power supplies. | | 1.Unmonut the power supply from PC cabinet.Identify the types of output connectors. 2. Identify output voltagesusing color coding. 3. Measure voltage levelsusing multi meter. 4. Mount the power supply into the PC cabinet, connect different componentsand test PC. 5. Trouble shoot Power supply through SMPS fan. 6. Diagnose power supply faults using PSU Tester. | | 3 | 01 | 1,4 | Basic Electronics -Electricity, Electrical quantities- Voltage, current and resistance; Active components: Diodes- PN junction diodes, biasing conditions- forwardbias and reverse bias, transistors- BJT, MOSFET; Passive components-Resistors, capacitors, inductors, transformers, sensors, and transducers; Integrated Circuits Digital Electronics- PWM, opto-coupler; checking AC to DC converter. | | 1. Identify the electrical and electronic components used ina computer and tabulatethem as active and passive components. 2. Identify the working and non-working stateof basic components and semiconductor devices. 3. Using multi meter- Check Output voltage ofbasic components and semiconductor devices. 4. Check different voltage levels of opto-coupler, PWM and rectifier. | | 4 | 01, 03 | 01, 04 | Mother board - Example Motherboards; Functional description of mother board; specification and variation. Form factor- what is Motherboard Form factor? Types and features of Motherboard formfactors- ATX, Micro-ATX, Mini-ITX, Nano-ITX, andPico-ITX. Functional components of Motherboard; CPU and CPU socket-Types of sockets; Overview of microarchitecture of INTEL and AMD CPU. | | 1. Precautions to be takenbefore removing the mother board from PC cabinet. 2. Using the CPUID CPU-Ztool, find different features of CPU. 3. Check the Electric flowpath and data flow path 4. Windows resourcemonitor 5. Using the CPUID CPU-Ztool, identify the CPU cache features of your working system. | | 5 | 01, 03 | 04 | Chipsets- Function, Types and Features. Buses- System bus architecture Importance of POST; UEFI why is itrequired, possible configurations through UEFI. IDE ports; Methods of adding SCSIdrives. CMOS battery: Why? Its specifications. Impact of removingthe battery from mother board. | | 1. Identify system faults using POST diagnosticscard. 2. Understand basic onboard configurationsthrough UEFI. 3. Test different motherboards to determine support forUEFI 4. Replace the CMOS battery in a computer following the procedures. 5. Understand and modifyBIOS settings and observe the consequences of CMOS failure. | | 6 | 01, 03 | 04 | Memory-Memory Units (B, KB, MB,GB, TB), memory locations and address space, Access methods, Memory Classification. Main memory Types and Features.Auxiliary memory Types and features. Memory modules. | | 1. Identify RAM chips and HDD/SSD, study their features and note their technical specifications. 2. Identify SIMM and DIMM memory modules, their number of pins, specs and type. 3. Identify the interface type of a hard drive andconnect it to a PC for data recovery. | | 7 | 01,03 | 01, 04 | RAM Technology- SDRAM, DDR, DDR2, DDR3, DDR4- Clock speed, Bandwidth, Memory speed rating, PCspeed rating; RAM capacity- single-sided and double-sided RAM, Channels; RAM features- Parity/ECC RAM,SODIMM, SPDR chip. Mass storage media- Hard drive, Principle of working, reliability, performance, SSD, optical drive; Logical Block Addressing (LBA); Memory capacity- physical and logical addressing; M.2 drives, SATA, NVMe. Causes of Hard drive failure; Signs offailure; Backup and recovery of data; | | 1. Use CPUID-CPUZ tool toidentify capacity, speed, technology, and related features of RAM. 2. Check for RAM and Motherboard compatibility and install additional RAMstick. 3. Find on Windows system properties tocheck the RAM for correct installation. 4. Query the SPD RAM chip to identify all possible informationusing CPUID CPUZ. | | 8 | 02, 03 | 04 | Windows Installation - Overview windows 10; general features; Versions; architecture;prerequisites for windows 10 installation: hardware compatibility, BIOS compatibility, driver requirements. Clean install of windows 10; upgrade to windows 10; disk partitioning; troubleshooting installation problems; Multiple boot options; windows service packs. Imaging: create a Windows system image; How to Backup/Restore your Windows partition with the bootable image. | | 1. Windows Installation Inspect prerequisites for windows 10 installationon a given computer. 2. Perform cleaninstallation. 3. Upgrade to windows 10. 4. Create dual boot for a given system, learn andrectify errors in dual boot. 5. Practice on recoverypartition. 6. Practice 10 registrytweaks. 7. Practice disk management utilities. | | 9 | 01, 02, 03 | 04 | File system overview, types, properties, conversion from one filesystem to another, configuration. Configuring system and data recovery: Recover files, recover apps and the registry; recover windows 10. Configure and manage windows updates: auto/manually; testing and troubleshooting updates. Monitor and manage: Performance monitoring; optimizewindows services; tune scheduled tasks. Customizing windows desktop. | | 1. Practice data recovery/management. 2. Working with task scheduler and troubleshoot configuration and otherperformance related issues. 3. Working with taskscheduler. 4. Customizing windows desktop. | | 10 | 01, 03 | 01, 04, 07| Windows Command line; PowerShell; basic commands; writing simple PowerShell scripts. File security. | | 1. Execute basic commands in Windows using command prompt and PowerShell like listing the drives in a system, creating a new file, removing a file or directory, retrieving the list of processes and services, etc., 2. Use command line to encrypt and decrypt files and folders. | | 11| 02, 03, 04 | 04 | Portable computing- Troubleshooting Laptops- I Difference between laptop and desktop Motherboards; Checking Power connector and adaptor pins, AC adapter of Laptop circuit diagram, Fault finding; trouble-shooting voltage transfer section, AC-DC conversion, Generation of stand by voltage, fault finding- No power ON, power switch, Battery charging circuit; | | 1. Observe the layout of a laptop and compare it with a desktop. 2. Follow/review manufacturer maintenance guide forrepair and maintenance. 3. Power Issues: Battery not charging, No power. 4. Trouble shoot computer hardware issues in the followingscenarios- -Unexpected shutdowns. -Lockups -POST & Boot -Continuous reboot -No Power -Loud Noises. -Intermittent devicefailure -Smoke and burning smell 5. -Indicator lights. | | 12 | 03, 04 | 01, 04 | Troubleshooting Laptops- II Dual MOSFET pin details, Two N- channel MOSFET in place of dual MOSFET, one p-channel and one N- channel MOSFET, problems and faultfinding; CPU voltage generation circuits, keyboard interface, problem and fault finding. Touch pad connector, BIOS details, SATA HDD details, Audio section, internal display, LED screen pin details. Malware mitigation: introduction, types, symptoms, malware removal; | | 1. Perform the same operations in week#7on a laptop. 2. LCD display trouble-shoot: No display/dim video/flickering video. 3. Wireless troubleshooting: Multiple antennae, check presence of wireless cards. 4. Scan and remove malwares in eachcomputer or mobiledevice. 5. Perform Antivirus and anti-malware updates. | | 13 | 04, 01 | 04 | E-waste management: What is EEE and E-waste? Different scenarios of E-waste management, StEP initiatives to solve e-waste problems, impact of e-waste on health ofchildren and workers. E-waste management in India: EPR and e-waste, the informal sector in e-waste management, Technologies for e-waste management, Financing e-waste management systems- Key steps, milestones to achieve a robust E-waste system. Case studies. | | Visit https://g https://kspcb.k find the latest ru policies taken up by the Government of India. Visit a nearby e-waste management plant and understand the management process. | *** # Computer Networks ## Subject code - CSE303 ## 1. Rationale - The computer networking skills are essential in today’s information and communication technology driven world. - It enables students with essential skills and knowledge to explore the world of communication and networking for further study and career. ## 2. Course Outcomes: At the end of the course, the student will be able to: | CO | Description | |---|---| | CO-01 | Select an appropriate communication technology for a given network and ensure optimal performance by addressing issues arising from transmission impairments. | | CO-02 | Design a network for a given specification by using the right network component" topologies, protocols and software. | | CO-03 | Design, build, test and troubleshoot a SOHO network for a given premises. | | CO-04 | Demonstrate the configuration of IP address, routing, subnetting, client-server inte. UDP) and DNS for a given WAN network using a network simulator and troubleshoo network issues | ## 3. Course Content | Week | CO | PO | Lecture (Knowledge Criteria) | Tutorial (Activity Criteria)| Practice (Performance Criteria) | |---|---|---|---|---|---| | 1 | 01 | 1, 2 | Electromagnetic waves - Generationof electromagnetic waves and their properties Electromagnetic spectrum - classification and its applications Communication Systems - Basic elements of communication systems with block diagram, List commonly used terms in electronic communication systems, Data representation, Data flow, Modulation, Demodulation Analog and Digital Signals, Periodic and Non-Periodic Signals, Sine Wave, Phase, Wavelength, Digital Signals, Bit-rate, Bit-length. | Refer Table 1 | 1.Build a circuit to Generate and detect of BASK signal and BFSK signal using communication kit.| | 2 | 01| 1,2 | Transmission Impairment - Attenuation, Distortion and Noise, Performance - Bandwidth, Throughput, Latency, Jitter (Basic concepts only). | | 1. Explore all ISP in your area/locality and select best internet ISP/plan | | 3 | 01, 02 | 1, 2, 3 | Transmission Modes - Parallel and Serial Transmission. Asynchronous and Synchronous Transmission. Satellite communication- Introduction, advantages and disadvantages Perspectives on Networking - End user perspectives on Networking and Internet, Overview of Networking. Categories of networks - LAN, MAN, WAN, Internetworking (Illustrate Network from LAN connected using a HUB to Internetwork). The communication rules (Method, language, Confirmation) – Protocols, the Internet. The Network Standard Organizations, Protocol Stack. OSI Model: OSI Layers and Their Functions, OSI Layering Concepts and Benefits, OSI Encapsulation Terminology. | | 1. Test the download/upload speed in your computer/mobile phone also check type, bandwidthand ISP. 2. Explore Bluethooth, Wifi, NFC in your smartphone and note their key technical attributes (Radio spectrum band, range, pathloss, throughput, mode etc) 1. My Protocol Rules Objectives - Relate computer network protocols to the rules that you use every day for various forms of communication. - Define the rules that govern how to communicate in a group of students. - Play the communication game. - List what would happen if the sender and receiver did not agree on th the protoco 2.Manual and address assig (Windows) - IPv4 address - Subnet mask - DNS 3.Manual and Automatic address assignment (Android) - IPv4 address - Subnet mask - DNS | | 4 | 01, 02 | 1, 2, 3 | TCP/IP Networking Model - History Leading to TCP/IP, Overview of the TCP/IP Networking Model. TCP/IP Application Layer, HTTP Overview, HTTP Protocol Mechanisms. TCP/IP Transport Layer, TCP Error Recovery Basics, Same-Layer and Adjacent-Layer Interactions. TCP/IP Network Layer, Internet Protocol and the Postal Service, Internet Protocol Addressing Basics, IPRouting Basics. TCP/IP Link Layer (Data Link Plus Physical), TCP/IP Model and Terminology, Data Encapsulation Terminology. Names of TCP/IP Messages. | | 1. Organize and play games to understand working of TCP/IP like: - Create 2 group of students, each playing role of a layers of TCP/IP (intermediate network devices roles can also be considered). - Start the communication between two with a sender and receiver. 2. Determine the IP Address Configuration of a Computer (Windows) and Test the Network Interface TCP/IP Stack (Ping). 1. Demonstrate working of common network devices. 2. Demonstrate different network cables and connectors. 3. Install and configure NIC. 4. Crimping of RJ45: Straight and Cross. - Punching Cat 6 cable to I/O Box. Use punching tool. - Check connectivity using LAN tester | | 5 | 02, 03 | 1, 4 | Hardware and Software componentsof Network - Common network devices - Computers, Access points, Hub, Switch, Router, repeaters, NIC, Modem. LAN Cables - Co-axial, twisted pair, optical fibre, LAN connectors- co-axial cable, and twisted pair cable, optical fibre, Connectors, Firewall, Firm wares, ISPs. | | 1. Install Network simulator like Cisco packet tracer. 2. Create simple network in simulator. 3.Create and Demonstrate all possible network topologies using simulator. | | 6 | 01, 02 | 2, 3 | Overview of network topologies - Basic topologies- bus, ring, star, mesh and hybrid. Network Simulator: Network simulator like Packet Tracer, Installation, User Interface. Deploy devices and cables GUI and CLI Configuration. Configure end Devices | | 1. Build a physical Ethernet LAN Network and demonstrate f" printer sharir 2. Install and c wireless access pr........... the LAN. 3. Use pathping command to find actual path between source to destination with information about network latency/delay & network loss. | | 7 | 02, 03 | 1, 2, 3, 4 | An Overview of LANs - Typical SOHOLANs, Typical Enterprise LANs, The Variety of Ethernet Physical Layer Standards, Consistent Behaviour over All Links Using the Ethernet Data Link Layer. Building Physical Ethernet Networks with UTP - Transmitting Data Using Twisted Pairs, Breaking Down a UTP Ethernet Link, UTP Cabling Pinouts for 10BASE-T and 100BASE-T, Straight-Through Cable Pinout, Crossover Cable Pinout, Choosing the Right Cable Pinouts, UTP Cabling Pinouts for 1000BASE-T, Sending Data in Ethernet Networks. | | 1. Determine the MAC Address of a Host(PC and Phone). 2. View Wireless and Wired NIC Information and makea table explaining each. 3. Configure and install a ethernet switch/Hub (Use simulator if hardware devices are not available) 4. Create/model a simple Ethernet network using 3 hosts and a switch, Observe traffic behavior on the network and Observer | | 8 | 02, 03 | 1, 2, 3, 4 | Ethernet Data Link Protocols - The Rise of Ethernet, The Ethernet MAC address and Ethernet Addressing, Identifying Network Layer Protocols with the Ethernet Type Field, Error Detection with FCS. Encapsulation, Ethernet Frame. Hierarchical Network Design Physical and logical addresses, Benefits of a Hierarchical Design, Access, Distribution, and Core layers Sending Ethernet Frames with Switches and Hubs, Sending in Modern Ethernet LANs Using Full-Duplex, Using Half-Duplex with LAN Hubs. Ethernet access layer devices - Hub, Switch, The MAC address table, Ethernet Broadcast and Broadcast domain, ARP. | | 1. Determine the MAC Address of a Host(PC and Phone). 2. View Wireless and Wired NIC Information and makea table explaining each. 3. Configure and install a ethernet switch/Hub (Use simulator if hardware devices are not available) 4. Create/model a simple Ethernet network using 3 hosts and a switch, Observe traffic behavior on the network and Observer data flow of ARP broadcasts and pings. | | 9 | 02, 03, 04| 1, 2, 3, 4 | Routing: The Need for Routing - Criteria for Dividing the Local Network - Now We Need Routing Overview of Network Layer Functions - Network Layer Routing (Forwarding) Logic, Host Forwarding Logic: Send the Packet to the Default Router, Routing Data Across the Network, Delivering Data to the End Destination, How Network Layer Routing Uses LANs and WANs, IP Addressing and How Addressing Helps IP Routing, Routing Protocols. IPv4 Addressing - Rules for IP Addresses, Rules for Grouping IP Addresses, Class A, B, and C IP Networks, The Actual Class A, B, and C IP Networks, IP Subnetting, How to create subnets, Subnet mask, CIDR, variable length subnet mask. | | 1. Build a simple peer-to-peer network and verify physical connectivity and Assign various IPv4 addresses to hosts and observe the effects on network communication 2. Configure IP addresses ofa network (real or simulated) and ping acrossto test and troubleshoot. 3. Subnetting of a network (either using real networkor in Simulator). 4. Connect to web server using simulat how packet the Internet addresses. | | 10 | 02, 03, 04 |1, 2, 3, 4, 7 | IPv4 Routing - IPv4 Host Routing, Router, Forwarding Decisions and the IP Routing Table, The default gateway, A Summary of Router Forwarding Logic, A Detailed Routing Example. Routing Protocols - IPv4 Routing Protocols - static and dynamic. Other Network Layer Features - Using Names and the Domain Name System, The Address Resolution Protocol, ICMP Echo and the ping Command. DHCP - Static address assignment, Dynamic address assignment, DHCP servers. | | 1. Implement simple static routing. 2. Troubleshooting of IP Addressing- - Change a routing table entry - Wrong address - incorrect subnet mask 3. Configure and test DHCP on a wireless router (real or simulated) | | 11 | 02, 03, 04| 1, 2, 3, 4 | Pv4 and IPv6 Address Management - Network Boundaries -Gateways to Other Networks, Routers as Gateways. Network Address Translation - Introduction, NAT operation. IPv4 Issues - Need of IPv6, Ipv4 vs IPv6, IPv4 and IPv6 Coexistence. IPv6 features - IPv6 Address Representation. Concept of Virtual LAN's(VLAN's)| | 1. Packet Tracer - Examine NAT on a Wireless Router 2. Identify IPv6 Addresses - Identify the different types of IPv6 addresses. - Examine a host IPv6 network interface and address. - Practice IPv6 address abbreviation. 3. Setup, configure and test VPN in your smartphone. | | 12 | 02, 03, 04| 1, 2, 3, 4| The Client Server relationship - Client Server interaction. URI, URN, URL TCP/IP Layer 4 Protocols: TCP and UDP - Transmission Control Protocol, Multiplexing Using TCP Port Numbers, Popular TCP/IP Applications, Connection Establishment and Termination, User Datagram Protocol. Port Numbers - TCP and UDP. Socket pairs, the netstat command. Application Layer Services - Common Network Application Services, Domain Name System, Domain Name Translation, DNS Servers, HTTP, Web Clients and Servers, FTP, Virtual Terminals, Remote Access with Telnet or SSH, Telnet, Security Issues with Telnet, SSH, Email- Email protocols, Simple Mail Transfer Protocol (SMTP), Post Office Protocol (POP3), Internet Message Access Protocol (IMAP4). | | 1. Create a client server model in simulator and observe the client interaction between the server and PC using packet tracer. 2. Observe DNS Name Resolution a) Observe the conversion of a URL to an IP address. b) Observe DNS lookup using the nslookup command. 3. Use simulator to demonstrate Telnet and SSH | | 13 | 02, 03, 04 | 1, 2, 3, 4 | Troubleshoot Common Network Problems - The Troubleshooting Process, Network Troubleshooting Overview, Gather Information - Natureof problem, Equipment. Configuration and Topology, Previous Troubleshooting. Structured Troubleshooting Methods - Bottom-Up, Top-Down, Divide-and-Conquer, Follow-the-Path, Substitution, Comparison, Educated Guess. Guidelines for Selecting a Troubleshooting Method Troubleshoot Wireless Issues - Causes of Wireless Issues, Authentication and Association Errors. | | 1. Demonstrate troubleshooting Commands with a scenario- ipconfig, ping, netstat, tracert, nslookup. 2. Interpr commonly u command li Determine w utility can prov 3. necessary information to perform troubleshooting activities in a bottom-up troubleshooting strategy Physical Layer Problems - Common Layer 1 Problems, how to use the five senses to troubleshoot, Wireless Router LEDs, Cabling Problems 4. Common Internet Connectivity Issues - DHCP Server Configuration Errors, Check Internet Configuration, Check Firewall Settings. | *** # Database System Concepts and PL/SQL ## Subject code - CSE304 ## 1. Rationale - Data, factual information, is the main driving force that is changing the face of our world. - Database is an organized collection of related data which is stored and accessed electronically using a computer. - Database management has evolved from a specialized computer application to a central component of virtually all enterprises, and, as a result, knowledge about database systems has become an essential part of an education in computer science. - SQL is a powerful language for both querying and updating data in relational databases. - Study of SQL empowers students to implement and work with relational data model. ## 2. Course Outcomes: At the end of the course, the student will be able to: | CO | Description | |---|---| | CO-01 | Identify the elements of ER model for a given requirement, draw ER diagram and validate with the given requirement. | | CO-02 | Translate the given ER diagram to a relational model and verify against integrity constraints. Also refine and normalize the relational database design against first three normal forms. | | CO-03 | Use appropriate SQL statements to create a database and other DB objects using a DBMS software. | | CO-04 | Perform insert, delete and/or update operations on the database and query the database to retrieve the required information using appropriate SQL statements and clauses. | ## 3. Course Content | Week | CO | PO | Lecture (Knowledge Criteria) | Tutorial (Activity Criteria) | Practice (Performance Criteria) | |---|---|---|---|---|---| | 1 | 1 | 1,4 | Introduction Overview of DB: why a database? Purpose of database; Classification; Application; DBMS: features, providers; Functional components of DBMS; Types of DBMS architecture; View of data in DBMS; Database users; Role and responsibilities of DBA; Case study: Example of any database application, recruitment database | Refer Table 1 | 1. Install and setup DBMS software such as MySQL, PostgreSQL 2. Learn the interface and explore the features of installed DBMS | | 2 | 1 | 1,3,4 | Database design Data model; types; importance of data modeling; Overview of database design; phases of database design; database development life cycle; Conceptual design: ER-Model: entity: types; attribute: types; relationships: types, constraints, Symbols and Notations; Case study: conceptual design for a set of specifications i. Restaurant ii. Retail shop iii. Recruitment iv. College v. Library Relational model: Overview; characteristics; Constraints: types; Operations; Advantages and Disadvantages; applications; Design anomalies; Features of good DB design; Functional dependency: overview, rules, types; Normalization: normalization process; importance of normalization; 1NF,2NF,3NF Sufficient examples to understand the concept | | 1. Identify and ER-model elements and draw ER diagram for the given specifications using tools. | | 3 | 2 |1,3 | Relational model: Overview; characteristics; Constraints: types; Operations; Advantages and Disadvantages; applications; Design anomalies; Features of good DB design; Functional dependency: overview, rules, types; Normalization: normalization process; importance of normalization; 1NF,2NF,3NF Sufficient examples to understand the concept | | 1. Map ER Model to relational model 2. Identify various constraints | | 4 | 2 | 1,3 | Sufficient examples to understand the concept database languages: types, commands/tasks in each type; Integrity constraints; MySQL/PostgreSQL: overview; features; datatypes; Standardization guidelines; | | 1. Normalize the above design 1. Validate the above design against integrity constraints | | 5 | 3 | 1,4 | MySQL/PostgreSQL: overview; features; datatypes; Standardization guidelines; | | 1. Use MySQL/PostgreSQL DDL statements to create database and others tables | | 6 | 3 | 1,3,4 | Defining Data: DDL CREATE, ALTER, DROP different DB objects; Temporary tables: types, create and use; external tables; Managing constraints | | 1. Use MySQL/PostgreSQL DDL statements to create database and other tables | | 7 | 3,4 | 1,3,4 | Modifying data: UPDATE and DELETE Insert, delete and update data Update anomalies; impact of constraints Querying of available data: SELECT; Aliases; sorting data: ORDER BY | | 1. Perform delete and update operations 2. Perform table insertion 3. Querying single table 4. Sort the result set of a query | | 8 | 4 | 1,4 | filtering data: WHERE, AND, OR, row limiting clause, IN, BETWEEN, LIKE; | | 1. Querying single table 2. Querying multiple tables with joins 3. Query multiple tables with joins | | 9 | 4 | 1,4 | Joining table: INNER JOIN, LEFT JOIN, Grouping data: Aggregate functions, GROUP BY, HAVING; | | 1. Queries that use set operators 2. Report aggregated data using group functions | | 10 | 4 | 1,4 | Set operators: UNION, INTERSECT, MINUS; Subqueries: Comparator operators; subqueries: Single Row Subqueries; Multiple Row Subqueries; correlated subqueries; EXISTS, NOT EXISTS, ANY, ALL, SOME; | | 1. Write sub queries to retrieve information from the created database |

3rd Sem CSE Syllabus - Advanced Python Programming

Document Details

Tags

Related

Summary

Full Transcript

Upgrade to continue