Chapter 1, Problem 14QY

Design by using come; -

Please elaborate on the kind of details each of the four user groups need.

Please help me as this is in regards to Oracle 12 database Question 7  IN SELECT statement you always add SELECT , FROM and WHERE keywords because without WHERE condition you wouldn't know which data you search Question 7 options:   True   False Question 8  What will the following statement return after execution? SELECT employeenumber, lastname, email FROM products ORDER BY employeenumber DESC and email; Question 8 options:   The results are sorted first numerically and then alphabetically.   The results are sorted first numerically from high to low and then alphabetically.   The results are sorted first alphabetically and then numerically.   The query returns an error. Question 9  Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000? Question 9 options:   ORDER BY SALARY > 5000   GROUP BY SALARY > 5000   WITH SALARY > 5000   WHERE SALARY > 5000

please use sql to answer the following question an erd has been provide Task 1:  Creating a Logon Procedure    The home page of the Brewbean’s Web site has an option for members to log on with their IDs  and passwords. Develop a procedure named MEMBER_CK_SP that accepts the user ID and password  as inputs, checks whether they match a valid logon, and returns the member first name+lastname  and cookie  value.     The name should be returned as a single text string containing the first and last name.  The head developer wants the number of parameters minimized so that the same  parameter is used to accept the password and return the name value. (passwd Paramater as IN OUT   use passwd as INPUT  firstname||lastname  as OUTPUT)     Also, if the user doesn’t enter a valid username and password, return the value INVALID in a parameter named  p_check.     Test the procedure using a valid logon first, with the username rat55 and password kile. Then try it with an invalid logon by changing the…

Using mysql client   create a database named supermarket   create a table named groceryitems in the supermarket database. Groceryitems table should have the following information : itemname, itemtype(i.e fruit, vegetable, pantry, meat, dairy etc), item description, price per unit, quantity available. Use appropriate data type for each of the columns. Itemname should be the primary key.   Create a php page through which you can connect to the grocery database and you can insert information into the grocery table.   The php page displays an interface , texboxes for itemname , textfield for item description, radio button for item type, text box for unit price , text box for quantity available and a submit button.   Once you click the submit button the php file should first validate the data types inserted.   After successfully adding a row of information the same php page should show a confirmation message about successful information in the table.   Make the radio buttons used for…

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.

However, there IS a relationship depicted in the ER diagram between the PROMOTION and the BOOKS tables. What kind of relationships do you think it is? Which commands did you use and what the results . you see?

SQL DO NOT COPY FROM OTHER WEBSITES Upvote guarenteed for a correct and detailed answer. Thank you!!!

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