Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain for further understanding You have decided to start a new e-commerce site that you anticipate will host billions of products and you hope

image text in transcribed

Please explain for further understanding

You have decided to start a new e-commerce site that you anticipate will host billions of products and you hope millions of users. You realize you will need a database system to keep track of all your data. Question 5.1 What tables might you need for this? For example, a table to log each order a user placed for a product might be a good idea. List at least two other tables that you want to include in your design. (There are many correct answers). Question 5.2 Let's calculate the size of one of our tables. Consider the above example of a table to log orders. We would like to keep track of the following: - Order ID: int64 - Product ID: see part 6.2 - User ID: see part 6.3 - Quantity: int32 - Timestamp: 4 bytes - IP address: 4 bytes - Mailing address: char[100] We want the ability to host 5 billion products. How many bits should the Product ID be to store a unique ID for each product? Given our answer above, what data type should we use? - tinyint (1 byte) - smallint ( 2 byte) - int (int32 4 bytes) - bigint (int64 - 8 bytes)

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2010 Barcelona Spain September 2010 Proceedings Part 2 Lnai 6322

Authors: Jose L. Balcazar ,Francesco Bonchi ,Aristides Gionis ,Michele Sebag

2010th Edition

364215882X, 978-3642158827

Students also viewed these Databases questions

Question

Have I incorporated my research into my outline effectively?

Answered: 1 week ago