Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(10 points)Below is some data that has been provided to an online merchant in a letter. This letter can be considered unstructured data. Based on

image text in transcribed
image text in transcribed
image text in transcribed
(10 points)Below is some data that has been provided to an online merchant in a letter. This letter can be considered unstructured data. Based on the definition ofstructured and unstructured data, convert the following letterto structured data. 1. John, I'm a first-time customer and I'd like to purchase one Atrium Lounge Chair at the cost of $300.00. I understand that the shipping would be $50 for an item this big. Please send an invoice so that I can provide you with a check payment for the items being purchased. Thanks in advance, Lisa Jones ANSWER: 6 8 9 (10 points)You work at a local game store. Duringyour shift, a customer comes in to the store and makes a purchase and you record the following. After sitting in your DBMS110 class, you realize that there is a better way to organize this data. In the space below, convert into structured data. 2- Sellersburg Game Store Receipt Date: 03/30/2011 Customer Info Tracey Smith 18 Lake Street Sellersburg, Indiana 47172 ltems purchased (2) Xbox 360 Controller-$20 . Halo Reach Game-$40 Headset-$50 Address: 134 Circle Road, Jeffersonville, IN 47130 Phone: (812) 123-4567 3. (20 points) Use the following definitions to identify the terms associated with it. The primary logicalstorage structures of anythe ORACLE database a. b. Logical unit of database storage space allocation made up of contiguous data blocks c The Oracle Database physically stores tablespace data here d. Small binary file that records the physicalstructure of the database e. A set of extents which have been allocated for a specific type of data structure f. Smallest logical storage unit of a database & Information about database name and database unique identifier (DBID) h. Specific number of bytes on the physical hard disk i. The first data block of every segment contains a directory of the in the segment i SYSTEM and SYSAUX are examples of

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_2

Step: 3

blur-text-image_3

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

More Books

Students also viewed these Databases questions

Question

What is required for a firm to become "ISO 9000 certified"?

Answered: 1 week ago