Make and fill a database with the following requirements using SQL Server Manager:

$5$ tables $($related to each other via PK$-$FK relationships with $60$ records between all

$5$ tables All scripts are to be written by hand $($cannot use designer functionality

and then create a script from the design itself$)$

Semester Project Objectives

Demonstrate knowledge of third normal form database design.

Demonstrate ability to write DML statements Basic SQL statements $($SELECT$,$

FROM, WHERE, ORDER BY$).$

Use of multiple table joins.

Use of built$-$in SQL functions.

Use of summary queries & Use of subqueries.

Demonstrate ability to write DDL statements.

Use of database and table creation scripts.

Use of View creation scripts.

Use of Stored Procedure creation scripts.

Use of user$-$defined creation scripts & Functions.

Demonstrate ability to use T$-$SQL within scripts.

Use of conditional structures.

Use of CTE.

Use of custom error messages.

Use of database objects within scripts.

Create and provide a visual ERD from SSMS$.$

Using Pokemon, create an SQL database that categorizes their names, pokedex number, typings $($main and secondary$),$ evolution requirements, and a short exerpt from their Pokedex entry. Pick $5$ pokemon from each region.