Summary: To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this project, the ERD is provided to you. Deliverables: SQL Script with your name as follows: YourLastName_Project_Ph3.sql. MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc. ZIP file to include the two files mentioned above. Required Software: MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench. Follow Step 1-3 for your Course Project Phase phase 1, to install the required software components. Lab Steps: Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships.  You will need to have a clear understanding for these components to create your database using MySQL. Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table Create a new Database, as you did in your Course Project Phase 1 deliverable and you already created a database using the MySQL DBMS.  Reference the attached video (Course Project Ph1 Video.mp4), for a demonstration to create a new Database using MySQL. This video was initially presented to you for phase 2 of your project.  Also, reference the supplemental text: Available for Free download as part of our UC Library.  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2.  Link to UC Library: http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=nlebk&AN=291311&site=eds-live&ebv=EB&ppid=pp_ii Utilize the SQL dialect you learned so far in this course for MySQL.  Use the file supplemental textbook:  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill, as supplement your knowledge of the MySQL dialect.  Create your SCRIPT file to be named: YourLastName_Project_Ph3.sql. Step 3: Include the following commands at the tops of your scripts: SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS STUDENT; DROP TABLE IF EXISTS CAMPUS; DROP TABLE IF EXISTS ROOM; DROP TABLE IF EXISTS COURSE; DROP TABLE IF EXISTS INSTRUCTOR; DROP TABLE IF EXISTS APPROVED_INSTRUCTOR; DROP TABLE IF EXISTS CLASS; DROP TABLE IF EXISTS STUDENT_GRADE; SET FOREIGN_KEY_CHECKS=1; Step 4: Create Tables in your database Create a new Table for each of the entities provided to you in the ERD diagram in Step 1. Add a column to represent each attribute addressed in the ERD diagram in Step 1. Designate Primary Key, as noted in the ERD diagram in Step 1. Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1. Enable referential integrity on the relationships, as needed. Enable cascade updates as needed on the relationships. Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables. Dates: they should have a date data designation type. Surrogate keys: shall be auto-numbered Character type: shall have a character data designation type. Step 6: Column Constraints Designation. Grade designation must be of one of these values as follows: A, B, C, D, E, F, W, E (E=enrolled, and W = withdrawn). Student's first and last names are not to be designated as NULL. Course Credit hours shall be BETWEEN one and four. The instructor first and last name must NOT be NULL Course name designation has to be UNIQUE and must not be NULL type. Step 7: Data Table Addition Use the INSERT operator to add minimum 2-3 rows of data per each database. You are free to use any values you might like for each of the columns. NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled. Step 8: Executing your SCRIPT Must incorporate the COMMIT command at the end of your Script Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created. Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script. EXECUTE your SCRIPT. Copy and paste your OUTPUT into your MS Word file as follows: YourLastName_Project_Ph3_Output.doc Step 9: Upload your work Upload ZIP file to include the two files as follows: 1) SQL Script with your name as follows: YourLastName_Project_Ph3.sql, and 2) MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.

SCENARIOYou are a member of a software development team for a project, which includes business analysts, solution analysts, developers, quality assurance professionals, and a project manager, among other team members. You have been tasked with completing a solution proposal and design and test plan with the help of your team to support the software development process. The American Video Game Company has provided a high-level requirements document to aid you in identifying an appropriate solution.The project is to implement a customer relationship management (CRM) system for the sales force of a medium-sized company. The initial requirements document has been provided for you to use in determining a solution. You may choose to implement a customizable/commercial off-the-shelf (COTS) system, or you may decide to have the system custom built. When making this decision, ensure all requirements are considered and can be implemented if choosing a COTS system. If you decide to build the system, consider the additional resources that will be needed. Review the attached “CRM Requirements” document provided with the assessment to gain an overall understanding of the system the American Video Game Company is looking for.REQUIREMENTSYour submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. An originality report is provided when you submit your task that can be used as a guide.You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.Review the attached “CRM Requirements” to gain an overall understanding of the system that American Video Game Company is looking for. Then propose a software solution for American Video Game Company by doing the following:A. Introduce your proposed system, including a purpose statement, overview of the problem, goals and objectives for the project and solution, prerequisites, scope, and environment, as outlined in the attached “Design Template.” Note: The Introduction section of this report may be done after the project task is completed.B. Explain how your software solution addresses five distinct requirements from the attached “CRM Requirements.” C. Discuss the waterfall method by doing the following:1. Compare the advantages and disadvantages of the waterfall method to those of another development method of your choice.2. Evaluate whether the waterfall method or the development method you chose in C1 is better suited to the solution for American Video Game Company, including specific examples to justify your claims.D. Create two visual representations of your software solution (e.g., storyboard, flowchart, UML diagram, ERD) that illustrate how the system process or workflow aligns with and supports the business process for American Video Game Company. E. Create a test plan with test cases for three different functional aspects of your software solution, including the following:• preconditions for each test case• steps for each test case• expected results for each test case F. Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized. G. Demonstrate professional communication in the content and presentation of your submission.