Database Implementation - Server Implementation - IT Assignment Help

Assignment Task:

Aims

1. Understand principles of designing user friendly websites.
2. Write standards compliant websites in HTML & CSS.
3. Develop dynamic, client-side web content using Javascript.
4. Understand the interactions between the client-side and server-side components of web applications.
5. Design and build AJAX calls to a server and handle responses.
6. Use third party APIs in web applications.
7. Use E-R Modeling to design a database structure.
8. Understand the role of databases in web applications.
9. Plan & integrate a database into a web application.
10. Understand and mitigate security issues faced by web applications.

Project Summary

Description

Your web application project for the Semester is to design and develop a task/chore roster system for shared spaces that allows managers to set tasks, notifies users of their tasks, and allows users to mark tasks as complete.

• Upon loading the system should display
  • Current tasks that need to be done today
  • The user who is assigned that task
• Users should be able to sign up and log in so they can
  • View their scheduled tasks
  • Manage their profile/user information
  • Manage their availability
  • Manage the types of tasks they can/want to do.
• Managers should be able to sign up and log in to:
  • Manage their profile/manager information
  • Create and manage different tasks.
  • Group tasks.
  • Assign tasks or groups of tasks to users.
• Users/managers should be able to choose to link a social media/email/other account, allowing login via that platform, to make logging in easier.

One of the following two special features must also be present:

• Email notifications
  • Users can request that an email notifications be sent to them for current/upcoming tasks.
  • Users should be able to choose when email notifications are sent
  • Users should be able to set multiple notifications and/or different notifications per task.
    ~ OR ~

• Calendar Reminder
  • Users can connect their online calendar to the system (Google Calendar/Outlook)
  • Tasks automatically added and updated on users' online Calendars.

Software Requirements

• The web application must developed and run in the CS50 IDE.
  • You should also make regular (at least weekly backups/downloads of your work)
• The web application must use NodeJS, Express, and AJAX .
• The database must be a SQL database.
• Your markup/code must pass W3C Validation and ESLint linting.
• You may use other libraries/frameworks not addressed in this course, however your implementation must still demonstrate your understanding of the concepts taught in this course.

Part 1 – Designing your website

Think about and explore web pages. What might a task roster website look like? What information might users be required to supply? How will they log in? How will tasks display? How will users mark them complete? What should managers be able to do? You are encouraged to think about additional features for this application; we have outlined the minimum.

• Research existing websites to get ideas for your web application.
  • Record any pages you find that are good examples of what your site could look like. What parts work well. What parts don’t work well?
  • Also record any examples you find of features you might want to include in your site.

Once you decide what a user will be able to do, then you need to think about how they will do each task and how you will make those tasks visible on your site – keeping in mind the articles and lectures on design and usability.

• Draw (don’t code) what your site will look like.
  • It should be obvious from the drawing what each part of the site does.
  • Be sure to include any dimensions – if the window is resized, how do elements change?
  • How might the site look on a phone vs desktop?

• Thinking about the features in the description section, start to plan how each of these features of your site will function, plus any additional features that you might like to have.
  • Where does this feature appear and how does the user interact with it?
  • What happens when a user performs one of these interactions?
  • If a change occurs to the page/site following an interaction, clarify what that will be and draw if necessary.
  Describe these for each feature.
• Don't forget to decide which special feature you'll implement:
  • Email notifications

      ~OR~

  • Calendar Reminder

Once you have a basic design, you now need to review and tweak it for usability and accessibility.

• Review your design.
  • How does it minimise kinematic and cognitive load?
  • Does it meet the standards & heuristics referenced in lectures and on MyUni?
• Have 2 other students review your website design and perform basic usability testing.
  • Which parts of your site were clear. Which weren't?
  • Record the feedback from the other group and any findings.
• Record any updates to your design made as a result of the above testing and review.

As you learn more about implementing web applications throughout this course, your design will likely change; that’s okay, but be sure that as those changes creep in, you continue to review your site for usability and accessibility. We will be assessing you for this in your final presentation.

Your week 7 workshop time is a great opportunity to ask questions, get feedback, and compare your design with other students before the deadline.

Part 2 – Planning your Routes and Database

Now that you have a solid design and basic client side implementation, you can start thinking about the content that your web application will be dealing with, and how.

• For each of the features in your website, create a data plan that lists the different pieces of content/information that your web application will be dealing with & determine where it should be stored, what format, and where it should be processed.
  • Where does the information come from?
  • What form should it take?
  • If the information is on the server, what will the client need to send to retrieve that data?
  • If the information is on the client, how will it be sent to the server?
  • Does all information need to be stored on the server?
  • What processing needs to be done to make the data useful?

Once you have an idea of the different pieces of data that you'll need to be working with, you can start thinking about how you'll store that data on your server.

• Using the methods outlined in lectures and pracs, create an Entity-Relationship diagram for your web application's data.

This IT Assignment has been solved by our IT Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.