Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started