Suppose you have the following graph, what is the correct representation of its edges? A B O O C D E ○ E= {(A,B), (B,D), (C,B), (E,D), (C,E), (F,E)} O E= {{A,B}, {B,D}, {C,B}, {E,D}, {C,E}, {F,E}} F E= {(A,B), (B,C), (B,D), (C,E), (D,E), (E,F)} E= {(A,B), (B,A), (B,C), (C,B), (B,D), (D,B), (C,E), (E,C), (D,E), (E,D), (E,F), (F,E)} None of them

List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.

Order of tuples in a table is irrelevant, true or false?

What did you take away from the process of creating your religion characteristics table?

Think about the foreign-key constraint on the instructor's department name property. Please provide examples of additions and deletions that could go against the foreign-key restriction.

Convert the following table to third normal form (3NF). In this table, StudentNum determines StudentName, NumCredits, AdvisorNum, and AdvisorName. Advisor Num determines AdvisorName. CourseNum determines Description. The combination of StudentNum and CourseNum determines Grade. STUDENT (StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, CourseNum, Description, Grade). Identify the primary key for the original table and the primary keys for the resulting tables. Indicate the foreign keys with italic font. Give meaning names to the resulting tables.

Think about the foreign-key constraint on the instructor's department name property. Please provide examples of additions and deletions that could go against the foreign-key restriction.

SQL List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) Order the output by category. I have this hint, but I cannot figure out what to write within the HAVING clause: SELECT CATEGORY, ITEM_ID, DESCRIPTION   FROM ITEM  WHERE EXISTS (SELECT COUNT(*) FROM ITEM I                        WHERE I._____________ = ITEM._______________                        GROUP BY CATEGORY                       HAVING ___________________) ORDER BY ________________;

Write an SQL query that uses a multiple-column subquery in a FROM clause. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses a subquery with the GROUP BY statement and HAVING clause. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses a multiple-row subquery in a WHERE clause. The subquery will include the GROUP BY statement and another multiple-row subquery in a HAVING clause. Explain what the query is intended to do. Write an SQL query that joins three tables and uses any type of a subquery. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses the DECODE function. Explain what the query is intended to do.

Composite main keys have candidate keys. Your reaction?