Based on Theory course.
Course Catalogue
Overview: Definition of DMBS, types of DBMS, advantage & disadvantages, applications. Data
Model: ER Model, Relational Model Integrates Constraints. FD Constraints. Assertions, figures.
Database Design: Logical database design, physical database design; data storage device & data format.
File organization: Sequential file organization, Indexed file organization, direct file organization; hashing methods searching: sequential search, indexed search; reporting: Simple and complex report.
Relational Database design: Relational model, normalization, relational database design; relational query language: SQL. Query Processing, Query optimization, Database Administration: Functions: Standards, Security integrity, recovery; Concurrency control; coordination’s ; quality control: tuning and performance.
Multiple file databases: General considerations, designing the files, data entry and consistency data updating, tools for complex database manipulations. Object oriented database design.
Other types of DBMS: Network database, hierarchical database, text-oriented database, graphic-oriented database. Real time database intelligent database.
Programming: Common programming applications, important programming attributes: access to database records and fields; sorting searching, transactions among files, procedures and functions, reporting: Standard, complex, customized etc, structured aspects, variables and arrays; Handling database based on relations, network, hierarchical model; Programming projects: Create projects using menu builder, screen builder, form builder, report builder etc. Object oriented database programming.
Algorithm and complexity, asymptotic notations, orders, designing worst case and average-case. Basic Technique divide and conquer, dynamic programming, backtracking, greedy method, branch and bound, randomization. Data structure search trees, Fibonaaci heaps, union-find problems. Application-string matching, sorting and scorching, combinatorial problems, optimization problems, computational geometric: problems. Graph algorithms, spanning trees, shortest paths, matching, rnin flow, max-flow. NP- completeness. Approximation algorithms.
Introduction to different types of microprocessors, Architecture, Instruction Format, Instruction Sets, Opcode, Processor status and Flag registers, Addressing modes, Branching and Looping, Interrupt structures, I/O operation, I/O interfacing, DMA. Programming in Microcomputers. Hardware and Software interfacing in Microcomputer System Design, I/O design and total system design. Microprocessor based system design: Hardware design, building, debugging, testing and linking program modules. Programming EPROM. Multiprocessor configurations: coprocessor configurations, numeric data processor, I/O processors. Advanced Microprogramming: Bit-Slice Microprocessor, Parallelism in Microprocessor. The course includes lab works based on theory thought.
Principles involved in data communication. Modulation techniques, Pulse Modulation, Pulse amplitude modulation, pulse width modulation, pulse position modulation, pulse code modulation, pulse position modulation, quantization, Delta modulation, TDM, FDM, OOK, FSK, PSK, QPSK. Representation of noises, probability of error for pulse system, concept of channel coding and capacity, asynchronous and synchronous communications. Multiplexers, concentrators and buffers, communication medium, fiber optics.
Computer network architectures, protocol layers. Transmission media, encoding systems, error detection, multiplexing, switching. Data link, multiple access channel protocols. Network security, privacy. Applications including network management, electronic mail, virtual terminals, URL, HTTP, Multimedia, distributed operating systems. The course includes lab works based on theory taught. The course includes lab works based on theory taught.
OSI and TCP/IP reference models. Physical Layer: Transmission media characteristics: Guided transmission media, Wireless transmission, Public Switched Telephone Network, ISDN, ATM and Communication Satellites. Switching- circuit message and packet, data communication principles – asynchronous and synchronous. Data Link Layer: Framing, Flow & error control, Error detection & correction, Data link protocols. MAC sublayer: Channel allocation problem, Multiple Access protocols, Ethernet, Switching Devices, Wireless LAN, Broadband wireless. Network Layer: Deign issues, Routing Algorithms, Congestion Control algorithms, Internetworking and Internet. Transport Layer: The transport services, Elements of transport Protocols, Introduction to UDP & TCP. Application Layer: Basics of DNS, Email, Web services and introduction to network security. The course includes lab works based on theory taught.
Introduction of Microprocessor and its use, Microprocessor and Memory Basics, Microprocessor: microcontroller & microcomputer, evaluation of microprocessor & application, introduction to 8-bit, 16-bit, and 32-bit microprocessors; addressing modes: absolute addressing, 8086 internal architecture, PIN diagram of 8086, Max-Min mode, register structure; memory read write cycle; Instruction set; pipeline concept: interrupts, programmed I/O, memory mapped I/O, interrupt driven I/O, direct memory access; block transfer; cycle stealing; interleaved; multi-tasking and virtual memory; memory interface; bus interface; arithmetic co-processor; assembly language programming of 8086 microprocessors., serial data transmission, serial communication standards, serial interface implementation. Arduino: Buttons, PWM, and Functions, Arduino: Serial Communication and Processing, I2C, Modbus RTU, TCP/TP Communication and SPI Interfaces, Wireless Communication, Arduino: Interrupts and Hardware Handling, collecting data from external environment via sensors and send/receive data to cloud, learning about python interfacing Program to collect real time, data plotting simultaneously.
Based on theory course.
System Analysis Fundamentals, tools of information system development, information systems development life cycle, tools for analysis; planning phase: systems planning, preliminary planning and investigation, determining IS development requirements, project management, Object Oriented Systems Analysis and Design and Unified Modeling Language.; analysis phase: analysing requirements, evaluating alternatives, information systems analysis principles; design phase: structured information systems design, input design and control, output system design; development phase: information systems development, computer-aided software engineering; implementation phase: systems implementation, systems evaluation and optimization, information systems documentation, Costs and benefits of different approaches to implementing new systems.
Introduction to computer hardware: Processor, RAM, ROM, Motherboard, Hard Disk, DVDs; Assembling and interfacing.
Operating system (OS) installation: Windows 7.0, Linux; Software installation, Disk partitioning and formatting.
Operating system maintenance: OS protection, System restore, System crash repair, Local users and groups, Task manager, Registry, Security policies, etc.
Networking: Networking tools and topologies, TCP/IP, Implementation of a physical network, Introduction to wireless network, Network OS, Data sharing and security, Network printer installation and sharing, Mapping of network drive, Remote desktop, Net meeting.
Trouble shooting: Desktop, Laptop, Networks, Operating System, Printer and Fax.