Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

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

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 ...

Purchase this Solution


Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.