- Create the database tables in Oracle APEX.
- 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
- Using the MySQL loader command, load the data created in (d) into the database.
- Write SQL queries for the following and execute them in Oracle APEX:
undefined
- Retrieve item numbers and descriptions of items that are still active (i.e. bidding has not closed) along with their current bidding price.
- Retrieve the item numbers and descriptions of all items in which the member with member id abc24 is the winner.
- Retrieve the member ids and names of members who have an average rating of 8.0 or above.
- 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.
- 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.
undefined
Deliverables:
undefined
- Data files in CSV format
- All DDL SQL commands and queries (text and screenshots).
0 comments