Reference no: EM131246915
Consider the SQL schema generated for the ONLINE_AUCTION database in Laboratory Exercise 8.29 for which the relational database was created and populated in Laboratory Exercise 9.14.
a. Create the database tables in MySQL.
b. Create comma separated data files containing data for at least 20 items with at least 10 buyers and at least 10 sellers. Observe the queries below and make sure that your data will be appropriate for those queries.
c. Using the MySQL loader command, load the data created in (b) into the database.
d. Write SQL queries for the following and execute then in a MySQL interactive session.
i. Retrieve item numbers and descriptions of items that are still active (i.e. bidding has not closed) along with their current bidding price.
ii. Retrieve the item numbers and descriptions of all items in which the member with member id abc24 is the winner.
iii. Retrieve the member ids and names of members who have an average rating of 8.0 or above.
iv. Retrieve the bidding history for the item with item number i246. The bidding history should contain a chronological listing of all bids till the current time including the member id of the bidder and the bidding price.
v. Retrieve the item number and titles of items that fall under the /COMPUTER/HARDWARE/PRINTER category and have "HP" in their titles and on which bidding has not yet closed sorted by time of bid closing.
|
Advice to hotrod ceo on the strategies to implement
: PRS303 Hotrod and the Case of the Lethal Floor mats Case Study. Write a Press Release that conveys this information and includes all of the elements of a good press release. Provide advice to Hotrod's CEO and senior management on the strategies to i..
|
|
Strategies firm with market power can adopt to increase
: All of the following are strategies a firm with market power can adopt to increase it profits over time except: A. erecting barriers to entry. B. setting price equal to the marginal costs of production. C. mergers with, and acquisitions of, competing..
|
|
Analyze the role of the selected country central bank
: Evaluate current global economic conditions and their effect on local macroeconomic indicators in your selected country. Consider forecasts for population growth, GDP growth, GDP per capita growth, export growth, and sales growth.
|
|
Retrieve the last names of all department managers
: Specify and execute the following queries using the RA interpreter on the COMPANY database schema.
|
|
Create the database tables in mysql
: Retrieve the item number and titles of items that fall under the /COMPUTER/HARDWARE/PRINTER category and have "HP" in their titles and on which bidding has not yet closed sorted by time of bid closing.
|
|
Describe the importance of maintaining integrity rules
: Many times, database designs do not include the proper use of indexes. Provide a specific example on how an index could be used in order to enhance user search experience. List specific fields that you would index. Analyze what would occur if the ..
|
|
Specify and execute the following queries
: The attribute names are self-explanatory. "qoh" stands for quantity on hand. Specify and execute the following queries using the RA interpreter on the MAILORDER database schema.
|
|
Statement of criminal justice philosophy
: Statement of criminal justice philosophy - Some or all components of portfolio are missing; portfolio lacks any coherent structure; elements are poorly identified or not at all; TOC is missing; writing not indicative of any thought or research.
|
|
How the aggregate function is used to leverage talent
: Synthesize how aggregate functions help the organization understand employee performance. Provide an example that supports how the aggregate function is used to leverage talent within the organization. Note: The Strayer Oracle Server may be used t..
|