Skip to content

Analyzing a Nutrition Store dataset. The project emphasizes two special queries, one regarding product sales and the other on user demographics. It includes SQL and Java code, along with a UML diagram and a flowchart illustrating the process.

Notifications You must be signed in to change notification settings

dogai/SQL-Database-for-Nutrition-Store

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

This project was developed as part of a college assignment and focuses on creating two main queries within the context of a Nutrition Store example.

The queries are as follows:

  1. Identify the best-selling imported creatine brand and the best-selling domestically produced whey powder brand between 2015 and 2020, along with their respective total incomes.
  2. Determine the ratio of females to males among users who have ordered L-karnitin at least 5 times in the last 5 years.

In addition to the SQL query codes, the project includes:

  • Java application code
  • UML class diagram
  • Flowchart
  • Explanation of the project's main idea

About

Analyzing a Nutrition Store dataset. The project emphasizes two special queries, one regarding product sales and the other on user demographics. It includes SQL and Java code, along with a UML diagram and a flowchart illustrating the process.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages