Skip to content

landonjohnsondev/sql_FitToWin

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 

Repository files navigation

Project Background

This database was created as the final project for the Database 1 course. The database was designed for a fictional retail company I created called FitToWin. FitToWin specializes in fitness equipment, snacks, and clothing for runners. The database includes the tables and relations in the following image. An unfilled circle indicates an optionality. A solid line indicates a strong relationship. A dashed line indicates a weak relationship. The two lines under the circle near the bottom of the image indicate a parent child relationship.

alt text

How to Use the Project

To use the database, you need an application that runs MySQL, such as MySQL Workbench. After downloading the sql file, open your MySQL application and connect to your server (assuming you have a server connection established).

If you have a database already set up, you will see it in your schema. Double-click a database you would like to use for the project. Then open the sql file with your MySQL application from your files. Use Control-A and copy all of the code to the tab with the database you want to use. Run the code to create all the tables at once. Then you can delete all the code that was copied and use queries.

About

A database for a fictional retail company named FitToWin as the final project for the Database 1 course

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors