CSE205 DATABASE MANAGEMENT & PROGRAMMING

2 Hours/Week, 2 Credits

Computer Basics: Concept on Computer Hardware, Software and its classification, networking and Internet. Introduction to Database: Database Management System, Relational Database Management System, Entity-Relationship Model, Relational Model, SQL, Sorting, Indexing, Integrity Constraints, Transaction Concept, Database System Architecture. Database Management: Creating a Database, opening a Database, modifying a Database, modifying a Database Structure, Indexing, Sorting, searching a Database, designing a Customer Screen, designing a Report, Designing a Menu. Database Programming: Programming concept, A Simple Program, Memory variables, Constants, Operators, Commands, Arrays, Macros, Different Type of Processing, Procedures, Functions. Programming for Data Entries, Update, Report, Menu and Searching.