Part A –:Using the database provided, write SQL queries that satisfy the following information requests.•Your queries should produce the expected result (including column names, grouping, duplicate removal, and ordering) shown in each information request below.•Your queries must order the result as requested. If the information request does not mention a required ordering, your query does not need to order the result.•Where appropriate, your queries must remove duplicates from the result.•Simple queries are preferred. Marks may be lost for unnecessarily complex queries.Part B – Form development activity: Using Kware database, develop a form to capture new customer details using a suitable title and a current date, which can be used for data entry operation. You are allowed to use any suitable user-friendly layout to develop the form. Strictly, do not copy from others.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here