Setting Up The Database

With a final idea decided on, the next step in the creation of our web application was to create the back end database for it. I began thinking about the table structure that would be required to achieve what we are looking for. So far, I have only identified two tables that would be required, but this may change as development continues.tumblr_nl3w2oqys81se0a2do1_1280

 

At the minute I only have a USERS table and a HOLIDAY table. The USERS table will allow users to create an account to store their detail, as well as login details so they can access their account. The HOLIDAY table will store data that the user inputs about a holiday. The one-to-many relationship of the tables will allow each user to create multiple entries about holidays, but each holiday entry can only be created and edited by one user.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s