Hi - Can you help with these and get them back to me by the end of the week? By Friday perhaps? And tell me what a fair price would be :)

I was very pleased with your work last time!

Thanks!

Trisha

Learning SQL (SQL Lab) In-class Activity (please post discussion in Blackboard) Assignment: (adapted and updated with approval from a project designed by Dr. Wilcox, 1996) This assignment is designed to gain hands on experience with Access by creating tables and designing SQL statements. Please use the posted PowerPoint Presentation in order to better understand SQL and get some hints for the below tasks. Your project is based on the tables with a similar design and similar SQL questions. Task #1: Create the 3 below tables (open Access and then a blank database; call your database \"yourlastnameSQLLab\"; click on the Table tab and then design view; you can now create the ANIMAL table; the fields are AnimalName (text), AnimalType (text), Weight (number), DateOfBirth (text), and FavoriteFood (text); now you can populate the table in the datasheet; do the same thing for the FeedingSchedule and KeeperName tables; RULE - do not use spaces for table or column names - you can either use _ or Caps/Lower cases as above; an Access tutorial is available in the Course Documents section of the classroom): Animal AnimalName Happy Go Lucky Stripes AnimalType Elephant Chimpanzee Tiger Tiger Weight 3000 40 250 200 DateOfBirth 1/20/02 4/6/04 5/5/06 3/23/01 FavoriteFood Oranges Popcorn Raw Rabbit Lamb FeedingSchedule Day Monday Monday Monday Monday Tuesday Tuesday Tuesday Tuesday Wednesday Wednesday Wednesday Wednesday AnimalName Happy Go Lucky Stripes Happy Go Lucky Stripes Happy Go Lucky Stripes KeeperName Jena Jena Jena Paul Jena Kevin Kevin Paul Kevin Kevin Paul Jena NumberOfFeedings 5 3 3 1 5 5 3 1 2 3 2 1 Keeper KeeperName Jena Paul City Bellevue Omaha Telephone FavoriteFood Age 553-4567 Oranges 26 555-9880 Oranges 22 Kevin Linda Lincoln Nebraska City 567-4512 647-1122 Popcorn Oranges 18 35 Task #2: In Access, write SQL queries to do the following (do not use the Wizard or Design view within Access...click on Design View and a pop-up window will appear; click the red X, and you will see the letter SQL in the top left of the program; a PowerPoint tutorial is available under Course Documents which relates to the below queries): 1. 2. 3. 4. 5. 6. 7. 8. List the ages and telephone numbers of all keepers. List the names of all keepers younger than 25. List the names of keepers who feed Lucky. List the name and age of all keepers who feed Lucky. Use the IN sub query construct (nested SELECTS - see hints in the PowerPoint presentation). List the name and age of all keepers who feed Tigers. Use the IN sub query construct (nested SELECTS - see hints in the PowerPoint presentation). Change Kevin's age to \"19\" Insert a new record into the Keepers table with the values \"Jimmy\SQL Project Assignment: Using what you learned in the in-class activity complete the below tasks on your own. Task #1: Create the 3 below tables: Employee EmployeeName Address Lynn_Davis Omaha Tumininu_Oluyole Nebraska_Cit y Ann_Walker Blair Cappy_O'Johns Lincoln Telephone Degree Age 555-1234 MS-MIS 26 555-5678 MS-MIS 21 555-9012 555-3456 MBA CIS 24 20 ReportFrequency Day Monday Monday Monday Monday Tuesday Tuesday Tuesday Tuesday Wednesday Wednesday Wednesday Wednesday Thursday Thursday Thursday Thursday Friday Friday Friday Friday ReportName Assets Productivity Variance ProfitAndLoss Assets Productivity Variance ProfitAndLoss Assets Productivity Variance ProfitAndLoss Assets Productivity Variance ProfitAndLoss Assets Productivity Variance ProfitAndLoss EmployeeName Lynn_Davis Lynn_Davis Lynn_Davis Tumininu_Oluyole Lynn_Davis Ann_Walker Ann_Walker Tumininu_Oluyole Ann_Walker Ann_Walker Tumininu_Oluyole Lynn_Davis Ann_Walker Ann_Walker Tumininu_Oluyole Lynn_Davis Lynn_Davis Tumininu_Oluyole Tumininu_Oluyole Ann_Walker NumOfCopies 20 15 50 50 20 15 20 20 20 15 20 20 20 15 20 20 20 15 30 50 WeeklyReports ReportName Assets Productivity Variance ProfitAndLoss Information Equipment Lines_Of_Code Income Income Report_Size 500 10 50 410 Division AssetControl Programming Finance Accounting Task #2: In Access, write SQL queries to do the following (do not use the Wizard within Access): 1. 2. 3. 4. 5. 6. 7. List the ages and telephone numbers of all employees. List the names of all employees older than 22. List the reports requiring more than 30 copies to be produced. List the reports that have more than 100 pages. List the names of employees who run Productivity Reports. List the names and degrees of employees who run Profit and Loss Reports (P&Ls) List the names and degrees of employees who run reports with income information. 8. Change Lynn_Davis's phone number to 827-0000 9. Insert a new employee record: Gale_Smith, Bellevue, 293-2000, Ph.D., 30 (use SQL). 10. Delete the record you just inserted (use SQL). Task #3: Copy and paste your SQL syntax (your code) into a word document and attach completed assignment to the SQL Submit in the projects area. DUE: The end of Week 9. (the in-class lab is due the end of week 8, that needs to be emailed and not submitted into blackboard)