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.
0 comments