TechCo is a technology company that specializes in manufacturing and selling electronic products. As part of our efforts to streamline operations and enhance data management, we are embarking on the development of a comprehensive database system. This system will be designed to support various aspects of our business, including departments, employees, customers, suppliers, products, sales orders and payments.Create the ERD with entity name and attributes for each entity in $3$NF$.$ Include in model: Primary Key Foreign Key Crow foot notationProduce Physical Database in MS SQL Server under the Database with your Zid id $($Create tables in model$)$ Populate tables with data $($Each table should have at least $7$ records$)$Create $7$ original SQL queries to analyze all data Use joins, subqueries, and$/$or aggregate functions Select $*$ from customer does not count!!! Display the results in a human readable format and include in your Powerpoint Column choice, ordering should be considered.ppt with title page including your name, zid and name of company you designed forAn ERD with all details on slide $3.$ I would suggest you use Visio but are free to use any tool you feel comfortable with. ERD should be copied or imported as a picture in the $.$ppt List of SQL statement with business description of what the SQL is looking to do$.($SQL must run and return data$)$ List of any assumptions you may have made based on the requirements given.