DBMS Module 2


Module 2 follows up in the topic covered in Module 1, introducing the topics of Gathering Requirements and Standards as they relate to defining a project plan. Entity Analysis is the process of identifying the types of data that needs to be tracked, which flow from gathering the requirements. The rest of the module concentrates on basic T-SQL concepts and coding skills, so that by the end of the module you should be able to create and populate your own tables.

Module Objectives

  • Learn how to evaluate a scenario to identify requirements and entities
  • Perform a basic Entity Evaluation to identify data sets and their relationships
  • Explore additional ways to structure the INSERT statement to build more specific queries
  • Create database tables and add rows to them with the INSERT statement