Module 1: DATA AND PROCESS MODEL
Module 2: MASTER TABLES AND PAGES
Module 3: DOCUMENTS
Module 4: POSTING
Module 5: FEATURE INTEGRATION
Module 6: REPORTING
Module 7: STATISTICS
Module 8: DIMENSIONS
Module 9: ROLE TAILORING
Module 10: INTERFACES
Module 11: WEB SERVICES
Module 12: TESTING AND DEBUGGING
Module 13: SQL SERVER OPTIMIZATION
- Lesson 1: SQL Server for Microsoft Dynamics NAV
- Lesson 2: Representation of NAV Tables and Indexes in SQL Server
- Lesson 3: Collation Options
- Lesson 4: SQL Server Query Optimizer
- Lesson 5: SQL Server Query Optimizer
- Lesson 6: Data Access Redesign
- Lesson 7: C/AL Database Functions and Performance on SQL Server
- Lesson 8: Bulk Inserts
- Lesson 9: Locking, Blocking, and Deadlocks
- Lesson 10: SIFT Data Storage in SQL Server
- Lesson 11: SQL Server Profiler
Lesson 2: Registrations
Registrations : CRONUS International Ltd. organizes seminars, and requires functionality that lets users schedule seminars and manage seminar registrations. Now that you have developed the tables and pages for managing master data for seminars, you must develop the functionality that lets users manage seminar registrations, their primary type of transactions.
Users must be able to schedule seminars to occur at a specific time, in a specific seminar room, and to be delivered by a specific instructor. For each scheduled seminar, users must be able to register participants. The most intuitive way to deliver such functionality is documents.Microsoft Dynamics NAV.
The CRONUS International Ltd. functional requirements define the seminar scheduling functionality as follows:
- Users must be able to schedule seminars. Each seminar has a starting date, an allocated seminar room, an assigned instructor, the minimum and the maximum participants, and the price. The minimum participants and the price information are always taken from the seminar master record. The maximum participants are taken as the lower number of maximum participants of the seminar and maximum participants of the room.
- A seminar cannot be scheduled in a room that cannot hold at least the minimum number of participants for the seminar.
- For each scheduled seminar, users must enter additional comments, such as necessary equipment, or other special requirements.
- It must be possible to assign additional expenses to a scheduled seminar, such as catering expenses or equipment rentals.
These functional requirements indicate that each scheduled seminar is a piece of information separate from the seminar. For scheduled seminars, information from multiple tables is referenced. There is also specific subsidiary information for seminars. This includes seminar expenses and comments.
Additionally, the functional requirements define the registration functionality as follows:
- Users must be able to register one or more participants for scheduled seminars. For each registered participant, it must be possible to specify if additional expenses must be invoiced for this registration. The default is Yes.
- If the room maximum capacity exceeds the maximum participants that are defined for the seminar, then the user who maintains registrations can decide to register more participants up to the room’s maximum capacity. Users must be clearly warned if they are registering participants over the maximum number of participants for the seminar.