This assignment will give you practice using and understanding inheritance and polymorphism in Python. Specifically, you will be designing several classes that will create characters in a game called Critters. Critters was originally developed in Java at the University of Washington by Stuart Reges and Marty Stepp

Lab 4: Structured Query Language (SQL)Due Week 7 and worth 75 pointsRefer to the database design crested in Lab 2: Modifying a Database Design to complete this Lab. Perform the following steps in MySQL:Create the tables and relationships from the database design discussed in Lab 2. Add at least five (5) records into each table (Note: You must determine the field values). Create a query with all fields from the student table, where the student's last name is "Smith".Create a query that includes students’ first names, last names, and phone numbers.Create a query that includes instructors' first names, last names, and courses they teach. Include the following screen shots in a Microsoft Word document to show the completion of the steps above:Screen shot depicting the tables created within MySQL.Screen shots depicting the records added into each table.Screen shots depicting the SQL code and the query results from each of the queries created.Your assignment must follow these formatting requirements:Submit the lab as a Microsoft Word document.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page is not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.Click here to view the grading rubric for this assignment.

The popular social network Facebook TM was founded by Mark Zuckerberg and his classmates at Harvard University in 2004. At the time, he was a sophomore studying computer science.Design and implement an application that maintains the data for a simple social network. Each person in the network should have a profile that contains the person’s name, an image(Optional), current status(Online, offline, busy,...), and a list of friends. Your application should allow a user to join the network, leave the network, create a profile, modify the profile, search for other profiles, and add and remove friends.Reference: Data Structures and Abstractions with Java, Frank M. Carrano, 4th Edition, Pearson, 2015. You can use any data structure you have learned and wrote so far. DO NOT USE ANY JAVA, C++, or PYTHON LIBRARY to import data structures! Use your own data structures that you wrote so far. Use at least a hash table or a dictionary You need at least 2 data structures: One for profiles and one for the list of the friends of those profiles. You need to implement CRUD (In computer programming, create, read, update, and delete (CRUD) are the four basic functions): So far, the class have talked about Array List, Linked List, Linked Queue and Linked Stack. I have also included the files for hashed dictionary. The class have not talked about table so I do not have it. Pls write the code as basic as it gets, or easy to understand. Do add comment explaining what the line of code is doing because I need to present the project to the teacher. Finally answer these two questions. What data structures did you use in your code and why? Show me in your code where you used these data structures and where you created objects of their classes? (You should explain your code and I do not accept if you say somebody else did this part of the code.)