Week 3: 12 ITGS ( 21st to 29th August)

Teaching Plan:

P1.  &  P2. Database organization : Terms to be discussed

• TableField, data types, key field/primary key, secondary keyRecordFlat-file database, relational database, normalizationDatabase management systemSpecialized databases: for example, web databases, online encyclopedias 
  

P3. Database function

• Data validation: data types, range check, check digit, field size, input mask, drop-down list
  
• Queries: for example, searching, sorting, filtering, use of Boolean operators (AND, NOT, OR)
  
• Data entry form
  
• Report generation
  
• Macros
  
• Transfer of data between databases and other applications
  

P4. Case study - Forming of questions to be completed
P5. IA - Criteria A & B to be submitted ( Final)
P6. Assignment & doubts in case study


Keep Learning...