Lecture #2 - Specification Attributes, Good and Bad

Web Resources:

Office Hours: Instructor & TAs

Content:

1. Syllabus
   Describes topics to be covered, reading material for you to digest before coming to class, and due dates for the assigned projects.
2. Project #1
   
3. Creating SQL Server DB Programmatically
   Dusan Palider found this link and we think it may be useful for Project #1.
4. Product Model Scope   Breaking Down/Building Up  
5. Modules
   Much of the discussion in this lecture involves specifying and testing modules. If you need a refresher about modules, then look here.

6. Concept Development:   Project Center - Final Project, Fall 04

   Initial project concept development occurs before, or concurrently with, B-Level requirements development. Use Cases Are a key part of the concept development process. Here we show use cases prepared for the Final Project, Fall 04.
   • Project Center Packages
     
   • Project Center Use Cases
     Developing Use Cases is part of the project concept definition that is completed before beginning development of specifications. This presentation was developed for the Final Project, Fall 04.

7. Testing:

   The purpose of testing is to demonstrate that specifications are satisfied.
   • Test-Driven Development
     
   • Test Harness Structure
     
8. Specification and Architecture
   In this lecture we finish the specification topic by discussing C-Level specs, e.g., design documents.
9. SRS Quality Measures
   Discusses what makes a specification good or bad.

10. Help for Project #1

    Project #1 requires you to develop a DataLayer providing an object to relational mapping for all information stored in SQL Server. These notes will help you with that implementation.
    • References for Winform based SQL Server data access:
      Working with Databases in Asp.Net 2.0 and Visual Studio 2005
      Really simple binding of Access DB to Gridview without using wizards
      SilverLight2 Data-centric Applications
      Data-centric UI controls
      Connecting to SQL Server from Visual Studio
      Applying DataGridView on Winforms
      solving db update problems
      DataGridView Q&A
      DataGridView pdf
      
    • I've used the pubs and northwind sample databases, developed by Microsoft, for several of the class handouts. You can Download Northwind and Pubs databases from Microsoft, or find them on the college server here: handouts/cse784/code/sampleDBs.
    • Relational Data Model
      
    • Active Data Objects (ADO)
      
    • WinForm DB app Prototype
      
    • ADO Console Application Demo
      Simple demonstration of ADO with an Acess database.
    • Basic SQL Demos
      Slightly modified examples from .Net SDK Samples.
    • QuickStart Examples: ADO - Uses Asp.Net Platform
      
11. Software Design
    Discusses design attributes and how to judge their quality.
12. Basic Design Issues
    
13. Truely Awful Interface Design
    

---