Designing a Database

Create Database - SQL Server Using MS SQL Server Management Studio create the database for the business. The database should include all the tables, columns, keys, and relationships. Submit the SQL file used to create the completed database. The file submitted must be the working file to completely re-create the database. Populate the Database Populate the database. Using the DML portion of SQL. All the data must be useful and realistic. A minimum of 20 records for each table. Submit the text file with all the SQL DML statements to populate the database. Additionally, include the SQL statements from to create the database. Queries Create queries that extract information from your database that shows. You must provide 12 different queries one for each. The queries must be as follows: A query on a single table A query on two or more tables A query that shows an inner join A query that shows a left outer join A query that shows a right outer join A query that shows counts A query that shows sum A query that shows grouping A query that tests for NULL values A query that shows a self join Trigger example Stored procedure Submit the actual SQL DML query, the results of each query, and why the result is meaningful Outline of the presentation – one page transcript