CS– 313 Software Lab – V (DATABASE MANAGEMENT SYSTEMS)
External Marks: 20 L T P
Internal Marks: 30 – 4
Total Marks: 50
1. Introduction to DBMS.
2. To implement different types of DDL, DML and DCL statements in SQL.
3. To use constraints on the created database.
4. To explore ‘select’ clause using where, order by, between, like, group by, having etc.
CS-311 COMPUTER PERIPHERALS AND INTERFACES
PREREQUISITES: Microprocessor and Assembly Language Programming. OBJECTIVES:
To learn the functional details of various peripheral devices.
COURSE CONTENTS:
SYSTEM RESOURCES: Interrupt, DMA Channel, I/O Port Addresses and resolving and resolving the conflict of resources. I/O buses- ISA, EISA, Local bus, VESA Local bus, PCI bus, PCI Express, Accelerated graphics port bus.
(L-10) IDE & SCSI Interfaces: IDE origin, IDE Interface ATA standards ATA1 to ATA7. ATA feature, ATA RAID and SCSI RAID, SCSI Cable and pin Connector pin outs SCSI V/s IDE Advantages and limitation.
(L-4) Video Hardware : Video display technologies, DVI Digital signals for CRT Monitor, LCD Panels, Video adapter types, Integrated Video/ Motherboard chipset, Video RAM, Video driver and multiple Monitor, Graphic accelerators. Advanced 3D Technologies, TV Tuner and Video Capture upgrades troubleshooting Video Cards and Drivers.