ADO.NET

Schedule Configurator

• Create MS ACCESS database file (with MS Access program) to store the following information
  • the list of the teachers
  • the list of the classrooms
  • teacher-to-classroom bindings which is additionally characterized by a 'day of week' and an 'hour'
    • more than one teacher can be bound to a classroom at the same time
    • a teacher can be bound to more than one classroom at the same time
  • the 'day of week' is a number from the range 0-6 (0-Sunday, 1-Monday, ..., 6-Saturday)
  • the 'hour' is a number from the range 0-23 (e.g. 14 means 14:00-14:59 period)
• Create Windows Forms application which allows
  • to add a new teacher, view teachers' list
  • to add a new classroom, view classrooms' list
  • to bind a teacher to a classroom at a specified day of week and hour
    
• As a binding interface DataGridView control should be used
  • teacher and classroom columns have to be a ComboBox control, which allows to choose single element from the proper list
  • the 'day of week' is limited in the range 1-5 (Monday-Friday)
    • in GUI the full names of the days should be displayed
  • the hour value is limited in the range 8-20
  • identical bindings are not allowed
  • incomplete bindings are not allowed
• The Save & show conflicts button
  • save modifications to the database file
  • show resource conflicts (there are two types of conflicts)
    • more than two teachers are bound to the same classroom at the same time (the first conflict on the list below)
    • a teacher is bound to more than two classrooms at the same time (the second conflict)
    

• Hints:
  • DataGridViewComboBoxColumn class, DayOfWeek enum
  • CellFormatting event (DataGridView control), CellValidating event (DataGridView control)

• Approximate points:
  • proper database file structure (including primary keys and foreign keys): 2.0
  • data loading and saving: 1.0
  • binding interface: 3.0
  • constraints enforcement: 2.0
  • conflicts view: 2.0