• Present an early introduction to SQL queries.
• Use a “spiral approach” (as discussed below) to database design.
• Use a consistent, generic Information Engineering (IE) Crow’s Foot E-R diagram notation for data modeling and database design.
• Provide a detailed discussion of specific normal forms within a discussion of normalization that focuses on pragmatic normalization techniques.
• Use current DBMS technology: Microsoft Access 2010, Microsoft SQL Server 2008 R2, Oracle Database 11gRelease 2, and MySQL 5.5.
• Create Web database applications based on widely used Web development technology.
• Provide an introduction to business intelligence (BI) systems. • Discuss the dimensional database concepts used in database designs for data warehouses and OnLine Analytical Processing (OLAP).