Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Draw an ER Model using Visio for the following. Make sure the ER model is in 3d Normal Form. Upload a pdf version of

image text in transcribed
1. Draw an ER Model using Visio for the following. Make sure the ER model is in 3d Normal Form. Upload a pdf version of your ER model on Blackboard (50 pts): Note: Include 2-3 attributes (in addition to the PK and FK) for each of the entities in your normalized ER Model. Further, include at least one attribute (in addition to the two FKs/composite PK) for each bridge/junction table that you include in your ER Model. U.S. based online sport betting site 'Bet to Win Big' which was only accessible in ten (10) states is now expanding its business in fifteen (15) more states and needs to re-design its database system to track user activities. An individual (hereby referred to as Registered User/RU) can place multiple bets online on 'Bet to Win Big's' website while a bet can include multiple RUs. Each RU's name, date of birth, and credit card information must be tracked. The prize money earned by a RU for winning a bet depends on the RU and the bet itself. Each RU is associated with a state (example, MA, FL, TX), while a state can be represented by many RUs. Another feature of Bet to Win Big's website is it allows RU's to participate in games that the website refers to as leisure games (which have no association with the bets RU's place on the website). Each RU can participate in multiple leisure games, while a game can include many RUs. I Leisure games are competitive but do not feature any prize money (the purpose is to create a community of RU's that not only can place bet's online but also play games for fun). Bet to Win Big wants to track how much time each RU spends on leisure games as it believes that more time spent by an RU on these games may translate into them placing more bets online on its website

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Algebra advanced algebra with financial applications

Authors: Robert K. Gerver

1st edition

978-1285444857, 128544485X, 978-0357229101, 035722910X, 978-0538449670

More Books

Students also viewed these Mathematics questions