Databases

Selima Optique e-Commerce Web Application

In the database design course I designed and implemented an e-commerce website supported by a MySQL database of relational tables. I also learned PHP in this course, which has shorten the learning curve when I begin with object-oriented programming. In the final presentation pdf you will see the final table structure for the “eryn” database. The database includes five tables -- style, frame, user, press, color -- and three views --style_press, style_user, style_frame--which supplant the use of junction tables in my web application.

Note that I used several kinds of data types in the database tables, I also used foreignkeys, and indices. But this is not used in the application right now, it was merely an exercise. I didn't spend a lot of time putting in information into the table because it is pure drudgery.

I used several time saving tricks to add sophistication and security to my web application. Included are a function that generated forms specified by at $form_type argument. Included files build the header, footer and page navigation as well as a file that connects to the database, checks the database connection, reports user friendly errors when necessary and writes mysql_errrors to a log that can be viewed by the webmaster only.

In the database design course I designed and implemented an e-commerce website supported by a MySQL database of relational tables. Understanding database design will aid in the study of large information systems built on database management systems. I also learned PHP in this course, which will shorten the learning curve when I begin with object-oriented programming.

Launch the Site