Data Mining Project one

Requirements: Produce a database program or Excel Spreadsheet Program that fetches Event and Ticket information from the internet and allows the user to add a Markup percentage to the Ticket Price, do lookups on Events that display the available tickets and the pricing with a markup. Specifically the user should be able to filll the program with a list of URL’s then hit an Update Button which populates the database from the list and the data from each url. There should also be a field in the TICKETS table that is entered by the user as a percentage markup. There should be a look up facility so that the user can find by any field in the ARTIST Table that produces a report (worksheet) showinf results from the search. (see spreadsheet attached) Customer populates records by entering URL/s into a field, the program is ran and goes to each URL and extracts the following data from the page and enters it into a number of tables Table 1 = ARTIST artist_event_id (assigned by system) artist_event_name (retreived from web page) artist_venue (retreived from web page) artist_location (retreived from web page) artist_event_date (ideally entered as a database date-time value) Example of code to extract from: Sample URL= [login to view URL] WWE Presents: Raw World Tour Madison Square Garden New York, NY Sun, Dec 26, 2010 07:00 PM Table 2 = Tickets artist_event_id (assigned by system as above) tickets_id (assigned by system) Section (retreived from web page) Row (retreived from web page) Seats (retreived from web page) Qty (retreived from web page) Price/Ticket (retreived from web page) Markup (variable assigned by the user) Example of code to extract from: Sample URL= [login to view URL] Section Row Seats Qty Price/Ticket Here are some other sample url’s [login to view URL] [login to view URL] [login to view URL] [login to view URL] It would be nice to include some kind of method to change the FETCH functions incase the existing format of the web page URL's changes.