Assessment CIS 335 Database Management

1
Assessment CIS 335 Database Management
AnalysisHerb Schuette
Topics Database Environment and
Architecture Database Analysis and
design Database Implementation SQL Server,
ADO .NET , Oracle Data warehousing, mining,
reporting Database administration Object-oriente
d database development IS 2002.8 Physical design
Implementation with DBMS
2
Texts Hoffer, Prescott and McFadden, Modern
Database Management, Prentice-Hall, 6th ed,
2002 E. Petroutsos and A Bilgin, Visual Basic
.NET Database Programming Sybex,
2002 Software MS Access - Northwind and Hoffer
examples MS SQL Server- Enterprise manager,
Query Analyzer MS Visual Basic .NET Oracle
3
Goals/Objectives

• Understand the role and use of database
  management systems in a variety of organizations.
• Design and implement database systems, including
  table structures, data relationships, visual data
  access and SQL queries.
• E-R, Object data process models for design and
  analysis
• Develop skills for manipulation, reporting and
  analysis of large data repositories

4
Topics

• Organizational data environments
• Data modeling and analysis
• Architectures and technologies
• Physical database design and performance
• Data acquisition and front-end processes MS
  Access, VB and Web forms
• Data manipulation and analysis SQL and data
  query construction
• SQL Server, transact-SQL, ADO .NET
• Data aware controls in VB .Net, ADO .NET
• Database maintenance and administration
• Data security and privacy
• Reporting and data mining data marts and
  warehouses OLAP
• Distributed databases Client / Server
  Centralized repositories
• Web-based data management

5
AssessmentBased on class of six students

• Solid grounding in database analysis tools based
  on exercises in text and student presentations
  100
• Mixed results with VB and ADO programming wide
  discrepancy in core programming skills 50
• Use of VB environment for connection, query and
  modification of Access and SQL Server databases
  80
• Evaluation core concepts and analysis tools
  grounded in Hoffer material went well mixed
  results with db programming given weak VB skills
  for 50 of class