Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. Below is the closest I have gotten to the expected results but I only need the first 10 records displayed: SELECT TABLE_CATALOG,TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_SCHEMA ='information_schema');

Oracle 12c: SQL The JustLee DB contains a table called PROMOTION. It does not have any of the relationships to other tables we discussed last week. It is not a one-to-one, one-to-many, or many-to-many relationship. There is no crowfoot on the ER diagram related to this table. However, there IS a relationship depicted in the ER diagram between the PROMOTION and the BOOKS tables. What kind of relationship do you think it is? Please check the structure of these two tables and the data contained in them in your ApEx schema running SQL commands using the clauses you have learned this week. Which commands did you use and what results did you see?

Using the Categories, Subjects, and Classes tables, list the category description, SubjectID, SubjectCode, and SubjectName for all subject that are taught on Wednesdays.  Do not list any subject more than once.

How do we choose a model for Microsoft Access table design?

For this problem create a (temporary) table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the temporary table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table,then the procedure makes sure the total number of courses taught in the temporary table is up-to-date. You must name your procedure: Written in PostgreSQL

Task 5:The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. I found the answer but it wroten on paper so its really hard to understand what it is, that's why I am posting this question again.

Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.

Customer Equipment Loan id equipmentCode name id name H description RentalRatePerDay address 04 equipment Code e contact startDate dateOfBirth returnDate occupation DamageReport reportId damageType (iii) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear. ID Name Address Contact DateOfBirth Occupation Number of Equipment Rented Total Rent NumDamage ST82J Charles Toles 23 Haig Road 92142331 15-03-1976 Teacher 20.00 S823F Damien Low 5 Still Road 88128833 05-07-1985 Teacher 1 16.00 1 3 sa56F Audrey Ng 10 Bedok Road 82138213 23-01-1988 Nurse 3 150.00 1 2 Jalan Eunos 8 Jalan Melayu Ali Bin Mohd Hassan 10 Clomonti Road 91239123 4 S345G Betsey Tan 98981212 12-05-1990 Cartoonist 4.00 99234J Peter Lee 97589758 04-03-1991 Student 1 24.00 SATSZ S575J Ravi S/O Ramasamy 12 Jurong Road 6 10-07-1997 IT Programmer 0.00 7 82223333…

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.

How do we decide which model to create in Microsoft Access as our table creation environment?