UCSD Html CSS Worksheet

/ fhcxvqf1919 / By

Description

We are now approaching the end of the tech assignments and soon, you will start work on your final projects. To give you some idea of what to do or how to approach the project, we will do this lab as a smaller version of your project. To begin this challenge, create a folder called Challenge_1 inside your Tech Assignment 5 folder, with the following file structure:└─ Challenge_1 ├─dashboard.html ├─ index.html ├─init_db.py├─ app.py└─ public ├─dashboard.jsChallenge 1: Ideas Dashboard
Description
We are now approaching the end of the tech assignments and soon, you will start work on your
final projects. To give you some idea of what to do or how to approach the project, we will do this
lab as a smaller version of your project. To begin this challenge, create a folder called
Challenge_1 inside your Tech Assignment 5 folder, with the following file structure:
Challenge_1
├─ dashboard.html
├─ index.html
├─ init_db.py
├─ app.py
└─ public
├─ dashboard.js
└─
init-db.py – creating a database
Create a Python file called init-db.py that uses the MySQL-Python connector to do the following:
● Create a new database called TechAssignment5.
● Within this database, create a table called Ideas. This table should contain the following
fields – id, title, competitors, price, cost, and market_size.
● Use datatypes appropriate to each of the fields. For title and competitors, use at least 100
characters.
● Populate the table with the ideas you submitted during the first 5 weeks of this course.
There should be at least 5 ideas.
app.py – Server (backend) code
● There should be two routes:
○
“/” corresponding to the main homepage.
○
“/dashboard” corresponding to dashboard.html
○
You need to create the your own REST APIs based on the requirements given in
dashboard.html. You can follow general convention like “/idea/{idea_id}” for
updating, “/addidea” for adding an idea, “/deleteidea” for deleting and idea and so
on. You can choose which HTTP requests to use to accomplish each requirement.
index.html – the main homepage
● Create a landing page. You can borrow from your previous assignment where you
created your portfolio.
● This page should contain a link to the Dashboard page near the top of the page where it
is easily visible.
dashboard.html – the dashboard page
● Create an HTML page for your ideas dashboard.
● This page should have a table/grid that shows all your ideas currently in the database.
● It should have a button that allows you to modify a field in your idea with a new value.
● It should have a button that allows you to delete an idea
● It should have a button that allows you to add a new idea.
● When either of the buttons are clicked, your SQL database should be updated to reflect
the changes made on the webpage.
dashboard.js – the dynamic part of the dashboard
● Add the necessary Javascript code to be able to fetch on the APIs you create for the
adding, modifying, deleting ideas and showing ideas.
Submission:
To successfully complete this challenge, submit screenshots or a video of the following:
● The initial table on your dashboard page.
● Then, change one field in the table (this field could be the price, cost, market size,
customer, etc.) and show the resulting page.
● Then, delete the entry corresponding to your idea from Week 1 and show the resulting
page.
● Then, add another idea from Slidespace that you really liked to your table, and show the
resulting page.
Your screenshots or video must be attached to your README.md. Please label your screenshots
so that we can easily identify them.

Purchase answer to see full
attachment

Description We are now approaching the end of the tech assignments and soon, you will start work on your final projects. To give you some idea of what to do or how to approach the project, we will do this lab as a smaller version of your project. To begin this challenge, create a folder called Challenge_1 inside your Tech Assignment 5 folder, with the following file structure:└─ Challenge_1 ├─dashboard.html ├─ index.html ├─init_db.py├─ app.py└─ public ├─dashboard.jsChallenge 1: Ideas Dashboard Description We are now approaching the end of the tech assignments and soon, you will start work on your final projects. To give you some idea of what to do or how to approach the project, we will do this lab as a smaller version of your project. To begin this challenge, create a folder called Challenge_1 inside your Tech Assignment 5 folder, with the following file structure: Challenge_1 ├─ dashboard.html ├─ index.html ├─ init_db.py ├─ app.py └─ public ├─ dashboard.js └─ init-db.py – creating a database Create a Python file called init-db.py that uses the MySQL-Python connector to do the following: ● Create a new database called TechAssignment5. ● Within this database, create a table called Ideas. This table should contain the following fields – id, title, competitors, price, cost, and market_size. ● Use datatypes appropriate to each of the fields. For title and competitors, use at least 100 characters. ● Populate the table with the ideas you submitted during the first 5 weeks of this course. There should be at least 5 ideas. app.py – Server (backend) code ● There should be two routes: ○ “/” corresponding to the main homepage. ○ “/dashboard” corresponding to dashboard.html ○ You need to create the your own REST APIs based on the requirements given in dashboard.html. You can follow general convention like “/idea/{idea_id}” for updating, “/addidea” for adding an idea, “/deleteidea” for deleting and idea and so on. You can choose which HTTP requests to use to accomplish each requirement. index.html – the main homepage ● Create a landing page. You can borrow from your previous assignment where you created your portfolio. ● This page should contain a link to the Dashboard page near the top of the page where it is easily visible. dashboard.html – the dashboard page ● Create an HTML page for your ideas dashboard. ● This page should have a table/grid that shows all your ideas currently in the database. ● It should have a button that allows you to modify a field in your idea with a new value. ● It should have a button that allows you to delete an idea ● It should have a button that allows you to add a new idea. ● When either of the buttons are clicked, your SQL database should be updated to reflect the changes made on the webpage. dashboard.js – the dynamic part of the dashboard ● Add the necessary Javascript code to be able to fetch on the APIs you create for the adding, modifying, deleting ideas and showing ideas. Submission: To successfully complete this challenge, submit screenshots or a video of the following: ● The initial table on your dashboard page. ● Then, change one field in the table (this field could be the price, cost, market size, customer, etc.) and show the resulting page. ● Then, delete the entry corresponding to your idea from Week 1 and show the resulting page. ● Then, add another idea from Slidespace that you really liked to your table, and show the resulting page. Your screenshots or video must be attached to your README.md. Please label your screenshots so that we can easily identify them. Purchase answer to see full attachment

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.