swdd

• Essential features of OOP inheritance:

  • Hierarchical organization
  • Code reusability
  • Method overriding
  • Enables polymorphism and encapsulation
• OOP model for inheritance includes single, multi-level, and hierarchical structures
• OOP enables polymorphism and encapsulation in programming
• Key values of Agile manifesto:

  • Individuals and interactions over process and tool use
  • Working software over comprehensive documentation
  • Customer collaboration over contract negotiation
  • Responding to change over following a plan
• Disadvantages of using the waterfall model in software development:

  • High risk factor
  • Can't accept requirement changes later
  • Expensive to backtrack
  • Risk reduction strategy is difficult to prepare
• Main difference between Abstract classes and Interface classes:

  • Abstract allows for implementation and override while interface does not
• Types of software product liability claims:

  • Manufacturing defects
  • Design defects
  • Failure to warn
  • Aftermarket defects
• Coding standard principles include:

  • Maintainability
  • Reduce the cost of software maintenance
  • Code conventions are not enforced by any compiler or IDE
• Coding standard practices:

  • Constants
  • Commenting
  • Indentation
• Good programming practices:

  • Clear purpose - any dev familiar with guides can follow along
  • Using standards to save money and time
  • Standardize early
  • Document every time standard is violated
  • Industry standards > organizational standards > project standards > no standards
• Situations when Agile should be used in software development:

  • When a highly qualified team is available
  • When frequent changes are required
  • When the project contains ambiguities in requirements
  • When the project is complex and takes time to develop
• 5 phases in the software development life cycle (SDLC):

  • Requirement collection
  • Design
  • Implement
  • Testing
  • Evolution
• 4 basic SQL Data Definition Language commands:

  • Create
  • Alter
  • Truncate
  • Drop
• 4 basic SQL Data Manipulation Language commands:

  • Select
  • Insert
  • Update
  • Delete
• Purpose of the database connection in programming:

  • To be a channel between the client and SQL server
• Database schema diagram shows:

  • Table, columns, primary keys, foreign keys, indexes, constraints
• Database column aliases are useful in calculations and programmatic data extraction