Database – Entity Relationship Diagrams .2

design for digital media environments
php1

Users table

php2

Posts database table

Two tables: Users and posts

Data regarding the user is entered into the users table once signing up. Data such as username, name, password and email is stored. The posts table consists of information about the properties for example, house type, price, location, etc..the data will be called using php and jquery to display results on the web application.

Username and password are essential for logging in, the data will need to match to enable verification. This is important for security reasons. Each user is automatically assigned an identity number. This is similar with the properties listed, the id carries a time it was posted. The user id shows which user posted and at what time.

Frontend and backend technologies

design for digital media environments

Front end

– web design

– front end web development: html, css, javascript and jquery.

– things you see when using the web, including, font, drop down menus, contact forms, buttons and sliders, etc. However, in order for the data entered through the use of front end elements we need the back end to make this possible.

The front end development will be important when considering the user and userbility. Creating the best user experience possible. In this group project my role is to cover the front end. Considering the design and interface. I will need to consider user interactivity and design whilst practicing my skills in html, css and jquery to create a simple but effective web app that the audience will respond well to.

Back end

– Consists of a sever, an application and database.

– The application stores information into a database, which was created on a server.

– SQL, Ruby and Python are example of backend languages.

For our task we will be using phpmyadmin. The enhanced framework will help development and collaboration ease.When planning on how to go about the database we need to consider entity relational models.

erm

– database modeling method

– semantic data model of a system

– diagrams created through the use of this process are called entity relational diagrams, erds.

Entities – object or concept that is uniquely identifiable – represented as rectangles

Attributes – property of an entity or a relationship type- represented as ellipses

Relationships – meaningful association among entities – diamond shape connectors.

erd

ERD

Strong entity type when the entity doesn’t depend or on any other entity type.

– Important when creating web pages with forms in.

– Will be essential when setting up the database for our web app; to make a functioning user community.

– In order for users to be able to log in and input their own properties, a form will need to be created to which the data will then be stored in a database. Usernames and password will need to be kept in a separate table to allow users to log in once signing up.

– Weak entities such as user id or house ids will need to be relational in order for the house listing to be associated with the published user.

Change of plan

design for digital media environments

We have decided to change our initial idea from the dating website to a property site. We have decided this for a number of reasons:

– Compared to what we have learnt, a dating website is much more relative. We would need to reference and match details such as age, gender, height and interests which would be tricky. Especially, as this is all fairly new to the group it might be too much of a challenge.

–  Unlike property sites, dating websites are very broad and most examples vary quite a bit. This making research challenging as data is personal and difficult to match up, whereas property sites data would be very specific, allowing sort and filter interactions.

– Finally, the sheer amount of tables and links between them needed would be way too complicated for a first time in  handling data in a database. In our second meeting we tried creating an entitiy relational diagram however, the links were endless.

erd

dating site erd

I think we got a bit carried away with the endless possibilities and were worried we couldnt carry them out. As this task is concerned about functionality i feel the job site will be more successful.