Explore BrainMass

Explore BrainMass

    Design a problem using Microsoft Access: relationships and queries in the database

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I need a problem that could be solved by creating a database in Access and then creating relationships and running queries in that database. Something like the problem below:

    Tony Gambino just recently opened a new casino in Happyville and has been making a great deal of money from the casual gamblers and the day-trippers. However, he has become concerned about several players who seem to spend a lot of time in his casino. Tony is also concerned that some of the recently hired dealers might be associated with these players and helping them cheat. He started a database to track these players, which games they are playing, which dealers are working those games, where in the casino the games are being played, and how much the player wins or loses. As he began to enter this information into a single table given below, he realized that he was wasting time with redundant data entry. Help Tony identify redundant attributes and design an efficient database using ACCESS.

    Player# Player Name Game# Game Name Dealer# Dealer Name Yrs of Exp Date Win/Loss
    1000 Lucky 10 Black Jack 300 Bob 10 4/1/2010 -300
    2000 Bugsy 20 Craps 100 Jim 2 4/2/2010 500
    3000 Bruno 10 Black Jack 400 Bill 10 4/3/2010 -1250
    2000 Bugsy 30 Roulette 300 Bob 10 4/8/2010 -900
    3000 Bruno 30 Roulette 100 Jim 2 4/6/2010 1000
    1000 Lucky 20 Craps 200 Joe 20 4/3/2010 -250
    4000 Mikey 40 Poker 200

    © BrainMass Inc. brainmass.com June 4, 2020, 1:01 am ad1c9bdddf

    Solution Preview

    Debra's company works with the disabled. While she has more clients that are developmentally disabled, there has been more interest recently from all types of disabled people. Her clients are mostly adults looking for ways to help them become or remain independent and find work to support themselves. The Medicaid Waiver program will help pay for a lot of the ...

    Solution Summary

    The following problem helps wth a design problem using Microsoft Access. It discusses relationships and queries.