Sybullus of DBMS

DBMS
Introduction
• Introduction to database and DBMS
• Application development without a database
• Advantages of the DBMS approach
• Components of a DBMS
• Classification of DBMS
Database Design
• Identifying user requirement
• Logical data modeling
• Introduction to E-R diagram
• Components of E-R diagram (entities, attributes, relationship)
• Designing systems with E-R diagram
• Components of class diagrams
• Designing system with class diagrams
• Domains
Data Normalization
• Introduction
• Tables, Classes and Keys
• The need of normalization
• First, second and third normal forms
• Beyond third normal form
• Data rules and Integrity
• The effect of business rules
• Converting class diagram to normalized table
• Data dictionary
Introduction TO SQL-Simple Queries
• Components of a query
• Query basics
• The SELECT command
• Totals and sub-totals-GROUP BY and HAVING
• Computation, Aggregation function
• Working with multiple table-JOINS
Advances Queries
• Advanced queries and sub queries
• Sub queries with ANY, ALL, NOT IN etc.
• Different types of Joints (Inner Join, Outer Joins, Reflexive Joins, Inequality Joins etc.)
• UNION, INTERSECT, EXCEPT
• SQL DDL command (CREATE TABLE, ALTER TABLE, DROP etc)
• SQL DML command (INSERT, DELETE, UPDATE, etc)

Forms and Report
• Introduction
• Effective design of forms and report
• Form Layout
• Creating Forms
• Reports

Data Manipulation
• Introduction
• Procedural language
• Programming environment
• Data on Forms
• Using programs to save and retrieve data in the database
• Handling error
Application Development
• Why application ?
• Application Structure
• User interface features
• Transactions
• Forms to help user
• Custom reports
Database Administration
• Database administration
• Database administrator (DBA)
• Database tasks by development stages
• Backup and recovery issues of database
• Security and privacy issued to database

Practical: There shall be lab exercises covering all features of the above syllabus
Book: Database Management Systems by Gerald V. Post, McGrawhill