Importing data from excel

Management of Data (adding/deleting/modifying: clients, teachers, courses)

Regulation of payments (installments)

Organizing conferences

Gathering information obtained on conferences

Organizing temporary residence for the conference members (booking rooms in hotels)

Storing information about invited professors (name, address, acceptation or rejection of the invitation)

Detailed information about courses (difficulty level, certificate, price)

Organizing certificated exams

1. Actors

1. MS SQL Server Administrator

2. System Administrator

3. Accountant

4. Secretary

5. Employee from Courses Department

6. Employee from Sign Up Department

7. Employee from Supply Department

8. Employee from Certifications Department

9. Employee from Conferences Department

2. Storage of data

1. Storage of Students data

1. Storing personal information

1. Storing name

2. Storing surname

3. Storing address

4. Storing cell phone number

5. Storing home phone number

6. Storing work phone number

2. Storing information about courses

1. Storing information about finished courses

2. Storing information about current courses

3. Storing information about certifications

1. Storing information about passed certification exams

2. Storing information about certification exams for which is signed up

4. Storing information about payments

2. Storage of Teachers data

1. Storing personal information

1. Storing name

2. Storing surname

3. Storing address

4. Storing cell phone number

5. Storing home phone number

6. Storing work phone number

2. Storage of information about courses he can teach

3. Storing information about payments

3. Storage of Staff data

1. Storing personal information

1. Storing name

2. Storing surname

3. Storing address

4. Storing cell phone number

5. Storing home phone number

2. Storing information about position

3. Storing information about payments

4. Storage of Rooms data

1. Storing capacity

2. Storing number of computers

3. Storing installed software

5. Storage of Courses data

1. Storing number of hours

2. Storing materials(handouts)

3. Storing certification information

4. Storing final exam information

5. Storing dates information

6. Storage of Exams data

1. Storing course information

2. Storing duration information

3. Storing Examiner information

4. Storing Participants information

5. Storing date information

6. Storing percentage passing

7. Storage of Conferences data

1. Storing Lecturer information

2. Storing Participants information

3. Storing subject information

4. Storing dates information

8. Storage of Certifications data

1. Certification info

1. Storing company

2. Storing percentage passing

2. Storing Participants information

1. Storing Participants that passed

2. Storing Participants that signed up

3. Storing date information

4. Storing lifetime of certificate

9. Storage of Hotels data

1. Storing address

2. Storing telephone number

3. Storing standard

3. Management of Data

1. Management of Students Data

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Students Data

2. Modifying Students Data

3. Deleting Students Data

2. Management of Teachers Data

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Teachers Data

2. Modifying Teachers Data

3. Deleting Teachers Data

3. Management of Staff Data

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Staff Data

2. Modifying Staff Data

3. Deleting Staff Data

4. Management of Rooms Data

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Rooms Data

2. Modifying Rooms Data

3. Deleting Rooms Data

5. Management of Courses Data

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Courses Data

2. Modifying Courses Data

3. Deleting Courses Data

6. Management of Exams

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Exam Data

1. Adding Examiner Data

2. Adding Participants Data

2. Modifying Exam Data

1. Modifying Examiner Data

2. Modifying Participants Data

3. Deleting Exam Data

1. Deleting Examiner Data

2. Deleting Participants Data

7. Management of Conferences

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Conferences Data

1. Adding Lecturers Data

2. Adding Listeners Data

2. Modifying Conferences Data

1. Modifying Lecturers Data

2. Modifying Listeners Data

3. Deleting Conferences Data

1. Deleting Lecturers Data

2. Deleting Listeners Data

8. Management of Hotels Data

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Hotels Data

2. Modifying Hotels Data

3. Deleting Hotels Data

9. Management of Certifications Data

1. Viewing

1. Browsing

2. Searching

2. Modifying

1. Adding Certifications Data

2. Modifying Certifications Data

3. Deleting Certifications Data

4. Certification Management

1. Certification Sing up

1. Sign Up

2. Cancellation of Sing Up

2. Communication with XXX Internet Certificatory Database as in 231/99

3. Preparing Certification Schedule

5. Payment Management

1. Confirmation of payments

1. Connection with bank as in 342/99

2. Checking account balance

3. Retrieving information about transfers

2. Installments Management

1. Connection with bank as in 342/99

2. Checking account balance

3. Retrieving information about installment transfers

4. Calculating remaining installments

3. Preparing payment reminders

4. Salary Management

1. Salary calculation

1. Base salary calculation

2. Tax Calculation

3. Health insurance calculation

2. Granting bonuses

3. Salary payment management

1. Standing order establishing(from company's account to employee's account)

6. Preparing and printing Reports

1. Preparing and printing order for supplies

2. Preparing and printing invoices

3. Preparing and printing remaining installments report

4. Preparing and printing schedules

1. Preparing and printing schedules for courses

2. Preparing and printing schedules for conferences

3. Preparing and printing schedules for certifications

5. Preparing and printing Financial Reports

6. Preparing and printing participants lists

1. Preparing and printing participants of courses lists

2. Preparing and printing participants of conferences lists

3. Preparing and printing participants of certifications lists

7. Management of conference Information

1. Preparing surveys

2. Retrieving surveys

1. Retrieving from participants

2. Preparation for storage

3. Storing surveys results

8. Invitation Module

1. Automatic invitation module

1. Preparing invitation

2. Manual module

1. Preparing

2. Modifying

3. Sending

4. Gathering replies

9. Conference Management

1. Conference Sign Up

1. Sign up

2. Cancellation of Sing up

2. Room Reservation Management

1. Viewing booked rooms

2. Booking

1. Connection with Orbis as in Orbis861/98

2. Checking for free rooms

3. Searching for alternative

4. Making reservation

3. Cancellation of reservation

4. Modification of booked rooms

3. Preparing Conference Schedule

10. Course Management

1. Course Sign up

1. Sign Up

2. Cancellation of Sing Up

2. Preparing Course Schedule

11. Importing data from Excel

1. Reading Excel files

2. Parsing Excel files

3. Preparing data for inserting to new system

4. Inserting data to new system

5. Validation of data in new system

12. Supplies organization

1. Preparation of orders

1. Preparation of food orders

2. Preparation of writing materials orders

2. Supply data management

1. Making inventory listings

2. Automatic display of warnings when some material runs out

3. Making changes in stock level

---