Technology Resources for Students

Katie Kopan holding up diploma holder
 Student wearing VR headset
 Students talking in a classroom

Please review FAQ for other useful information.

FSB Oracle Server and Databases

1. Create your FSB Oracle account. <- link to: https://sqlweb.fsb.miamioh.edu/

2. Databases available for classes:
    1. Northwinds  (Relationship diagram <-  Link to: https://docs.yugabyte.com/preview/sample-data/northwind/
       A. Tables
  • northwinds.customers
  • northwinds.categories
  • northwinds.products
  • northwinds.employees
  • northwinds.products
  • northwinds.orders
  • northwinds.orderdetails
  • northwinds.shippers
  • northwinds.suppliers
3. wwimporters (Relationship diagram <- link to: https://dataedo.com/samples/html/WideWorldImporters/doc/WideWorldImporters_5/modules.html
        A. Tables
  • wwimporters.customers
  • wwimporters.customercatagories
  • wwimporters.customertransactions
  • wwimporters.invoices
  • wwimporters.invoicelines
  • wwimporters.orders
  • wwimporters.orderlines
  • wwimporters.purchase.orders
  • wwimporters.purchaseorderlines
  • wwimporters.cities
  • wwimporters.buyinggroups
  • wwimporters.coldroomtemperatures
  • wwimporters.colors
  • wwimporters.countries
  • wwimporters.deliverymethods
  • wwimporters.packagetypes
  • wwimporters.paymentmethods
  • wwimporters.people
  • wwimporters.specialdeals
  • wwimporters.stateprovinces
  • wwimporters.stockgroups
  • wwimporters.stockitemholdings
  • wwimporters.stockitems
  • wwimporters.stockitemsstockgroups
  • wwimporters.stockitemtransactions
  • wwimporters.suppliercategories
  • wwimporters.suppliers
  • wwimporters.suppliertransactions
  • wwimporters.transactiontypes
  • wwimporters.vehicletemperatures
4. Dunnhumby Databases (descriptions <- Link to: https://www.dunnhumby.com/source-files/)

5. Dunnhumby  (Relationship diagram <-Link to Dunnhumby (see attached)
    A. Tables
  • dunnhumby.transactions (over 5 millions rows)
  • dunnhumby.store
  • dunnhumby.product
  • dunnhumby.causal
5. Dunnhumby Breakfast at the Frat (Relationship diagram <- Link to Bfrat (see attached)
    A. Tables
  • bfrat.storelookup
  • bfrat.productslookup
  • bfrat.transactiondata
6. Baseball (relationship diagram <- Link to https://tinyurl.com/2rwaukzd
    A. Tables
  • baseball.batting
  • baseball.fielding
  • baseball.pitching
  • baseball.teams
  • baseball.allstartfull
  • baseball.appearance
  • baseball.awardsmanagers
  • baseball.awardsplayers
  • baseball.awardssharemanagers
  • baseball.awardsshareplayers
  • baseball.battingpost
  • baseball.collegeplaying
  • baseball.fieldingOF
  • baseball.feldingOFSplit
  • baseball.fieldingpost
  • baseball.halloffame
  • baseball.homegames
  • baseball.managers
  • baseball.managershalf
  • baseball.parks
  • baseball.people
  • baseball.pitchingpost
  • baseball.salaries
  • baseball.schools
  • baseball.seriespost
  • baseball.teamsfranchises
  • baseball.teamshalf
7. MLSSoccer
A. Tables
  • mlssoccer.allgoalkeepers
  • mlssoccer.allplayers
  • mlssoccer.alltables
  • mlssoccer.allevents
  • mlssoccer.matches

FSB Server Links

University Links