MusicDataBase VladS/Diary
Group VS started inside MNV of the Hitek School internship project started individual project "Music database" on May 25th, 2009.
Group consists of following members: from June 25, 2009
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
[edit] 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. 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
[edit] The 2nd 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
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 14 week (August 23 - August 29, 2009)
Finished testing foreign Music Database according to test cases [edit] The 3rd month resume. July 26 - September 5, 2009
During this month I have realised the following:
1. Created test cases for database testing;
2. Started and finished database testing according to test cases;
3. Finished and after database testing made correction of Internal Design Specification;
4. Completed User's Guide;
5. Created various queries and reports;
6. Created test cases for foreign database testing;
7. Started and finished database testing according to test cases;
8. Continued testing music database for volume:
8.1. Entered data of more then 300 music items of 25 real audio CDs and albums;
8.2. Entered data of about 70 music albums;
8.3. Entered data of about 300 music creators: full information for music items of 25 CDs and albums;
Third month resume:
Tested new Music Data Base.
Made correction of Database component.
Made correction of Database documentation based on database testing.
Entered full information for 25 real Audio CDs and albums for volume testing.
Created more several queries and report base on real information.
Volume of whole Data Base reached 46 MGb
