|
|
(16 intermediate revisions by 2 users not shown) |
Line 1: |
Line 1: |
− | Group ''MNV'' of the Hitek School internship project
| + | == Music Database "Personal Music Collection" |
− | started their individual project ''"Music database"'' on May 25th, 2009.
| |
| | | |
− | ''Group consists of following members:''
| |
| | | |
| + | [http://wiki.services.openoffice.org/wiki/MusicDatabase/MNV/Team '''''Team'''''] |
| | | |
− | [http://wiki.services.openoffice.org/wiki/User:Marina_hitekschool Marina Kuznetsova] | + | [http://wiki.services.openoffice.org/wiki/MusicDatabase/MNV/Diary '''''Project Diary'''''] |
| | | |
− | [http://wiki.services.openoffice.org/wiki/User:Natalia_hitekschool Natalia Polioudova] | + | [http://wiki.services.openoffice.org/wiki/MusicDatabase/MNV/DatabasePresentation '''''Database Presentation'''''] |
− | | |
− | [http://wiki.services.openoffice.org/wiki/User:VladS_HitekSchool Vlad Seredkine]
| |
− | | |
− | PS. Vlad Seredkine separated after 4 weeks and began his own proect [http://wiki.services.openoffice.org/wiki/MusicDataBase_VS MusicDataBase VS]
| |
− | | |
− | | |
− | | |
− | | |
− | | |
− | '''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,<br> Spec (itterative)”.
| |
− | | |
− | <u>'''During this month we worked along the several main lines:'''</u>
| |
− | | |
− | 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 <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
| |
− | | |
− | | |
− | '''10 week (July 27 - August 2, 2009)'''
| |
− | * Discussed our further work
| |
− | * Complited user documentation
| |
− | * Started writing of test cases
| |
− | | |
− | | |
− | <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.
| |
| | | |
| | | |