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
Hi, I can help by developing the database using SSMS with the functional requirements that you require.
Contact me by chat to clarify details
Thank you