Difference between revisions of "MusicDatabase/MNV/Diary"
From Apache OpenOffice Wiki
| Line 1: | Line 1: | ||
== Project Diary == | == Project Diary == | ||
| − | |||
| + | '''1 week (25 - 31 May, 2009)''' | ||
| − | |||
| + | This week we shared our ideas and discussed a concept of intended database. | ||
| − | |||
| + | '''2 week (1 - 6 June, 2009)''' | ||
| − | |||
| − | + | During the week we were reading documentation, exploring OOO database and thinking about various options of future database structure. We have made a choice of one of them and began to work on it with purpose to realize it in OO database application. | |
| + | We have created working database structure (graphic diagram with 9 tables). Week finished in progress of final changes in database structure and final determination of data types in the tables fields. | ||
| − | |||
| − | + | '''3 week (June 8 - 14th, 2009)''' | |
| − | + | ||
| − | + | ||
| + | * Continued to explore OOo Base | ||
| + | * Discussed external and internal design for the intended Music database | ||
| + | * Discussed business requirements for the intended Music database | ||
| − | |||
| − | + | '''4 week (June 15 - 21th, 2009)''' | |
| − | + | ||
| − | + | ||
| + | * Continued to explore OOo Base | ||
| + | * Made a draft copy of Database Requirement Specification | ||
| + | * Shared our final thoughts on first approach to the database structure and functionality | ||
| − | + | == The 1st month résumé. == | |
| − | + | ||
| − | + | ||
| − | During this month we worked along the several main lines: | + | |
| + | Our assignment for the first month was “orientation, ideas, concept, design,<br> Spec (itterative)”. | ||
| + | |||
| + | <u>'''During this month we worked along the several main lines:'''</u> | ||
1. Familiarized ourselves with OOo database, how it works: | 1. Familiarized ourselves with OOo database, how it works: | ||
| − | Creating a New Database | + | :* Creating a New Database |
| − | Working with Tables | + | :* Working with Tables |
| − | Working with Queries | + | :* Working with Queries |
| − | Working with Forms | + | :* Working with Forms |
| − | Creating Reports | + | :* Creating Reports |
| − | Menus | + | :* Menus |
| − | Toolbars | + | :* Toolbars |
| − | 2. Familiarized ourselves with accessible tutorials in order to | + | |
| − | learn how to work with Ooo Base | + | 2. Familiarized ourselves with accessible tutorials in order to <br/> learn how to work with Ooo Base |
| + | |||
| + | 3. Discussed orientation and concept of our future database | ||
| + | |||
| + | 4. Discussed desirable database features and possible outputs | ||
| + | |||
| + | 5. Discussed business requirements for the intended Music database | ||
| + | |||
| + | 6. Familiarized ourselves with competitive products | ||
| + | |||
| + | 7. Designed a set of tables and their relations | ||
| + | |||
| + | 8. Thought over supposed database functionality | ||
| + | |||
| + | 9. Discussed external and internal design | ||
| + | |||
| + | 10. Created a draft of database requirement specification | ||
| + | |||
| + | 11. Explored the OOo Base | ||
| + | |||
| + | |||
| + | <u>'''As a result of our activity we obtained:'''</u> | ||
| + | |||
| + | * some knowledge about working with OOo Base | ||
| + | * the image, structure, and functionality of intended Music database | ||
| + | * realization that creation of good Music database needs more knowledge and skills | ||
| + | * endorsement of a brainstorm and communication importance | ||
| + | |||
| − | + | <u>'''Our deliverables:'''</u> | |
| − | + | * A database structure scheme in a first edition | |
| + | * A description of tables – fields, field types, and relations | ||
| + | * A draft of product requirement specification | ||
| − | |||
| − | + | '''5 week (June 22 - 28th, 2009)''' | |
| − | + | * Have prepared a monthly resume | |
| + | * In the process of the affirmation of our database structure we have found <br/> that we still have had two incompatible platforms. In order to break this deadlock <br/> we splitted into 2 undependent groups. | ||
| + | * This page is maintained by Marina and Natalia. | ||
| + | * We completed our database structure changing for now and will create real database basing on it. | ||
| − | |||
| − | + | '''6 week (June 29 - July 5, 2009)''' | |
| − | + | * Were working with external and internal documentation for music database | |
| + | * Created "sample" of our database with tables and relationships | ||
| + | * Created some forms and reports | ||
| − | |||
| + | '''7 week (July 6 - July 12, 2009)''' | ||
| − | + | * Were working with documentation | |
| + | * Explore some OOo Base functionalities | ||
| + | * Were working with new DB functionality | ||
| + | * Were working with Forms and Queries | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | '''8 week (July 13 - July 19, 2009)''' | |
| − | + | * Designed and decorated entry forms | |
| − | + | * Made insignificant changes in the structure of database | |
| − | + | * Created several required Queries | |
| − | + | '''9 week (July 20 - July 26, 2009)''' | |
| − | + | * Continued to work with entry forms | |
| − | + | * Designed and debugged needed queries | |
| − | + | * Created planned reports | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | |||
| − | + | == The 2nd month résumé. == | |
| − | + | ||
| − | + | ||
| − | |||
| − | + | Our assignment for the second month was “realization” of designed database. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | <u>'''During this month we worked along the several main lines:'''</u> | |
| − | + | 1. Obtained knowledge how to work with Ooo Base | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | 2. Explore how to create SQL queries and reports in OOoBase environment | |
| − | + | ||
| − | + | ||
| + | 3. Changed some database features and possible outputs | ||
| − | + | 4. Explore competitive products | |
| − | + | ||
| − | + | 5. Made some changes in a set of tables and their relations | |
| − | + | 6. Thought over arisen problems in database functionality | |
| − | + | 7. Realized Forms, Queries and Reports according to external and internal design | |
| + | 8. Iteratively changed database requirement specification | ||
| − | |||
| − | + | <u>'''Our deliverables:'''</u> | |
| − | + | * A database structure scheme | |
| + | * A description of tables – fields, field types, and relations | ||
| + | * DB requirement specification | ||
| + | * Realized DB,containing Data Entry forms, Queries and Reports for outputs. | ||
| − | |||
| − | + | '''10 week (July 27 - August 2, 2009)''' | |
| − | + | * Discussed our further work | |
| + | * Completed user documentation | ||
| + | * Started writing of test cases | ||
| − | + | '''11 week ( August 2 - August 9, 2009)''' | |
| − | + | * Discussed TCS | |
| − | + | * Reviewed user documentation | |
| − | + | * Continued writing of test cases | |
| − | + | * Debugged our MDB | |
| − | + | '''12 week ( August 10 - August 16, 2009)''' | |
| − | + | * Continued working with documentation | |
| − | + | * Debugged our MDB | |
| − | + | ||
| − | |||
| − | + | '''13 week ( August 17 - August 23, 2009)''' | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | * Testing of assigned database | |
| − | + | * Working with provided documentation | |
| − | |||
| − | + | '''14 week ( August 24 - August 30, 2009)''' | |
| − | + | ||
| − | + | * Finished testing of assigned database | |
| − | + | == The 3rd month résumé. == | |
| − | + | ||
| − | + | ||
| − | + | September 06th | |
| − | + | During this month our group: | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| + | * Created TCS for our database | ||
| + | * Were completing our internal and user documentation | ||
| + | * QA a foreign project and wrote a bug list | ||
| + | * Received our database bug list and were fixing bugs | ||
| + | * Were preparing our database presentation. | ||
Revision as of 05:20, 9 September 2009
Project Diary
1 week (25 - 31 May, 2009)
This week we shared our ideas and discussed a concept of intended database.
2 week (1 - 6 June, 2009)
During the week we were reading documentation, exploring OOO database and thinking about various options of future database structure. We have made a choice of one of them and began to work on it with purpose to realize it in OO database application.
We have created working database structure (graphic diagram with 9 tables). Week finished in progress of final changes in database structure and final determination of data types in the tables fields.
3 week (June 8 - 14th, 2009)
- Continued to explore OOo Base
- Discussed external and internal design for the intended Music database
- Discussed business requirements for the intended Music database
4 week (June 15 - 21th, 2009)
- Continued to explore OOo Base
- Made a draft copy of Database Requirement Specification
- Shared our final thoughts on first approach to the database structure and functionality
The 1st month résumé.
Our assignment for the first month was “orientation, ideas, concept, design,
Spec (itterative)”.
During this month we worked along the several main lines:
1. Familiarized ourselves with OOo database, how it works:
- Creating a New Database
- Working with Tables
- Working with Queries
- Working with Forms
- Creating Reports
- Menus
- Toolbars
2. Familiarized ourselves with accessible tutorials in order to
learn how to work with Ooo Base
3. Discussed orientation and concept of our future database
4. Discussed desirable database features and possible outputs
5. Discussed business requirements for the intended Music database
6. Familiarized ourselves with competitive products
7. Designed a set of tables and their relations
8. Thought over supposed database functionality
9. Discussed external and internal design
10. Created a draft of database requirement specification
11. Explored the OOo Base
As a result of our activity we obtained:
- some knowledge about working with OOo Base
- the image, structure, and functionality of intended Music database
- realization that creation of good Music database needs more knowledge and skills
- endorsement of a brainstorm and communication importance
Our deliverables:
- A database structure scheme in a first edition
- A description of tables – fields, field types, and relations
- A draft of product requirement specification
5 week (June 22 - 28th, 2009)
- Have prepared a monthly resume
- In the process of the affirmation of our database structure we have found
that we still have had two incompatible platforms. In order to break this deadlock
we splitted into 2 undependent groups. - This page is maintained by Marina and Natalia.
- We completed our database structure changing for now and will create real database basing on it.
6 week (June 29 - July 5, 2009)
- Were working with external and internal documentation for music database
- Created "sample" of our database with tables and relationships
- Created some forms and reports
7 week (July 6 - July 12, 2009)
- Were working with documentation
- Explore some OOo Base functionalities
- Were working with new DB functionality
- Were working with Forms and Queries
8 week (July 13 - July 19, 2009)
- Designed and decorated entry forms
- Made insignificant changes in the structure of database
- Created several required Queries
9 week (July 20 - July 26, 2009)
- Continued to work with entry forms
- Designed and debugged needed queries
- Created planned reports
The 2nd month résumé.
Our assignment for the second month was “realization” of designed database.
During this month we worked along the several main lines:
1. Obtained knowledge how to work with Ooo Base
2. Explore how to create SQL queries and reports in OOoBase environment
3. Changed some database features and possible outputs
4. Explore competitive products
5. Made some changes in a set of tables and their relations
6. Thought over arisen problems in database functionality
7. Realized Forms, Queries and Reports according to external and internal design
8. Iteratively changed database requirement specification
Our deliverables:
- A database structure scheme
- A description of tables – fields, field types, and relations
- DB requirement specification
- Realized DB,containing Data Entry forms, Queries and Reports for outputs.
10 week (July 27 - August 2, 2009)
- Discussed our further work
- Completed user documentation
- Started writing of test cases
11 week ( August 2 - August 9, 2009)
- Discussed TCS
- Reviewed user documentation
- Continued writing of test cases
- Debugged our MDB
12 week ( August 10 - August 16, 2009)
- Continued working with documentation
- Debugged our MDB
13 week ( August 17 - August 23, 2009)
- Testing of assigned database
- Working with provided documentation
14 week ( August 24 - August 30, 2009)
- Finished testing of assigned database
The 3rd month résumé.
September 06th
During this month our group:
- Created TCS for our database
- Were completing our internal and user documentation
- QA a foreign project and wrote a bug list
- Received our database bug list and were fixing bugs
- Were preparing our database presentation.
Please do not change the logical content of this site without acknowledge of the author or the OOo QA Project Lead/Co-Leads.
