Submission GuidelinesYou can put your answers in either this document $($after each question$)$ or a new MS word document $($just your answers$).$You are required to upload the word document to LMS$.$Problem DescriptionYou work for a manufacturing company that specializes in producing a variety of products. You have been contracted to design a simple database system that effectively manages products, ingredients, and suppliers for this manufacturing company.The company produces various products, each composed of specific ingredient$($s$)$ from different supplier$($s$).$ Each product has name and price. The company also wants to maintain each suppliers contact information such as name, address, and phone number for future use. A supplier can supply multiple ingredients. Each ingredient has a name and price per kg$.$ The system should also keep track of the ingredients used $($in kgs$)$ for each product. Task $1$: Designing a database from the problem description Designing a database consists of $4$ basic steps. Task $1\mathrm{.}1$: Complete the following questions according to the problem description$1)$ Identify the possible entities in the problem description$\mathrm{.}2)$ Identify the attributes in the problem description$\mathrm{.}3)$ Identify how the entities relate to each other $($the relationships$)4)$ Identify $($if any or create$)$ attribute$($s$)$ that could be used as primary keys for each entity. Task $1\mathrm{.}2$: Create an ER diagramYou can do this in any program of your choice $($e$.$g$.,$ MS Word, draw.io $($online$),$ etc.$).$ Either paste the diagram directly or take a screenshot of your ER diagram and paste it your word document. Your ER diagram should have all the entities, attributes, relationships, primary keys $($underlined$)$ and cardinalities $(1-1,1-$M$,$ M$-1,$ M$-$M$).$ Task $1\mathrm{.}3$: Convert the ER Diagram into tablesFor this task, you are not required to implement the tables in any RDBMS$.$ You are just required to write the schema, i$.$e$.,$ table name, attributes, primary keys, and foreign keys, as shown in the lectures$/$labs$.$This is a step$-$by$-$step process:$1)$ Create one table per entity$\mathrm{.}2)$ Each attribute of the entity is represented as a column in the table$\mathrm{.}3)$ Define the primary key columns $($underline them$)$Add the foreign keys $($write them in italic$).$ Task $1\mathrm{.}4$: Create tables using SQLCreate all the tables you have in Task $1\mathrm{.}3$ using SQL$.$ Paste your queries in your word document. Your table creation should consider any primary keys$/$foreign keys. Task $2$: SQL Queries $1.$ With SQL$,$ how can you return all the records from a table named "Suppliers" sorted Z to A by "FirstName"? $2.$ Write SQL query to select all the suppliers where their last name contains the letters $"$eo$"$ and starts with a $"$J$".3.$ Consider a database table named "Supplier" with a single column "LastName" shown below.GallandKlingmanMelanconGessDonesLambornElizondo Consider the SQL: SELECT LastName FROM SupplierWHERE LastName LIKE $"\%$o$\%$"ORDER BY LastNameLIMIT $3$ OFFSET $1$ Write down the order each name will appear in the result. Mention will not appear next to a name if it wont appear in the result. Task $3$: Wireframe User Interfaces You are to design wireframes for a product manufacturing company like problem description but not limited to the problem description.Please consider what different pages you can use for your website design. Some examples can be Homepage, Dashboard$/$Analysis$,$ Product List, Ingredients List, Add$/$Edit Suppliers etc. You can visit available similar websites for any manufacturing companies for your reference. You can think about the pages according to the problem description and add any additional details you may find relevant.Note that you can wireframe the UIs according to your understanding and preference. We are looking for creativity for this task. You are required to at least have minimum of $5$ different pages for your UI$.$ You also need to show flow$/$interaction among different pages. You need to use Figma $($https:$//$www$.$figma.com$/)$ introduced in the lab to create your UI$\mathrm{.}1.$ Share link of your work in word document, make sure the link is accessible to the teaching team Huawei and Aseel. You can copy the link from the address bar while youre in Present mode, and paste it in your word document. DO NOT send the invite by email. DO NOT share your link with anyone else in class. $2.$ Take screenshots of all the pages and paste them in your word document.