1. Create a database design that will consist of 5 - 8 tables and explain the following:
   1. Why you created that database design and why it is need? Which company do you think will benefit of your database design?
   2. For each relationship that exists between 2 tables, explain why it exists
   3. Show the Database screenshot and tables created in MS SQL Server Management Studio
   4. Paste the Transact-SQL scripts you used to create the tables. Please make sure that you setup the Primary Key and Foreign Keys
   5. For each table, explain why you chose the column(s) as the Primary Key
2. Creation of Transact SQL SELECT Statements.

This section allows you to use the 5 8 tables you created. Create 6 T-SQL Select Statements that will give insights to the user of your database. Your T-SQL must have JOIN requirement. Create T-SQL that will make sense and beneficial to the end-users.

1. 1^st SELECT T-SQL Statement and screenshot of the output
2. 2^nd SELECT T-SQL Statement and screenshot of the output
3. 3^rd SELECT T-SQL Statement and screenshot of the output
4. 4^th SELECT T-SQL Statement and screenshot of the output
5. 5^th SELECT T-SQL Statement and screenshot of the output
6. 6^th SELECT T-SQL Statement and screenshot of the output

[Please see below give you idea on how you will answer the questions]

Just a sample how you will answer it: 1. Covid Tracker Database 1.1. This is to consolidate the Covid cases and those people who get recovered, died, and are marked as new cases, as well as the status of the Hospital and Quarantine facilities. This will benefit everyone as we are united to end the Covid pandemic. 1.2. (Case Type] table and (Patient] table. 1 Patient can be classified as Asymptomatic, Mild, Severe, Critical case type which has Primary Key Case_Type_ID in (Case Type] table. This primary key will be foreign key in [Patient] table. Thisis for sample purposes only herxel won't reveal al tables. You shoud define all relationships existon Jour 5-8 cobles 1.3. Just do a screenshot of tables and database which should exist in your SQL Server Management Studio 1.4. CREATE DATABASE DB_Covid_Tracker_System CREATE TABLE (Case Type] ( ) 1.5 Case Type table [Case Type ID) is the primary key of this table as for every Case Type (Asymptomatic, Mild, Severe, Critical) there will be an auto-incrementvalue. 2. Transact SQL 2.1. Active Covid Cases by Barangay This is to give insights to userswhich are as have high percentage of covid cases and will give them information to which places should be avoided. SELECT blah blah FROM this_table INNER JOIN table_2 ON this_table.coli = table_2.coli INNER JOIN table_3 ON this_table.coli = table_3.coli Output in MS SQL Server Management Studio 2005 Results Message majd elame 1 6380 Ese the Read Books 789 Calanque Ave Setle WA 98056 2 7066 Burun's 567 Pasadena Ave. CA 92789 3 7067 News Brews 577 Posts Los Gato CA 56745 4 7131 Doc-UM:Quality Laundry and Books 24A Avogadro Way Remulade WA 90014 5 756 Frictive Bookshop Madison Fremont CA 6 8042 Boobs 679 Canon Portland OR 2.2. Covid Bed Availability per Hospital Facility This is to give insights on which hospitals to go when you are for confinement due to covid. SELECT blah blah FROM this_table INNER JOIN table_2 ON this_table.coli = table_2.coli INNER JOIN table_3 ON this_table.coli = table_3.coli Output in MS SQL Server Management Studio 1 2 3 4 5 6 arrane 6380 Ese the Read Books 789 Catanque Ave. Seattle WA 98056 7066 Baru 567 Pasadena Ave. Tustin CA 92709 News Brews 577 Los Gatos CA 7131 Doc-U-Mat Quality Laundry and Books 24A Avogadro Way Roulade WA 90014 76 Frictive Bookshop Madison Fremont CA 90019 8042 Books 679 Carson Portland OR 9028 This is for sample purposes only herxel won't show 6 Transect SQL somples. Make sure that the ovd ut mokes sense to what you would like to achieve in your T-SQL SELECT sto tements