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 3rd Normal Form.Upload a pdf version of your

1. Draw an ER Model using Visio for the following. Make sure the ER model is in 3rd Normal Form.Upload a pdf version of your ER model on Blackboard (50 pts):

image text in transcribed
1. Draw an ER Model using Visio for the following. Make sure the ER model is in 3rd 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/composue 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 Iggy website while a bet can include multiple M Each RU's name, date of birth, and credit card information must be tracked. The prize money earneId 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 m 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 M Leisure games are competitive but do not teature 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 \\Mn 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

Hospitality Marketing Management

Authors: Robert D Reid, David C Bojanic

4th Edition

0471476544, 9780471476542

More Books

Students also viewed these General Management questions

Question

How do childhood experiences affect self-esteem?

Answered: 1 week ago

Question

Multiply. 5x- 10 4x+8 7x+14 14x-28

Answered: 1 week ago

Question

2. I try to be as logical as possible

Answered: 1 week ago