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.

Access to MySql - downloaded

Today i downloaded the program Access to MySQL to my computer from http://www.bullzip.com/download/a2m/msa2mys_3_0_0_108.zip then i installed it. But when i finished the wrote a message that says that in order to make it running fine it requires the MySQL ODBC Drivers for windows. So i made another search on the internet and i downloaded MYSQL Connector/ODBC 5.1 ,Windows MSI Installer (x86). WELL!! that was not the end. They asked me to register in order to be able to use it. So im waiting for the approval to be able to download the drivers. hope me luck!!!

Access to MySql

Now im searching on how to transform the access database to mysql. Im not sure if in this process i will be able to transfer the quieries as well as the tables. I found a program called access to mysql and now im trying to use it.

XAMPP Package Download

Yesterday I downloaded XAMPP Windows 1.7.1 that contains PHP, MySQL and Apache HTTPD 2.2.11. I installed XAMPP on c:\xampp, but I faced a problem with apache service which was not able to start. I found that the port that the appache is trying to use is already in use from the IIS, since I was working with ASP in my last project. To solve this problem I stopped the IIS service in order to free this port. I also found in the Internet that there is another solution which is either to change the IIS port or to change the apache port in httpd.conf file under apache/conf/ folder. Now the package is working. So I oppened the XAMPP Control Panel in which I can stop and start the Apache and MySQL. To test that PHP is working, I searched the XAMPP root directory, then I opened the htdocs folder in which we will have to store our php files, then I created a test php page using dearmweaver. In the address bar I wrote http://localhost/test.php and the page that I did appeared. Now I will try to experiment more on this package. I also have to learn how to use MySql to create the Database.

"Store your information project"

Today our group met in the morning to discuss the project. We will devide the work between us and I will be the leader. Tomorrow we are going to the library to borrow some books. We will also try to install the XAMPP package on our labtops.

about me

Hi i am Hamda, a sophomore at Dubai Women's College. I would like to present some of my personality traits. I am a hardworking person who can bear pressure and manage to finish things in due time .

I am also an independent, self-confident girl who is ready to face challenges and reach my good no matter what the diffuclties are . I hate weakness and hesitation in people. I appreciate a lot perfection in doing things and punctuality in keeping up with appointments and deadlines. In addition, I have a taste for fine and luxurious things and I always want to get the best .