Need this in MS VISIO.

Based on the following narrative description, conduct the conceptual data modeling and draw an Entity-Relationship diagram according to the requirements of NCAA Men Basketball. You should specify the key and non-key attributes for each entity type. For relationship types, you should specify: (1) the (min,max) cardinality ratios (you can use any representation notation), and (2) the relationship attributes if it is necessary to include them. If you discover the narrative is incomplete, provide reasonable explanations to complete the story. Supply these extra explanations along with your diagram. However, none of the assumptions you make can nullify or contradict the business rules stated. NCAA Men Basketball NCAA wants to develop a database to keep track of information about college men basketball. Each team belong to a University and associate with one conference. Teams have their mascots. A conference has several teams. Each team can has maximum of 60 players and a minimum of 20 players. Each player can only play for one team. Each team has 6 to 10 coaches. A coach can work only for one team. Each year, NCAA will schedule a set of games for each team, and two games for any two teams (e.g., UC and Xavier). Four qualified referees are assigned to each game. NCAA would like to keep track of the details of each game; such as game schedule (i.e., date, time, and game-place), and referees assigned, participating teams, and the final score. Attributes for players include name, admission-date, year (such as freshmen, sophomore, etc), major, GPA, blood-type, and birthday. Attributes for coaches are name, title, salary, address, and phone. Attributes for referees are name, referee-ID, salary, year-of-service, address, and gender. NCAA also wants to keep track of the performance details of players who participated in each game, such as the position they played in that game and the personal score, assistants, and fouls. NCAA also records the day when the team joins a particular conference. Deliverable: E-R diagram of your conceptual data modeling (I will not accept late homework.) The ER diagram should be prepared by a software tool (e.g., MS Visio).

A juice shop in Santa Barbara serves two types of consumers: tourists and locals. Tourists’ inverse demand per day is P(q) = (50−q)/5 . Locals’ inverse demand per day is P(q) = (500−q)/ 50 . In order to sell a total of 55 juice bottles per day, what price should the shop charge per bottle? (a) $12 (b) $10 (c) $9 (d) $8 3.

(continued from previous question) Assume that the number of tourists coming to Santa Barbara double. (This means that demand from tourists at every price level doubles.) But, at the same time, due to an economic recession, the local demand becomes more price sensitive. P(q) = (500−q)/ 100 .

Which statement is correct?

(a) To maximize revenue, it is optimal to price high enough to only target tourists.

(b) At the revenue maximizing price, there is higher revenue generated from the local population relative to tourists.

(c) The revenue maximizing price is $4 per bottle.

(d) If the tourists stop coming (demand decreases to 0), to maximize revenue the shop owner would increase the price.

A is correct but why?

On May 19, 2012, a group of individuals, including Greg Hargus, rented a vessel (boat) from Ferocious and Impetuous, LLC d/b/a One Love Charters ("One Love"). Kyle Coleman captained the boat for One Love. While in Cruz Bay, Coleman saw two passengers throwing beer cans at Hargus. Coleman joined them and threw an empty plastic insulated coffee cup at Hargus, which hit Hargus on the head and allegedly caused him headaches and vision problems. Hargus brought suit against One Love, arguing that it was vicariously liable for Coleman's actions. Assuming Coleman was an agent of One Love, what is likely to be One Love's best defense to Hargus' vicarious liability theory? Explain.

What does it mean when the author said, "define the meaning of the social sciences for the cultural tasks of our time" in the book Sociological Imagination?

Chapter 5:Marriage and family class

Why does the author state that understanding occupational sex segregation is important for understanding gender inequality?

What was the most significant contribution made by Rachel Carson (Author of Silent Spring) who lived from 1904 to 1964 on environmental law?

Based on story " The Bear Came Over The Mountain"What point of view does the author employ in this story? How does it serve the story?

Suppose we are studying the effect of diet on height of children, and we have two diets to compare: diet A (a well-balanced diet with lots of broccoli) and diet B (a diet rich in potato chips and candy bars). We wish to find the diet that helps children grow faster. We have decided to use 20 children in the experiment, and we are contemplating the following methods for matching children with diets: i. Let them choose. ii. Take the first 10 for A, the second 10 for B. iii. Alternate A, B, A, B. iv. Toss a coin for each child in the study: heads→A, tails→B. v. Get 20 children; choose 10 at random for A, the rest for B. Describe the benefits and risks of using these five methods