Web Development Homework Help Service

The main way people interact with computers currently is via the web, either on desktop or mobile as many mobile applications are just a thin wrapper around a web page. Cloud computing is the generic name for programs that run on web servers rather than running locally on the device. Amazon is very active in providing cloud services with easy to use servers that are available globally and providing services such as S3 which is used for providing distributed file storage.

Django for Web Development Assignment

The main framework in Python is Django, and has an easy to use ORM (object-relational mapper), an automatic admin, support for migrating changes to the database, user support with strong password hashing (to ensure that you don’t leak passwords). Django is very modular and easy to expand, with lots of modules already available for dealing with integration with a bunch of web services, blog support, etc. Django also has a template language that allows you to mix HTML with the loops to process your data, so you can write a page that loops over all the results to display in a tabular form.

HTML is the basic language of the internet, it stands for HyperText Markup Language. Universities in the USA, Canada, and Australia have been focussing on web development assignments using Django. Lately, a lot of students have been seeking help with web development homework in the Django framework.

HTML for Web Development Homework

You can view the source of the web page to view the HTML and you will find it is very simple, with commands inside < > to deal with things like headings, bold, italics, or image and links which have additional options that give the details of the address to go to, or the source of the image data.

ASP and AJAX as a tool for Web Development

ASP is Microsoft’s attempt at a web development language, it stands for Active Server Pages and allows you to mix static HTML with data that is provided by the server.

AJAX is Asynchronous Java and XML, although it tends to actually be JSON rather than XML. Students with single page web development homework generally ask to get it done in AJAX. You send a request to the server and then change some of the HTML on the page with the result. This allows you to view a message in Gmail without having to reload the web page for example.


Javascript a Strong Tool at User End

Javascript is the programming language of the internet (at least on the user’s end). It is NOT based on Java, despite the name, and has some features that many would consider to be insane, see multiple web pages for some of the WTFs.

CSS is Cascading Style Sheets, it controls the look of the web page. By merely changing the CSS and leaving the HTML exactly the same, you can completely change the look of a web page. You could use 2 different CSS pages for a web page, and offer a dark or light mode.


Assistance with Web Development Assignment using PHP

PHP is HyperText Preprocessor, and mixes code and HTML freely together which can lead to very hard to change web pages if not done carefully and that is the reason students avail help in doing their web development homework in PHP.


Jquery one of the Biggest Javascript Library

Jquery is probably the biggest Javascript library, and simplifies access to the web page with $ used to access elements by name, or class. It offers the facilities that deal with AJAX, updates to the web page, and allows you to easily interact with the page by changing the events, so if you want to make it so that clicking a link brings up a dialog box first you can do.

Web Development Assignment Help using PHP and MySQL

1. Developing and Testing Environment

Figure Drawing Software Microsoft Visio 2013
MySQL Server version 5.x (from XAMPP)
MySQL client-side tool PHPMyAdmin (from XAMPP)
Web server and PHP module XAMPP Portal
Web Browser Google Chrome v79
Operating System Windows 10

2. EER Data Model and Diagram

The chosen scenario for this project is a Survey application. The idea came from popular survey sites like Google and Survey Monkey. Users can respond to surveys and their answers are recorded into a database.

With the above scenario, the following EER diagram has been made:

EER Diagram

Respondent

A respondent is a person who takes a survey. A respondent can participate in many surveys but is not allowed to re-take a survey which he/she has already finished.

Survey

A survey contains questions which a respondent has to answer to. A survey has at least 1 question for the respondents to answer.

Question, Multiple Choice Question, Multiple Choice Choose One Question, Multiple Choice Choose Many Question, and Essay Question

A question is a data that is prompted for the respondent to answer. There are 2 types of question, one of which the user has to select from a given choices and another where the user has to type in their answer as text. There are 2 types multiple choice question, one of which is where the user can choose only one as an answer and the other where the user can select multiple answers.

3. Conceptual/Logical Relational Database Schema

Relational Database Schema

4. MySQL Code

Database

The name of the database is “survey”. It is created using the following SQL code:
create database survey;
use survey;

Survey Table

The survey table stores all survey information. It is created using the following SQL code:
create table survey (
  survey_id integer primary key,
  title varchar(100) not null,
  description varchar(1000) not null,
  create_date date not null
);

The following are the SQL codes that would create initial survey data:
insert into survey values(1, 'Animals', 'A survey about you and animals.', curdate());
insert into survey values(2, 'Places', 'A suvey about you and places.', curdate());

Question Table

The question table stores questions of a survey. A question references the survey table in order to keep track which question is owned by a survey. The question table is created using the following SQL code:
create table question (
  question_id integer primary key,
  survey_id integer not null,
  question varchar(1000) not null,
  question_type char(1) not null,
  foreign key (survey_id) references survey (survey_id)
);

The following are the SQL codes that would create the questions for each survey:
insert into question values(1, 1, 'Which animal do you like the most?', 'M');
insert into question values(2, 1, 'Why do you like that chosen animal?', 'E');
insert into question values(3, 2, 'Which of the following places you want to visit?', 'M');
insert into question values(4, 2, 'What other places do you like to visit?', 'E');
Letter ‘M’ represents a code that indicates that a question is a multiple choice question while ‘E’ indicates that a question is an essay question.

Multiple Choice Question Table

The multiple choice question is the subtype representation of a question from the ER diagram. All multiple choice questions will be on this table. It references the question table in order to retain inherited attributes. The Multiple Choice Question table is created using the following SQL code:
create table multiple_choice_question (
  question_id integer primary key,
  choice_type char(1) not null,
  foreign key(question_id) references question (question_id)
);

The following are the SQL codes that would assign which questions are multiple choice:
insert into multiple_choice_question values (1, 'S');
insert into multiple_choice_question values (3, 'X');
Letter ‘S’ represents a code that indicates that only 1 answer can be chosen for the multiple choice question. On the other hand ‘X’ represents a code that indicates that more than 1 answer can be chosen for the multiple choice question.

Multiple Choice Question Choices Table

This table stores the choices for a multiple choice question. It references the Multiple Choice Question table in order to know which choices are owned by a question. The Multiple Choice Question Choices table is created using the following SQL code:
create table multiple_choice_question_choices (
  question_id integer not null,
  choice_id integer not null,
  choice varchar(1000) not null,
  primary key (question_id, choice_id),
  foreign key (question_id) references multiple_choice_question (question_id)
);

The following are the SQL codes that would create the choices of the multiple choice questions:
insert into multiple_choice_question_choices values (1, 1, 'Cat');
insert into multiple_choice_question_choices values (1, 2, 'Dog');
insert into multiple_choice_question_choices values (1, 3, 'Rabbit');
insert into multiple_choice_question_choices values (3, 4, 'Japan');
insert into multiple_choice_question_choices values (3, 5, 'Ireland');
insert into multiple_choice_question_choices values (3, 6, 'Greece');

Essay Question Table

The essay question table is the subtype representation of a question from the ER diagram. All essay answerable questions are stored on this table. It references the question table in order to retain inherited attributes. The table is created using the following SQL code:
create table essay_question (
  question_id integer primary key,
  foreign key(question_id) references question(question_id)
);

The following are the SQL codes that assign essay questions:
insert into essay_question values(2);
insert into essay_question values(4);

Respondent Table

This table stores all the information who takes surveys. It is created using the following SQL code:
create table respondent (
  respondent_email varchar(100) primary key,
  first_name varchar(50) not null,
  last_name varchar(50) not null,
  birth_date date not null,
  gender char(1) not null
);

The following are the SQL codes that creates the initial respondents data:
insert into respondent values ('[email protected]', 'Michael', 'Jordan', '1988-01-02', 'M');
insert into respondent values ('[email protected]', 'George', 'Washington', '1960-01-02', 'F');

Survey Respondents Table

The Survey Respondents table stores details on which survey has already been taken by a respondent. It references the Respondents table to know the person who took the survey. It also references the Survey table to know what survey was taken by the respondent. This table allows checking and making sure that a respondent does not re-take a survey. The table is created using the following SQL code:
create table respondent (
  respondent_email varchar(100) primary key,
  first_name varchar(50) not null,
  last_name varchar(50) not null,
  birth_date date not null,
  gender char(1) not null
);

The following are the SQL codes that assigns which surveys has been taken by the respondents:
insert into survey_respondents values('[email protected]', 2, '2020-01-11');
insert into survey_respondents values('[email protected]', 2, '2020-01-11');
insert into survey_respondents values('[email protected]', 1, '2020-01-11');

Respondent Multiple Choice Answer

This table keeps track the choices that has been chosen as an answer by the respondent in a Multiple Choice Question. It references the Respondent table to know the person who chose the answer. It also references the Multiple Choice Question Choices table to know the information about the chosen answer by the respondent. The table is created using the following SQL code:
create table respondent_multiple_choice_answer (
  respondent_email varchar(100) not null,
  question_id integer not null,
  choice_id integer not null,
  primary key(respondent_email, question_id, choice_id),
  foreign key(respondent_email) references respondent(respondent_email),
  foreign key(question_id, choice_id) references multiple_choice_question_choices(question_id, choice_id)
);

The following are the SQL codes that assigns which choices has been chosen by the respondents in a multiple choice question:
insert into respondent_multiple_choice_answer values('[email protected]', 1, 3);
insert into respondent_multiple_choice_answer values('[email protected]', 3, 6);
insert into respondent_multiple_choice_answer values('[email protected]', 3, 4);
insert into respondent_multiple_choice_answer values('[email protected]', 3, 5);

Respondent Essay Answer Table

The Respondent Essay Answer table stores all essay answers of a respondent to an essay question of a survey. It references the Respondent table to know the person who took the survey. It also references the Essay Question table to know which question is being answered. The table is created using the following SQL code:
create table respondent_essay_answer (
  respondent_email varchar(100) not null,
  question_id integer not null,
  essay_answer varchar(1000) not null,
  primary key(respondent_email, question_id),
  foreign key(question_id) references essay_question(question_id)
);

The following are the SQL codes that logs the essay answers written by the respondents in an essay question:
insert into respondent_essay_answer values('[email protected]', 4, 'Romania');
insert into respondent_essay_answer values('[email protected]', 4, 'Indenosia');
insert into respondent_essay_answer values('[email protected]', 2, 'It is cute.');

Selecting Average number of Survey Responses

This embedded query calculates and returns the average number of responses to all surveys:
select avg(num_respondents) as avg_num_responses from (select survey_respondents.survey_id, count(survey_respondents.survey_id) as num_respondents from survey_respondents group by survey_respondents.survey_id) respondents_count;

Selecting all Survey

This query returns all survey information and the number of respondents for each survey.
select survey.survey_id, survey.title, survey.create_date, count(survey_respondents.survey_id) as num_respondents from survey left join survey_respondents on survey.survey_id = survey_respondents.survey_id group by survey.survey_id, survey.description, survey.create_date;

Selecting a Survey

This query returns the details of a specific survey:
select * from survey where survey_id=?;

Selecting Respondents and Responses to a Multiple Choice Question

This query returns all the details of a respondents on a multiple choice question. It also returns the choices that they have chosen when prompted to answer the question:
select respondent.respondent_email, (year(curdate()) - year(respondent.birth_date)) as age, respondent.gender, multiple_choice_question_choices.choice from respondent join respondent_multiple_choice_answer on respondent.respondent_email = respondent_multiple_choice_answer.respondent_email join multiple_choice_question_choices on respondent_multiple_choice_answer.choice_id = multiple_choice_question_choices.choice_id where multiple_choice_question_choices.question_id=?;

Selecting Respondents and Response to Essay Question

This query returns all the details of a respondents on an essay question. It also returns their essay answer when prompted to answer the question:
select respondent.respondent_email, respondent_essay_answer.essay_answer, (year(curdate()) - year(respondent.birth_date)) as age, respondent.genderfrom respondent join respondent_essay_answer on respondent.respondent_email = respondent_essay_answer.respondent_email where respondent_essay_answer.question_id=?;

Selecting the Questions of a Survey

This query returns all questions of a survey, it is used when a respondent needs to answer surveys, viewing survey results, and or when recording the respondents responses to the database:
select * from question where survey_id=?;

Selecting Multiple Choice Question

This query is used to retrieve multiple choice questions. It is used for filtering:
select * from multiple_choice_question where question_id=?;

Selecting the Choices of a Multiple Choice Question

This query returns all available options a respondent can choose for a multiple question:
select * from multiple_choice_question_choices where question_id=?;

Checking if a Respondent took a Survey

This query returns a count of 1 or 0 to check if a respondent has taken a survey. This is a useful indicator to know where the a respondent already took a survey:
select count(*) as respondent_count from survey_respondents where respondent_email=? and survey_id=?;

Logging a Respondent’s Survey

After a respondent has taken a survey, their details are logged so that they cannot retake the survey again.
insert into survey_respondents values(?, ?, curdate())

Checking if a Respondent Exists

This query returns a result of 1 or 0 to check the existence of a respondent. It is used to know whether a submitted survey requires adding a new respondent or updating it:
select count(*) as respondents_count from respondent where respondent_email=?;

Add a new Respondent

This query is used to insert a new respondent data when the respondent is new to the system where they do not have any previous data saved:
insert into respondent values(?, ?, ?, ?, ?);

Update an existing Respondent

This query updates the details of an existing respondent. When a respondent is submitted a response to a survey but have a previous data currently, then it gets updated:
update respondent set first_name=?, last_name=?, birth_date=?, gender=? where respondent_email=?;

Logging Respondent Multiple Choice Answer

This query inserts to the database the selected choice of the user as a response to a multiple choice question:
insert into respondent_multiple_choice_answer values(?, ?, ?);

Logging Respondent Essay Answer

This query inserts to the database the entered answer of the user as a response to an essay question:
insert into respondent_multiple_choice_answer values(?, ?, ?);

5. Website Working with MySQL Database

DB PHP Script

This script is used for making a connection to the database. It contains the configuration as well such as the database name, username, password, and URL. This script is not meant for viewing in the browser but is used by other PHP scripts that requires database operations.

Surveys PHP Script (Home Page)

This script will make a query to the database to select all surveys. The script will display all surveys including how many respondents are there. For each survey, the user can either view the responses of a survey or take a survey.
PHP Database Survey

Take Survey PHP Script

This script will receive the ID of a survey to be taken. It will then query the database to retrieve the details of the survey and the questions. All details are then displayed. Multiple choice questions uses radio buttons and checkboxes while Essay questions uses a text area for answers.
PHP Take Survey
Users are not required to answer all the questions however they are required to enter their email, name, birthdate, and gender when submitting the survey.

Submit Survey PHP Script

This script is called when the user submits the survey. This script will retrieve all answers of the user and then saves them into the database.

Survey Script

This script is meant for viewing the details of a survey including the responses to the questions. It displays who are the respondents, their gender, and their age which are somewhat important if classifying responses.

PHP Survey Responses

6. Advanced Tasks

The following are the advanced tasks which has been implemented:
  1. Full implementation of the EER diagram to a physical database.
  2. Complex EER and Logical model.
  3. Complex implementation where relations are optimized, appropriate relationship constraints, and keys.
  4. All database tables are appropriately normalized to at least 3rd normal form.
  5. Use of advanced MySQL statements.
  6. A half-baked working PHP survey based system, it lacks the administrator part.
Reviews

I don’t know what I would have done without you. I am so grateful that you took the time to complete my web development assignment. I was on fieldwork and the deadline was fast approaching. I have been failed by online platforms in the past and therefore I was just giving it a try with you. The web development assignment helper who handled my work did it well and with a lot of professionalism. I am so happy.

I will hire you again. I was recommended to you by a friend who told me that he has seen the quality of your work. Even though I knew you were going to deliver quality work you exceeded my expectation. I am so glad I found you because you are going to hand all my web development assignments from now on.

Quality check! Timeliness check! Affordability check! I am so happy that I even chose you to do my work. Web development has been giving me a lot of challenges and that is why I wanted an available online web development tutor. Thank you for being so amazing to me. I will hire you again.

Experts
  • Liam M - web development expert

    839 Completed Orders

    94% response time

    57 reviews

    Liam M

    Calgary, Canada

    Degree in Computer Science, Mount Royal University, Canada

    Profession

    Web development assignment helper

    Skills

    Web development should not be the reason you are having sleepless nights. If web development is giving you a hard time, I can complete its assignments for you at a small fee. I am a full-time web development assignment helper offering quality services and ensuring that all assignments are submitted on time. I have been working as a web development homework help expert since 2015. Before that, I was a tutor still on web development. I offer help with all web development topics. I have a clear understanding of Django, HTML, ASP, and AJAX for web development. I am based in Canada but I offer my services to students from all corners of the world. Contact me for all your web development assignments and relax as I get the best solutions which will guarantee a top grade.

  • Ronald N - web development expert

    2579 Completed Orders

    97% response time

    324 reviews

    Ronald N

    Minnesota, USA

    Masters in Programming, Massachusetts Institute of Technology, USA

    Profession

    Professional web development homework help

    Skills

    You can enjoy studying web development but only if you have the right support. Web development is enjoyable but very challenging for students. I have been providing web development assignment help for nearly a decade now. Over this period I have ensured that students are comfortably scoring high grades. Being a highly qualified web development tutor, I offer help on all topics. I ensure that your assignments are delivered on time. Over the years I have worked with thousands of students and I have never had a complaint about the quality of work. That is evident in my rating. If you want a professional web development homework help expert, contact me as soon as possible.

  • Mason G - web development expert

    1008 Completed Orders

    96% response time

    123 reviews

    Mason G

    Virginia, USA

    Degree in Programming, University of Pennsylvania, USA

    Profession

    The best online web development tutor

    Skills

    I am an award-winning web development tutor. I am currently working with programminghomeworkhelp.com as an online web development tutor. My main task is to help students understand concepts about web development that they either did not understand in class or which they want a further explanation about. I also help students prepare for exams. Every student wants to top their class and that is why I offer to help them prepare for exams. Lastly, I am also a web development assignment help. I don’t like students getting stressed over assignments. If you are looking for the best online web development tutor, you are in the right place. Contact me and get the right solutions for your task which will guarantee you a good grade.

  • Emily E - web development expert

    1580 Completed Orders

    97% response time

    253 reviews

    Emily E

    Newcastle, UK

    Ph.D. in Computer Science, Coventry University, UK

    Profession

    Web development homework help expert

    Skills

    When your web development assignments become too hard for you, don’t keep on struggling with something that you may probably end up failing. During such hard times contact me to help you. I am a Ph.D. level web development homework help expert. I have helped many other students get top grades in circumstances when they thought they were going to fail exams. With my 12 year experience, I have what it takes to ensure that you get a top grade in your assignment. One good thing is that despite my work being top-rated I charge a very reasonable fee. Send me your web development assignment and wait for the solutions within our agreed time.