Online Textbook for CET 4429 - Applied Database II

Section 1: Database Concepts Review 

• Database Tables
• Database Views, 
• Database Stored Procedures,
• Database Keys (Unique , Foreign)
• Database Indexes, 
• Using SQL  
• Database Design
  • Normal Forms
    • Boyce Codd Normal Form (BCNF)
    • Third Normal Form (3NF)
  • Entity Relationship Diagrams 

Section 2: Transactions and Concurrency Management

• Database Transactions
  • Concurrency Management in SQL Server
• Database ACID Test 
•  Database Concurrency

Section 3: Database Standards

• Extensible Markup Language (XML) 
• National Information Exchange Model (NIEM) 
• ADO, OLEDB, ODBC, JDBC standards

Section 4: Database User Interfaces

• Client-Server Database Systems 
•  

Section 5: Decision Support in Databases

• Decision Support Systems 
• Online transaction processing
• Online analytical processing
• Data warehouse