Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q3. Memory Storage Calculations Size 1 Bvte Access Datat Text- 1 byte per character, Number/Byte, Yes/No Number/Integer Number/Long Integer, Number/Single Number Double, Date Time, Curr

image text in transcribed

Q3. Memory Storage Calculations Size 1 Bvte Access Datat Text- 1 byte per character, Number/Byte, Yes/No Number/Integer Number/"Long Integer", Number/Single Number Double, Date Time, Curr es 4 B es Multiplier Prefixes Decimal-stvle 1000 Binary-stvle 1024 1024 1024 1024 Kilo (K Mega Giga (G Tera 1000 (a) Your PC has a 24-inch widescreen flat panel monitor, whose resolution is 1920 1200 pixels. Ifyou are currently using 32 bits of color information per pixel, how much storage would be required to make a "screen shot" of your PC screen, without compression? Express your answer in binary-style MB (b) The reptile pet owners association is considering adding a video clip posting capability to its website. A member survey suggests that the number of clips that would be posted on the site would be about 30,000. Assume each clip is 300 x 400 pixels resolution, with 24 bits per pixel and 30 frames per second, and that clips average 3 minutes long Disregarding the audio component of each clip, and assuming you store compressed format with an average compression factor of 40, how much storage will be needed for the video clip library? Express your result in binary-style GB the clips in a Now consider the following table PRODUCT ProductID, Name, Description, Price, ShippingPounds, DateIntroduced, MaintenanceAgreementPrice, MaintenanceAgreementTerms, MaintenanceAgreementMonths) Attribute ProductID ame Description Price ShippingPounds Datelntroduced MaintenanceAgreementPrice Currency MaintenanceAgreementTerms Text, 255 characters MaintenanceAgreementMonths Integer (short" style) Access Datatype Text, 12 characters Text, 50 characters Text, 200 characters Currency Number: "single" format Date/Time Estimate the binary-style MB required for the PRODUCT table above, assuming there are 10,000 products (c)

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

Samsung Galaxy S23 Ultra Comprehensive User Manual

Authors: Leo Scott

1st Edition

B0BVPBJK5Q, 979-8377286455

More Books

Students also viewed these Databases questions