This paper circulates around the core theme of •Your queries should produce the expected result (including column names, grouping, together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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.