Database System

You bear been asked to clear a postulatesbase rule intent for a persomal posse (or a posse of your choosing) that wants to trace its customers/clients, appointments, billing, and employees. Structured inquiry expression (SQL) is used to produce the postulatesbase schema, retain the postulatesbase chronicles, and conclude administrative tasks. In importation to the Database Rule Intent template that includes minority headings (contemplation draft), acquiesce a SQL Statements muniment of 4–5 pages established on the existence correlativeness (ER) type completed in Week 3. Complete the following:

• Include SQL propositions that use postulates determination expression (DDL) commands to produce the postulatesbase schema determined in the ER diagram produced in Week 3.
  • Include indexes, constraints, and correlativenesss.
• Include SQL propositions that use postulates fabrication expression (DML) to do the following:
  • INSERT 15 chronicles into each board.
  • UPDATE 5 sets of chronicles in each board using one biased criteria per update proposition (e.g., EXACT MATCH, LIKE, BETWEEN, IN, or HAVING).
  • DELETE 2 chronicles from 1 board established on biased criteria (e.g., EXACT MATCH or LIKE).
• Create stored procedures to buttress regaining of the postulates from the postulatesbase, using SELECT propositions to conclude the following:
  • Aggregate (group) functions (count, avg, min, max, sum)
    • Write 4 queries using order functions.
  • Group By
    • Write 2 queries using the Order By, Having, and Order By syntax.
  • Simple queries
    • Write 4 queries that touch postulates in 1 board.
  • Join queries
    • Write 4 queries that accompany 2 or over boards.
• Add this minority to the SQL Statements minority of your postulatesbase rule intent.
• Name the muniment as follows:
  • yourname_IT600__IP4.doc
• All sources should be cited twain in-text and in the References minority by using APA format.
• Submit the muniment for grading.