just use lucidcharts.com to Complete an ER diagram for five pages for a website.The second part of the project me and my group will do it by ourselves.

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:

1. Your team composition with the names of each team member
2. Which website/application you picked
3. Some bullet points on what were some of the major items you considered in your project
4. 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.

4G
17:04
☆
o docs.google.com
A o
R f
Best Buy Team 7
www.bestbuy.com
.
Search engine
Cart
Store location
Product toolbar
• email sign-up
Slide 2
3 []
N
< 合 = 2 III < Project Grading Rubric Criteria Ratings Pts Teamwork 5.0 to 3.0 pts Sophisticated The team worked well together to achieve objectives. Each member contributed in a valuable way to the project. All data sources indicated a high level of mutual respect and collaboration 3.0 to 0.0 pts 0.0 pts Competent Incomplete The team worked well together Team did not collaborate or most of the time, with only a few communicate well. Some occurrences of communication members would work breakdown or failure to collaborate independently, without regard when appropriate Members were to objectives or priorities. A lack mostly respectful of each other. of respect and regard was frequently noted. 5.0 pts Contribution 0.0 pts 5.0 to >3.0 pts
Sophisticated
All requirements and
objectives are identified,
evaluated and competed.
The deliverable offered new
Information or approach to
the topic under discussion
Likewise, the application is
based on stated criteria,
analysis and constraints.
3.0 to 0.0 pts
Competent
All requirements are identified and
evaluated but some objectives are not
completed. The deliverable offered
some new information or approach to
the topic under discussion. The
application is reasonable, further
analysis of some of the alternatives or
constraints may have led to a different
recommendation
Incomplete
Many requirements and
objectives are not identified,
evaluated and/or completed. The
deliverable offered no new
information or approach to the
topic under discussion. Few
application considerations are
analyzed and other factors were
ignored or incompletely analyzed.
5.0 pts
Subject
Knowledge
5.0 to 3.0 pts
Sophisticated
The deliverable demonstrated
knowledge of the course content by
integrating major and minor concepts
into the response. The deliverable also
demonstrated evidence of extensive
research effort and a depth of thinking
about the topic.
3.0 to >0.0 pts
Competent
The deliverable demonstrated
knowledge of the course content by
integrating major concepts into the
response. The deliverable also
demonstrated evidence of limited
research effort and/or initial of
thinking about the topic.
0.0 pts
Incomplete
The deliverable did
not demonstrate
knowledge of the
course content
evidence of the
research effort or
depth of thinking
about the topic.
5.0 pts
Supporting
material
5.0 to >3.0 pts
Sophisticated
All relevant information was
obtainedand information sources
were valid. Analysis and design
considerations were well
supported by the information
3.0 to 0.0 pts
Competent
Sufficient information was
obtained and most sources were
valid. Analysis and design
considerations were mostly
supported by the information
0.0 pts
Incomplete
Insufficient information was
obtained and/or sources lack
validity. Analysis and design
considerations were not
supported by the information
collected
5.0 pts
Composition
5.0 to >3.0 pts
Sophisticated
The deliverable was well organized
and clearly written. The underlying
logic was clearly articulated and
easy to follow. Words were chosen
that precisely expressed the
intended meaning and supported
reader comprehension. Diagrams
or analyses enhanced and clarified
presentation of ideas. Sentences
were grammatical and free from
errors.
3.0 to >0.0 pts
Competent
The deliverable was organized and
clearly written for the most part. In
some areas the logic and/or flow of
ideas were difficult to follow. Words
were well chosen with some minor
expectations. Diagrams were
consistent with the text. Sentences
were mostly grammatical and/or
only a few spelling errors were
present but they did not hinder the
reader.
0.0 pts
Incomplete
The deliverable lacked
overall organization. The
reader hadto make
considerable effort to
understand the underlying
logic and flow of ideas.
Diagrams were absent or
inconsistent with the text.
Grammatical and spelling
errors made it difficult for
the reader to interpret the
text in places.
5.0 pts
Total Points: 25.0