Code:
(940010, 003114, 111321, 80, 'Yes', 80, 'Yes'),
(940011, 003115, 111322, 400, 'No', 0, 'No'),
(940012, 003116, 111322, 700, 'No', 0, 'No'),
(940013, 003117, 111322, 70, 'Yes', 70, 'Yes'),
(940014, 003118, 111323, 890, 'Yes', 90, 'No'),
(940015, 003119, 111323, 700, 'No', 0, 'No'),
(940016, 003120, 111323, 690, 'Yes', 90, 'No'),
(940017, 003121, 111323, 0, 'No', 0, 'Yes'),
(940018, 003122, 111324, 500, 'No', 0, 'No'),
(940019, 003123, 111324, 70, 'Yes', 70, 'Yes'),
(940020, 003124, 111325, 790, 'Yes', 90, 'No'),
(940021, 003125, 111325, 700, 'No', 0, 'No'),
(940022, 003126, 111325, 80, 'Yes', 80, 'Yes'),
(940023, 003127, 111326, 0, 'No', 0, 'Yes'),
(940024, 003128, 111327, 80, 'Yes', 80, 'Yes'),
(940025, 003129, 111327, 750, 'No', 0, 'No'),
(940026, 003130, 111328, 90, 'Yes', 90, 'Yes'),
(940027, 003131, 111328, 0, 'No', 0, 'Yes'),
(940028, 003132, 111329, 750, 'No', 0, 'No'),
(940029, 003133, 111329, 0, 'No', 0, 'Yes'),
(940030, 003134, 111330, 0, 'No', 0, 'Yes'),
(940031, 003135, 111330, 860, 'Yes', 90, 'No'),
(940032, 003136, 111331, 570, 'Yes', 70, 'No'),
(940033, 003137, 111331, 0, 'No', 0, 'Yes'),
(940034, 003138, 111331, 525, 'Yes', 75, 'No');
Above are the values entered for the booking table. In order from left to right they are, bookingcode, delegatecode, eventcode, bookingfee, bedandbreakfast, bedandbreakfastfee and presenting.
Code:
(410251, '103 Tonbridge Road, Wateringbury, Nr. Maidstone, Kent', 'Premier Inn', 70, 08715278706),
(410252, 'Western Avenue, Chatham, Kent', 'Ramada Encore', 80, 08448010313),
(410253, 'Sandway, Lenham, Maidstone, Kent', 'Chilston Park', 80, 08450727426),
(410254, '12 New Dover Road, Canterbury, Kent', 'Ersham Lodge', 75, 01227463174),
(410255, 'London Road, Bapchild, Sittingbourne, Kent', 'Hempstead House', 90, 01322615136);
This is the venue values... venuecode, venueaddress, venuename, venuecost and venuephone.
Code:
(111321, 410251, 205101, 'Project Proposals', '2010-09-07', 'Anthony Keene'),
(111322, 410251, 205101, 'Database Design', '2010-09-08', 'Alan Barnes'),
(111323, 410252, 205102, 'Linux vs Windows', '2010-09-14', 'John Grey'),
(111324, 410252, 205103, 'Software Development', '2010-09-21', 'Ken Wills'),
(111325, 410253, 205103, 'Business Study', '2010-09-22', 'Carol Ellis'),
(111326, 410253, 205104, 'Keyboard Events', '2010-09-28', 'Roy Ives'),
(111327, 410254, 205105, 'Network Topology', '2010-10-04', 'Terry Lyons'),
(111328, 410254, 205105, 'Network Planning', '2010-10-05', 'Martin Hardman'),
(111329, 410255, 205106, 'Web Servers', '2010-10-12', 'John Lord'),
(111330, 410255, 205106, 'Database Servers', '2010-10-14', 'Colin Nauman');
Finally the event table values... eventcode, venuecode, coursecode, eventname, eventdate, presenter.