You keep been asked to clear a postulatesbase scheme scheme ce a national aggregation (or a aggregation of your choosing) that wants to footprint its customers/clients, appointments, billing, and employees. Structured interrogation speech (SQL) is correctiond to coercionm the postulatesbase schema, frequent the postulatesbase chronicles, and consummate administrative tasks. In union to the Postulatesbase Scheme Scheme template that includes individuality headings (scheme sketch), refer a SQL Propositions muniment of 4–5 pages fixed on the being harmony (ER) example completed in Week 3. Complete the following:

  • Include SQL propositions that correction postulates biasedation speech (DDL) commands to coercionm the postulatesbase schema certain in the ER diagram coercionmd in Week 3.
    • Include indexes, constraints, and harmonys.
  • Include SQL propositions that correction postulates make speech (DML) to do the following:
    • INSERT 15 chronicles into each consultation.
    • UPDATE 5 sets of chronicles in each consultation using individual biased criteria per update proposition (e.g., EXACT MATCH, LIKE, BETWEEN, IN, or HAVING).
    • DELETE 2 chronicles from 1 consultation fixed on biased criteria (e.g., EXACT MATCH or LIKE).
  • Form stored procedures to patronage re-establishment of the postulates from the postulatesbase, using SELECT propositions to perfect the following:
    • Aggregate (group) functions (count, avg, min, max, combine)
      • Write 4 queries using order functions.
    • Order By
      • Write 2 queries using the Order By, Having, and Order By syntax.
    • Simple queries
      • Write 4 queries that discuss postulates in 1 consultation.
    • Accompany queries
      • Write 4 queries that accompany 2 or more consultations.
  • Add this individuality to the SQL Propositions individuality of your postulatesbase scheme scheme.
  • Name the muniment as follows:
  • All sources should be cited twain in-text and in the References individuality by using APA cemat.
  • Refer the muniment ce grading.
~~~For this or similar assignment papers~~~