When eliminating rows, columns, and tables, what should you keep in mind?

What are the differences between the JOIN … USING and JOIN … ON approaches for joining tables?

question 6 use the picture below to answer the following question Add a ZIP field/column to the customer table.

Say you have a table called Exercise with two fields: Type_of_Exercise and Calories_Burned. How would you calculate the total calories for each exercise performed for this report? (table not given. the table should be explained theoretically)

Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.

Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.

question 5  use the following picture to answer the following question Assuming all other tables are created, write a statement to create Inventory table with a Composite Primary key (INVID, ITEMID) and two Foreign Keys (INVID and ITEMID).