Query Results - RIGHT Outer Join - Using the week 2 lecture database, if you wanted to see all the isbns from the books table and any matching isbns from the order_lines table, you'd want to do an outer join as such (because not every book stocked has been ordered): SELECT books.isbn, order_lines.isbn FROM books LEFT JOIN order_lines ON books.isbn = order_lines.isbn; How would you get th...

Creation of Entity-Relationship Diagrams Fleet Truck Maintenance. - Organization Name: Huffman Trucking Locations: All hub locations Requester: IT Project Manager Description of Request: Develop Entity-Relationship Diagrams for Fleet Truck Maintenance. Background of Request: Smith Consulting developed entities and attributes for Fleet Truck Maintenance but did not develop the database...

Create the keys and relationships between tables for the Driver LOG - Using MS Access, create the keys and relationships between tables for the Driver LOG from the file attached.

ACCESS 2000 - (Note: cut and paste the SQL answers for questions 1 and 2 into a word document. 1. Write the SELECT FROM WHERE code that will select the row from the authors table in the attached WEEK1_Q1_Q2_ACCESS2000 database that has “twain, mark” NOTE: You can use: SELECT * or SELECT author_name or...

Running a Query - Why wont this query run and how would you write it correctly? Major hint: try and run the query (use the database attached to Week 2's lecture) ... you'll get an error message that should explain: SELECT isbn FROM books INNER JOIN order_lines ON books.isbn = order_lines.isbn;