What changes would you make to the provided schema

Assignment Help Basic Computer Science
Reference no: EM13909457

1. Suppose that the small firm for which you designed the Netflix®-like DVD rental database has established an Internet presence and their sales are growing rapidly. You have been asked to examine the database to make sure that it can grow to support at least a million transactions per day. Your assignment is to examine the Oracle or MSSQL version of the Netflix schema provided that you have now reverse engineered into Visio or a database design tool of your choice, and identify performance and other scaling problems. The frequently occurring operational transactions are:

· A customer updating their wish list on the web.

· The receipt of a DVD, with the corresponding mailing of the next in-stock DVD from the customer's wish list.

· Monthly billing of each customer's credit card.

Within no more than two paragraphs discuss the following topics:

· What changes would you make to the provided schema so that it can scale to handle a million or more transactions per day?

· What indexes would you add?

· Would you denormalize? If you would denormalize, how would you maintain the denormalizations?

Reference no: EM13909457

Questions Cloud

Populate the graph with edges connecting concepts : Populate the graph with edges connecting concepts/classes as of the given statements above. You need to consider that these edges will be labelled by the predicate in the given statements
Show that for all sample functions except set of probability : Show that for all sample functions N(t, ω), except a set of probability 0, N(t, ω)/t 2/M for all sufficiently larget. Note: Since M is arbitrary, this means that lim N(t)/t = 0 WP1.
Future of managed health care delivery systems : Future of Managed Health Care Delivery Systems.Use eight to ten scholarly and/ or peer-reviewed sources and  the following guide as you write your proposal and bibliography
Cash flows are expected to grow at an annual rate : You are evaluating the potential purchase of a small business currently generating $42,500 after-tax cash flow (Do=$42,500). On the basis of a review of similar-risk investment opportunities, you must earn an 18% rate of return on the proposed purcha..
What changes would you make to the provided schema : What changes would you make to the provided schema
Arctic cat produces snowmobiles for sale : Arctic Cat produces snowmobiles for sale. Identify some of the variable and fixed product costs associated with that production.
Data for the cytochome-c protein : Based on the amino acid sequence data for the Cytochome-C protein, chimpanzees and humans share an identical coding sequence. What other species identified on the chart has a coding sequence that is most closely related to the humans and chimpanze..
Investments at the time of the last deposit : At the end of each year Mr. Smith deposits $6,000 into an investment fund. The fund pays out interest each year at an annual effective interest rate of 6%. Mr. Smith is only able to reinvest this interest at an annual effective interest rate of 4%. w..
Why does hamlet wish too unnecessarily solid tissue : 1. Why does Hamlet wish this "too, unnecessarily solid tissue would condense"? What's the explanation behind his self-dangerous slants? Under what circumstances, and at which scraps of the play, does Hamlet harp on the probability of conclusion his o..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  How will dns be accessed by the lsdg systems

How will systems receive IP addresses. Explain. How will DNS be accessed by the LSDG systems. Explain. Explain how files on the network may be accessed by LSDG.

  Write a program with three radio buttons

Write a program with three radio buttons and circle. ( You can choose whether you draw the circle or if the circle is a label image.) When the user clicks on the first radio button

  Capacity as a systems analyst

In your capacity as a systems analyst, you may face situations in which you encounter an ethical dilemma. For example, you may be asked to design a system that supports an activity with which you personally disagree

  Linear programming model to be formulated and used

What are the assumptions for a linear programming model to be formulated and used?

  Write for loops to produce the following output

Write for loops to produce the following output

  Assignment- quantifying risk and its impact

Assignment: Quantifying Risk and Its Impact, Assignment Instructions: Review the risk events identified in the Gauchito Project Plan in Doc Sharing. Using the Gauchito risk events as an example, make a list of at least ten risk events to your proje..

  A store gives a discount for senior citizens

A store gives a discount for senior citizens

  What is a hash value

What is a hash value, and why do you think it is important?

  Project in designated area of coastal zone is significant

Have you contacted State Historic Preservation Office (SHPO) to see if the project is in designated area of coastal zone which is significant to the study, understanding, or illustration of national, state.

  Which is the correct statement for constructor implemention

In a multifile, object-oriented C++ project, which is the correct statement for the constructor implementation, given that the constructor is correctly defined in the class definition file?

  Actions for network devices, topologies, and network attacks

Identify the malicious threat sources to physical security and their corresponding countermeasures

  Draw a structured flowchart describing the steps

1. Draw a structured flowchart describing the steps you would take to cook popcorn in a microwave oven. Include at least one decision. 2. Create the pseudocode to go along with the flowchart created in question above.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd