I HAVE SUBMITTED LIKE 30 DOCUMENTS TO THIS SITE SO I THINK I AM ENTITLED TO A LITTLE HELP HERE. MY PROJECT IS DUE TODAY Title:

I HAVE SUBMITTED LIKE 30 DOCUMENTS TO THIS SITE SO I THINK I AM ENTITLED TO A LITTLE HELP HERE.. MY PROJECT IS DUE TODAY

Title: Database Requirements for Grandfield CollegeIn this project part, you need to create an XML Schema, XMLdocument, XML transform, and XPath queries for an XSDschema that defines the structure for an XML document thatstores the approved software.Complete the following tasks:1. Create an XML Schema, that tracks the followinginformation:This assessment willbe evaluated usingthe project rubric.SD2520 Project3ProjectPartDescription/Requirements of Project Part Evaluation Criteria Name of software Vendor Category (i.e. productivity, developmentplatform, DBMS, and graphics) Support platforms Approved versions:o Hardware requirementso Software requirementso Price2. Create an XML document that contains at least 15different software titles with different categories,operating system requirements, and prices. You caninclude examples of common productivity software andoperating systems in your list.3. Create an XSLT that displays the following information: Software titles for each category, sorted byprice Software titles for each operating system,sorted by category The highest, lowest, and average prices of agraphics program for the Linux operatingsystem4. Create a Word document that lists the requirements forthe Grandfield College database.5. Create a preliminary design for the Grandfield Collegedatabase using Microsoft Visio.SD2520 Project4ProjectPartDescription/Requirements of Project Part Evaluation CriteriaSubmission Requirements: For this project part, you need to submit the followingfive files to your instructor:o An XML Schema (.xsd file)o An XML document (.xml file)o An XSLT document titled (.xslt file)o A Word document (.docx file)o A Visio file with preliminary database design(.vsd file)Due: Module 3Grading Weight: 10 %ProjectPart 2Assessment Preparation Checklist:To prepare for Project Part 1, revisit the assigned readings forModules 4 through 6 from your textbook, Introduction toDatabase and XML with jQuery. In addition, review the Module6 lesson that presents important points that you need toconsider before submitting Project Part 2.Title: Database Normalization, Creation, and ValidationIn Project Part 2, you need to create a relational database and aWeb page that allows faculty and staff at Grandfield College torequest hardware or software.Complete the following tasks: Normalize the preliminary design created in Project Part1.This assessment willbe evaluated usingthe project rubric.SD2520 Project5ProjectPartDescription/Requirements of Project Part Evaluation Criteria Create a database in MySQL that meets the normalizeddesign. In a Microsoft Word document, write SQL DMLstatements to populate the database. Populate the database with enough records to meet thequery requirements. Write and execute SQL queries that meet the followingrequirements. For each query, submit a screen shotshowing the query and the results.o Retrieve all software installed on the computerbelonging to a specific faculty member.o Retrieve the number of computers runningeach operating system, sorted with the mostpopular operating system at the top of the list.o Retrieve the graphics applications running onany computer belonging to a faculty member inthe Arts department. Create an HTML form that allows users to requestsoftware. The form should:o Allow users to select a category.o Use XSLT to display the approved software inthe category with a checkbox next to each one. Implement the following data validation using jQuery:o The department name is required.o The faculty ID must be a 4-digit numeric value.o The email address must be a valid format.SD2520 Project6ProjectPartDescription/Requirements of Project Part Evaluation CriteriaSubmission Requirements: For this project part, you need to submit the followingthree files to your instructor:o A Word document with SQL DML statementsand screen shots for each query (.docx file)o An XSL transform (.xsl file)o An XML document (.xml file, can be the sameone from Part 1)o A Visio file with the normalized database design(.vsd file)o A .mwb file