Reference no: EM131308263
Consider the following "tilde table" that could be represented by the file cars.txt for persistence
MAKE~MODEL~TYPE~PRICE
Toyota~Camry~Sedan~18000
Toyota~Tacoma~Truck~19000
Ford~Mustang~Sport~21000
Chevrolet~Corvette~Sport~48000
Ford~F150~Truck~25000
Toyota~Highlander~SUV~35000
Since this is just for education purposes we will allow tilde tables to have the following attributes and limitations:
-at most 12 columns
-first row represents column names
-all columns are strings (unless you want to define some types)
-column values and column names are limited to 16 characters
Write a java class named Algebra that will eventually have static methods representing the relational algebra and one additional method which displays the contents of a tilde table. All methods except for the display method return a string indicating success or an error message and for every successful operation a new tilde table is produced on disk. For now implement the method to show the table, the project operation, the restrict operation, and one other of your choice from this list:
JOIN (assumes natural inner join), UNION, MINUS, INTERSECT, DIVIDE
So the main body of a driver program might look like this:
//restrict the cars table to toyotas producing a table named toyotas
Algebra.Restrict("cars","MAKE='Toyota'","toyotas");
//project just three columns from the toyotas table producing a table named answer
Algebra.Project("Toyotas","Make,Model,Price","answer");
//display the contents of the answer table
Algebra.Display("answer");
Make your program generalizable. That is, it should work with any tilde table. Since the assumption for option 1 is that tables may not fit into memory you are not allowed to load all the rows into an array or other collection. You can of course load a list of column names or something small like that into memory. If you can think of a way to clean up the temporary results tables that would be good. In order to limit the grammar your restriction condition can be limited to a single condition (so no ANDs and ORs) and your comparitors can be limited to these six: =, >, <, >=, <=, !=
Explain the 4 stage model of supply chain integration
: Explain the 4 stage model of supply chain integration and how it would apply to a business trying to enter a global market.
|
Two machines are being considered for manufacturing process
: Two machines are being considered for a manufacturing process. Machine A has a first cost of $75, 200, and its salvage value at the end of six years of estimated service life is $21,000. The operating costs of this machine are estimated to be $6, 800..
|
Distribute product or service to consumer or customer
: What is the specific product or service you chose?- What is the method used to distribute the product or service to the consumer or customer?
|
How much money the company needs to borrow in july
: The treasurer for Chic Man Clothing must decide how much money the company needs to borrow in July. The company expects sales of $400,000 for July. The company has observed that 25% of its sales is for cash and that the remaining 75% is collected in ..
|
Write a java class named algebra
: Write a java class named Algebra that will eventually have static methods representing the relational algebra and one additional method which displays the contents of a tilde table
|
Describe the article in detail
: Locate a recent article discussing how ISIS uses the internet to further its terrorist recruiting, its propaganda, and its terrorist activities.
|
Old office building with an estimated remaining service life
: Your firm is considering purchasing an old office building with an estimated remaining service life of 25 years. Recently, the tenants signed long-term leases with fixed rental rates for the first 5 years; thus, the current rental income of $150,000 ..
|
What was your rate of return on the stock
: Similar to problem 11: you have $60,000 to invest. You put $30,000 in GAP stocks (beta of 1.8); $15,000 in Chesapeake Utilities (beta of .8); $15,000 in Anheuser-Busch (beta of .6). What is you portfolio beta? You own 1 share of Martha Stewart Omnime..
|
What is the beta of your stock portfolio
: ou expect to receive a $1.00 dividend the next time your stock pays dividends. If your required rate of return (RRR) on the “dog” is 20% and the growth rate is 2%, what should this stock sell for? You have $80,000 to invest in stocks. You select 2 s..
|