Course Catalogue

Course Code: CSE 303
Course Name:
Database Management System
Credit Hours:
3.00
Detailed Syllabus:

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.

Course Code: CSE 305 / CSE 306
Course Name:
Algorithms
Prerequisite:
Credit Hours:
3.00
Detailed Syllabus:

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.

Course Code: CSE 307
Course Name:
Microprocessor and Interfacing
Prerequisite:
Credit Hours:
3.00
Detailed Syllabus:

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.

Course Code: CSE 309
Course Name:
Data Communication and computer Networking
Credit Hours:
3.00
Detailed Syllabus:

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.

Course Code: CSE 309
Course Name:
Data Communication and Computer Networks
Credit Hours:
3.00
Detailed Syllabus:

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.

Course Code: CSE 3101
Course Name:
Microprocessor and Microcontroller
Prerequisite:
Credit Hours:
3.00
Detailed Syllabus:

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.

Course Code: CSE 3102
Course Name:
Microprocessor and Microcontroller Lab
Prerequisite:
Credit Hours:
1.00
Detailed Syllabus:

Based on theory course.

Course Code: CSE 3103
Course Name:
System Analysis and Design
Prerequisite:
Credit Hours:
3.00
Detailed Syllabus:

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.

Course Code: CSE 311
Course Name:
Automated Office Management
Prerequisite:
Credit Hours:
3.00
Detailed Syllabus:

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.

Course Code: CSE 3120
Course Name:
Web Programming Lab
Prerequisite:
Credit Hours:
1.00
Detailed Syllabus:

Introduction to Web Technologies. HTML5, CSS3 with it’s new components. JavaScript, jQuery, AJAX. Data transmission, formats and processes. XML and JSON.

Pages