Project done!!

Yesterday we met in my house and we finshed everything we had to do. Every girl explained to the other everything she did in her field of expertise. I think we did a great job and now we are preaparing for the oral defence. Each girl is doing the slides that correspond for her part in the project. I am doing the part of the database design and why we split the table into two other tables and how we made the normalization and how we created other tables.

Test and Review

On Suturday i will meet the group members and we will test and review the website. We still have some errors and some of the queries are not giving the results we want. So i hope that by Suturday we will have our project done.

Forms and Reports!!!

We worked very hard all the last week doing the forms in php for the website. It was my friend alia's job but we found out that its a huge work and we need to finish it so I helped her a little using the php wizard to do the add, delete and view queries. We also did the screen shots for the website so we can use them in the functional specifications and in the oral defence. Now we are in the testing process. I hope we don't have a lot of mistakes because we did this project in a very short time...

Bookmark

Today Im doing the quiries on MySql that my friend Alia will use on the web site. I found out after a LOT of search that in order to make a quiery in MySql I have to click on the SEARCH tab in MySql then I choose the conditions that i want then I save the quiery as a BOOKMARK. Tomorrow I will meet with my team members and we will work togother so we can exchange the files and figure out what to do next. I think we did a good job till now and that we are organized so we will do a good project.

tables created!!!

Today i finished creating the tables of our database. We desided to have 6 tables and we think this will be a good design for the database. Now im still trying to connect the tables with each others and make the realations. I also need to figure out how to make the queries on MySql.

Split employees table

I spent the whole last week reading the site http://mikebernat.com/blog/Setting-Up_a_Relational_Database_in_MySQL and trying the things that it explained on MySql. At the beginning it was very difficult because it's defferent than Access. But now i managed to split the exesting table (Employees) into other two tables. So now I have three tables: Employees, Departements, Job titles.

Now i will have to normalize the tables so i delete duplicate fields. It was a hard work, but it's worth it!!!!! Now I want to create new tables depending on the functional specification that my friend Hessa will make.

Also I should give the database when i finish it to my friend Alia so dhe can write php code to show the tables on a web page. This is a very complecated work and it is soooooo interrelated so we should focus and work as a team.

Database Successfuly Imported

Today I started the MS Access to MySQL application and followed the wizard to export the database. I selected the source mdb file and selected the tables to be imported to MySQL. Now my table is on MySql and Im ready to build the database depending on my friends analysis on what tables we will add and how we will split the employees table.