Question: 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):

1. Draw an ER Model using Visio for the following. Make sure

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!