Question: Need some help with this database assumptions problem: Use the business information provided, determine the size of the new database. List what you will need
Need some help with this database assumptions problem:
Use the business information provided, determine the size of the new database. List what you will need to do to ensure the new database can accommodate the data described below. Do not use page sizes in your calculations. Use the row size and number of rows.
of the data for the database is going to be broken up into three main tables: products, customers, and invoices.
There will be products in the products table with each row being characters. Each character is bytes.
There will be million customers in the customer table with each row being characters. Each character is bytes. The company plans to expand their customer base by each year.
Invoices will likely include products. The invoice table includes a primary key, invoice key, product key, and customer key. There are four columnskeys Assume each key is bytes in length.
A customer will be invoiced times per year.
Reporting requires there to be an index on invoices for sorting by products. Indexes are to bytes in size for each column value indexed.
Assume the database will be used for years when determining your estimate.
System requires concurrent users
I have determined the products and customers in the table I have, but could use a second opinion. I am also hoping to understand the invoices requirement better.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
