Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Microeconomics Expert

SportTech Events

1. SportTech Events puts on athletic events for local high school athletes. The company needs a database designed to keep track of the sponsor for the event and where the event is located. Each event needs a description, date, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor's contact information such as the name, phone number, and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event. Each location will need an ID, contact person, and phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create an ERD from the information described above, and then create a normalization structure in 3NF.

2. Course and Student Schedules Dick Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the department. In addition, Dick would like the database to include each instructor's basic contact information, such as ID number, name, office location, and phone number. Currently, Dick has nine instructors (seven full-time faculty members and two adjuncts) in the department. For each course, Dick would like to keep track of the course ID, title, and number of credit hours. When courses are offered, the section of the course receives an ID number, and with that number, the department keeps track of which instructor is teaching the course. Finally, Dick needs to be able to keep track of the IT students and to know which courses each student has taken. The information he would like to know about each student includes ID number, name, and phone number. He also needs to know what grade the student re- ceives in each course. Dick has asked you to create an ERD from the information described above, and then create a normalization structure in 3NF.

Microeconomics, Economics

  • Category:- Microeconomics
  • Reference No.:- M92103114
  • Price:- $30

Priced at Now at $30, Verified Solution

Have any Question?


Related Questions in Microeconomics

Question in your opinion how can behavioral economics be

Question: In your opinion, how can behavioral economics be used for YOU as a student? How would you apply and use behavioral economics if you were a small business owner? The response must be typed, single spaced, must b ...

Question boeing is the major beneficiary of the us

Question: Boeing is the major beneficiary of the US Export-Import Bank, which provides subsidies for exports. Proponents of the bill say it is necessary to meet hidden subsidies offered by Airbus, and creates thousands o ...

Question - what is slavery explain how and why slavery

Question - What is slavery? Explain how and why slavery developed in the American colonies. Why couldn't colonists use indentured servants as they had in the past? How would you describe the differences between slaves an ...

Question suppose the risk-free rate 007 and a security with

Question: Suppose the risk-free rate 0.07 and a security with a beta of +1 has an equilibrium expected rate of return of 0.06. What is the equity market premium? The response must be typed, single spaced, must be in time ...

Question in the early stages of recovery the sampp 500 and

Question: In the early stages of recovery, the S&P 500 and other broad-based stock market indexes generally rose at least 25%. Yet in the months of the first three quarters of 2002, these indexes dropped over 30%. Why di ...

Question project description term paperselect a news

Question: Project Description (Term Paper): Select a news article(s) that discuss the economic concept that you chose as a topic for your term paper. Usually it is enough to choose just one article, however if you can fi ...

Question photographs such as image b were extremely common

Question: Photographs such as image B were extremely common in the media in 1989, showing East Berliners shopping in Western stores. What do such images suggest about how the East's previous isolation was interpreted in ...

Question you are paying a series of five constant-dollar or

Question: You are paying a series of five constant-dollar (or real-dollar) uniform payments of $1830.5 beginning at the end of first year. Assume that the general inflation rate is 30.37% and the market interest rate is ...

Question imagine that a 10000 ten-year bond was issued at

Question: Imagine that a $10,000 ten-year bond was issued at an interest rate of 6%. You are thinking about buying this bond one year before the end of the ten years, but interest rates are now 9%. a. Given the change in ...

Question professor xavier is creating a budget for his

Question: Professor Xavier is creating a budget for his recently awarded 9-year research grant. His research requires machinery that has an initial cost of $49993. He will need to pay for maintenance on the machinery beg ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As