|
|
(13 intermediate revisions by one other user not shown) |
Line 1: |
Line 1: |
− | Group ''VS'' started inside ''MNV'' of the Hitek School internship project
| + | ┼┼┼┼ "MELOMAN" Music Database by [[User:VladS_HitekSchool|Vlad Seredkine]] ┼┼┼┼ |
− | started individual project ''"Music database"'' on May 25th, 2009.
| + | |
| | | |
− | ''Group consists of following members:'' from June 25, 2009
| |
| | | |
| + | Available: '''[[MusicDataBase_VladS/Diary|Project Diary]]''' |
| | | |
− | [http://wiki.services.openoffice.org/wiki/User:VladS_HitekSchool Vlad Seredkine] | + | Available: '''[[MusicDataBase_VladS/Presentation|Database Presentation]]''' |
| | | |
− |
| |
− |
| |
− |
| |
− |
| |
− | '''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.
| |
− | * I completed our database structure changing for now and will create real database basing on it.
| |
− |
| |
− |
| |
− | '''6 week (June 29 - July 4, 2009)'''
| |
− |
| |
− | * Created Data Base according to database strutcture design
| |
− | * Created preliminary Entry tables
| |
− | * Inputed and verified real information for few music CDs
| |
− | * Changed Data Base tables according to entering practice problems.
| |
− |
| |
− |
| |
− | '''7 week (July 5 - July 11, 2009)'''
| |
− |
| |
− | * Continued creating Music Data Base with real information
| |
− | * Fixing Entry tables for better and convinient style
| |
− | * Added new real information in Data Base thru Entry Forms
| |
− | * Created first form of queries.
| |
− |
| |
− | '''8 week (July 12 - July 18, 2009)'''
| |
− |
| |
− | * Continuied queries and form creation
| |
− | * Continued fixing Entry tables for better and convinient style
| |
− | * Added new information in Data Base thru Entry Forms
| |
− | * Created first drafts of documentation according created Data Base.
| |
− |
| |
− | '''9 week (July 19 - July 25, 2009)'''
| |
− |
| |
− | * Final adjusting entry forms during input new real data;
| |
− | * Final correction data base tables and data base strutcture during fixing mistakes
| |
− | * Created some queries and report with real data loaded in data base
| |
− |
| |
− |
| |
− |
| |
− | == The 2st month resume. ==
| |
− | June 26 - July 25, 2009
| |
− |
| |
− | During this month I have realised the following:
| |
− |
| |
− | 1. Started and finished real data base according to accepted concept:
| |
− |
| |
− | 1.1. Created all required tables and adjusted all table fields;
| |
− |
| |
− | 1.2. Created all GUI entry form;
| |
− |
| |
− | 1.3. Tested by entering real information and adusted all fields of GUI entry forms to make them more convinient and professional
| |
− |
| |
− | 2. Entered data of more then 100 music items of 10 real audio CDs;
| |
− |
| |
− | 3. Entered data of about 30 music albums;
| |
− |
| |
− | 4. Entered data of more then 100 music creators: full information for music items on 10 CDs;
| |
− |
| |
− | 5. Created several queries and report based on data which data base already has;
| |
− |
| |
− | 6. Started to create final documentation.
| |
− |
| |
− |
| |
− | Second month resume:
| |
− |
| |
− | Created new Music Data Base.
| |
− |
| |
− | Tested and fixed all Data Base components.
| |
− |
| |
− | Entered full information for 10 real Audio CDs.
| |
− |
| |
− | Created several queries and report base on real information.
| |
− |
| |
− | Volume of whole Data Base reached 15MGb
| |
| | | |
| ''Please do not change the logical content of this site without | | ''Please do not change the logical content of this site without |
− | acknowledge of the author or the [http://wiki.services.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads].'' | + | acknowledge of the author or the [[Project_Lead|OOo QA Project Lead/Co-Leads]].'' |
| [[Category:HitekSchool]] | | [[Category:HitekSchool]] |
− |
| |
− | '''10 week (July 26 - August 1, 2009)'''
| |
− |
| |
− | * Continued work with documentation
| |
− | * Created test cases
| |
− | * Started testing according to test cases
| |
− | * Continued work with User's Guide
| |
− |
| |
− | '''11 week (August 2 - August 8, 2009)'''
| |
− |
| |
− | * Finished Internal Design Specification
| |
− | * Continued testing according to test cases
| |
− | * User's Guide almost done
| |
− |
| |
− | '''12 week (August 9 - August 15, 2009)'''
| |
− |
| |
− | * Finished User's Guide
| |
− | * Finished testing according to test cases
| |
− | * Continued testing on Database volume
| |
− |
| |
− | '''13 week (August 16 - August 22, 2009)'''
| |
− |
| |
− | * Created test cases for foreign Music Database
| |
− | * Tested foreign Music Database
| |