Final group project/ pick 5 pages on the website bestbuy.com then use lucidcharts.com to create an ER diagram for those pages, for one of the pages describe the data on that page, and what kind of SQL queries you think goes to building that page try to be creative example min-max,brand,category etc. you have to be a really good analyzer and pick the best SQL queries you think are important and can be interesting and involve using different concepts we learned in class such as joins, group by,having,order by, minus, monotonic,non-monotonic,etc for making your best guess on the query that generated the data for the page using the tables in your ER model . (try to use not to use so simple queries using select from where). No database to create, no data to insert - only model and query in this project. The other 4 pages of data, and what kind of SQL queries are used, have to be derived from tables from the ER diagram of course you will create, but my group team members will do those 4 pages,(we are five people in total as you can tell from the number of pages ).This assignment should be in PowerPoint format as our group will be presenting it in class. In this project, you will choose a real organization - maybe a site that all team members have access to, or have used before, or you are interested in. You can pick any site - some examples are Amazon, eBay, Swappa, Best Buy, Walmart, Publix, etc. etc. If any of you have some administrative-level access to a site, that is even better since you can then work on some of the backend aspects of it.We will be using www.bestbuy.com Your goal in this project is to identify the main data components of this site and identify the different parts of that site that seems to have a database backend (hint: almost every page probably is!) Remember there are likely product pages, purchasing, shopping carts, user profiles, and many other things in the sites that are interesting. We will start the process of this project shortly after the midterm. During a class session, I will set up the teams (or continue with the teams from the labs) and have each team pick a website to analyze. I do not want two teams to pick the same site since I do want some variation during the project presentations (yes we will have one). Once a team picks a site, you have committed to working on that site, and other teams cannot pick that same site, and the team that originally picked the site cannot change theirs. The second task, still in the team, create a very basic ER model for the site. You should use Lucidchart's share feature for this that will allow all of you to work on the same diagram. Finally, each team member needs to pick one of the pages in the site and describe the data on that page, and what kind of SQL queries you think goes to building that page. We are going to go over some basic dynamic web page concepts in the class. You will need to contribute 2 slides to a PowerPoint presentation for your project. Minimum presentation requirements: Here is what I recommend you have prepared for the presentation: One PowerPoint slide deck containing: Your team composition with the names of each team member Which website/application you picked Some bullet points on what were some of the major items you considered in your project The ER model you created based on what you found on the website. In addition to the above, there should be two slides for each team member. You can choose what to present in your 2 slides, but I would recommend: Slide 1 - a screenshot of what type of data is shown on your chosen page Slide 2 - the query, based on your model, that you think was used to generate this page How you coordinate your presentation is up to you, but every member must contribute to the presentation, and team effort will be part of the grades. You can have one team member share their screen containing all slides, and each member speaks when their slide is shown, or you all can have your own slides up on your computer. In this project dropbox, you will submit the PowerPoint presentation of your project and a share link for the ER model in Lucidchart. Make sure the link gives me edit access. Typically, every team member will receive the same score for the project, if the contribution of each member is approximately equal. The collaboration document will give me a pretty good idea of who is doing what, so make sure you do your bit. In the circumstances where I feel any member did not participate adequately in the project, I will penalize the team member without affecting other group members.The PowerPoint slides link is attached below, complete the three things mentioned in the summary or task of this assignment.i will be presenting this wish me luck.https://docs.google.com/presentation/d/1GOA4FiiEVmt7yYwAayM1SIUyhOWOKWHQ3HgKHYyv0AE/edit#slide=id.gadcf451101_0_15Kind regards,Thanks A lot

Read chapter 3. Review all the documents in the weekly module before doing the assignment. Modify program 3 from lesson 3 to create your own program with the following modifications:a) Choose different background and foreground colors. Make sure thee text is visible.b) Create two buttons in the window instead of one.c) Each button should give a different message when clicked.Copy and paste the program and the output and also submit a screenshot of both. Use this link to download Just Basic software on your computer. http://justbasic.com/

Project 3: Ticket Purchasing Instructions TICKET PURCHASING Project Description Based on your great work at Creative Genius Web Design, your supervisor has assigned you to a new project to create a simple system to purchase tickets for an upcoming DMWT alumni event. Many interactive web sites use JavaScript to enable dynamic content and enhance a user’s experience using the web site. Below are some screenshot images of what your event registration system should look like when completed. These are screenshots - The images are not clickable. Figure 1: Event Registration Web page This is a screenshot - The image is not clickable Figure 2: Error When Putting Invalid Number of Tickets This is a screenshot - The image is not clickable Figure 3: Submission Alert When Clicking "Purchase Tickets" This is a screenshot - The image is not clickable Figure 4: Alert When Timer Has Expired This is a screenshot - The image is not clickable Project Components A complete event registration system must feature the following components on the HTML web page: A countdown timer giving the user 10 minutes to complete the transaction, including the number of tickets they wish to purchase, their name, and their email address.Ability to purchase between 1 and 3 tickets.A calculation showing the user the total cost to purchase the ticketsInteractive design features that provide descriptive error messages and visual cues when the user has entered incomplete or incorrect information Project Functionality A complete event registration system must provide the following functionality: 1. JavaScript code outside of any functions (Don’t put this functionality within a JavaScript function: (a) Create a countdown timer that will run for 10 minutes from the current time, displaying only the number of minutes and sections left. When displaying a number of seconds less than 10, make sure you prepend a “0” so that the time is formatted properly (Hint: Use an if statement). (b) As each second elapses update the time remaining the user sees on the screen. (c) Once the timer runs out, clear the timer so that it stops running, display an alert to the user their timer has expired, and redirect the user back to the same page (Hint: Use location.href to help with this). 2. JavaScript functions (Most likely two or three functions) for the following items: Item #1: Calculate Total (a) Calculate the total (using a fixed-format with a $ and two decimal places) based on a number of tickets purchased. (b) Perform validation to make sure the user has entered in a value that is a number for the number of tickets and the number is between 1 and 3 (Hint: Use the isNaN() function to determine if user entry is not a number). (c) Add an error message next to the input field when an invalid number of tickets has been entered and change the background color of the input field to help alert the user. (d) Display the ability to see the contactInformation section of the webpage when a valid number of tickets has been entered. Hide the contactInformation section of the webpage when a valid number of tickets has not been entered. Item #2: Complete Purchase (a) Perform validation to make sure the user entered in a value for both name and email. (b) Add an error message next to the input field when either a name or email has not been entered and change the background color of the input field to help alert the user. (c) If no errors in the input were found, provide an alert to the user thanking them for their purchase with the total amount of the purchase, and stop the timer. Otherwise, allow the user to continue to make changes until they have provided valid information. Extra Hint: You will be changing the background color for a number of different fields, depending on if an error has occurred or not. Consider making a function that allows you to pass in a field id and whether or not an error occurred to know what color to change the background color to. By doing this, the function can be called repeatedly instead of having to continuously re-write the code needed to do this in your solution. Project Requirements The zipped file attached to this assignment provides the folder structure that is required for this project. Instructions for how to unzip the file on a PC or a Mac can be found at http://www.wikihow.com/Extract-Files. Individual files have also been provided. Do not make any modifications to the HTML or CSS files provided. You only need to modify the event_registration.js file. Points will be deducted for modifying the HTML or CSS files. Use // to document your JavaScript code by providing comments that explain the purpose of all lines of code you write Submission Requirements Please complete the following to you Assignments Folder: Host your working event registration system online using the Nova ServerSubmit the HTML and JavaScript files you used to create the webpage to your project Assignments FolderWrite a Project Reflection (see description below) Project Reflection Answer the following questions when you submit your assignments files. Each question’s response must have a minimum content length of 50 words. What resources did you use to determine what type of JavaScript was needed? Include all of the specific URLs you used and what you found at each URLWhat process did you use to create your event_registration.js file? Describe what you did to create the code you submitted in the assignment. Be specific!What issues or challenges did you face completing this project? If you feel you did not face any issues or challenges in completing this project, what issues or challenges do you think someone new to JavaScript might face in completing this project?Describe another scenario that could use what you learned in completing this project. Be specific!If you could waive a magic wand and change something about this project, what would you change and why? If you do not believe anything should be changed, explain why you think this is the case. Please submit your Project Reflection as a Microsoft Word document or just copy and paste your answers in your Assignments Folder's text box when you submit your assignment along with the rest of the required project files. HTML Validation Your pages should validate without errors using the W3C HTML Markup Validation Service at http://validator.w3.org. How to do this: Publish your pages to NovaGo to the W3C validator and paste in the URL to your index.html pageSelect the check button Helpful Resources This assignment will require you to combine what you have learned interacting with the DOM and performing form validation for success. The links below highlight specific concepts and topics that you will need to learn in order to complete this assignment successfully. Types of Mouse Events https://www.w3schools.com/jsref/dom_obj_event.aspTargeting IDs https://www.w3schools.com/jsref/met_document_getelementbyid.aspTargeting and Altering HTML https://www.w3schools.com/jsref/prop_html_innerhtml.aspSetting Style Properties for HTML Elements https://www.w3schools.com/jsref/dom_obj_style.aspGetting and Passing Attributes https://www.w3schools.com/jsref/met_element_getattribute.aspWorking with Numbers in JavaScript https://www.w3schools.com/jsref/jsref_obj_number.aspCreating a Countdown Timer https://www.w3schools.com/howto/howto_js_countdown.aspDate Reference https://www.w3schools.com/jsref/jsref_obj_date.aspJavaScript Window Location https://www.w3schools.com/js/js_window_location.aspJavaScript NaN (Not a Number) Property https://www.w3schools.com/jsref/jsref_number_nan.asp Submitting Your Assignment To complete this project and receive full credit, you must submit your completed presentation to your Assignments Folder. .