- Application works with data stored in a local SQL Server instance, a connection string to the database has to be easy modifiable (should be located in the application's configuration file)
- As a data source the Northwind database is used
- The application works in the disconnected scenario
- All employees are listed in the combobox in the left upper corner of the form, both the first name and the last name are displayed
- Below the combobox, detailed information are presented: First name, Last name, Title, Birth date and Superiors
- Fields for First name, Last name, Title and Birth date are editable, changes have to be visible in the application's GUI and persisted in the database after application closure
- Superiors are all other employees related, directly or indirectly, through "ReportsTo" field
- Photo stored in "Photo" field is displeyed in right upper corner of the form (see hint below)
- At the bottom of the form list of all orders related with selected employee are presented
- All columns except "Value" come from "Orders" table
- "Value" is an aggregated value of a single order, technically it is a sum of order details ("Order Details" table) for given order (OrderID), where value of each detail is calclated as UnitPrice*Quantity*(1-Discount)
- All rows with value greater than 1000 have modified background color
- combobox with employees: 2.0
- detailed informations (including superiors): 2.0
- photo: 1.5
- order list: 4.5