HitekSchool/Music Database/NLG
Group Music Database/NLG of the Hitek School internship project started in March 2009; Individual project started on May 25th, 2009 for 3 months.
Members of our team are:
Week 1 (25 May 2009- 31 May 2009)
1. During this week we familiarized ourselves with OOo database, including "Getting starting with Base" and “Beginners - Example Database - Base Tutorial”
2. We asked the base community for ideas, tips, hints etc. on mailing lists dev@dba.openoffice.org
3. We discussed some ideas regarding music data base (fields which could be present in it, relations between tables, etc.)
Week 2 (1 June 2009 - 6 June 2009)
1. Created draft of tables for Music Database
2. Created draft of music base design.
Week 3 (8 June 2009 - 13 June 2009)
1. Optimized set of the tables and relationships between them (design)
2. Created draft GUI (Form) for the Music Database.
3. Started to gathering data for the Database
Week 4 ( 15 June - 20 June 2009
1. Approved design of Music Database.
2. Gathering data for tables
3. Defined type of data.
Month 1 (25 May 2009 - 24 June 2009)
1. The month of our work on Music DataBase passed by and we can admit that while participating in several type of activities we became people working together cooperatively as a team in order to accomplish the common goal. As a result of our many discussions we developed design, GUI. Content of tables for our base is almost ready. During the month we were reading documentation, went trough several Base tutorial, exploring databases examples in purpose to optimize our ideas in simple but functional design. It took us a while to define relations between tables, type and length of data fields.
As we learnt from base documentation OOo Base offers choices for beginners, intermediate, and advanced users to create and modify tables, forms, queries, and reports,
using Wizards, Design Views, or SQL Views.
We as a team feel that we extract all theory needed for creation our database and we are ready to start developing.
Week 5 (22 June - 26 June 2009)
1. Created tables according to our specification.
2. Defined relationships between tables.
3. Made some correction to tables and specification.
Week 6 (29 June - 04 July 2009)During this week we were working on form creation.
We experienced difficulties making several subforms and looked for another method to create form using all tables. Despite many documents describing creation database we worked hard to find real help
(for example, no detailed help or tutorial about creating form in design view). Finally, we managed to make form for our database and we are working on style and filling data so far
7 week (July 6 - July 12, 2009)
1. Made some correction to created tables and their relationships. 2. Continued to work with forms and reports.
