Question: 20764 Administering a Microsoft SQL Database Infrastructure Project 1 Run a query that display the contents of all tables (do four separate queries) 0 Take

20764 Administering a Microsoft SQL Database
20764 Administering a Microsoft SQL Database Infrastructure Project 1 Run a query that display the contents of all tables (do four separate queries) 0 Take a screenshot Run a query that displays only the first 5 lines of the Customers table o Take a screenshot Run a query that displays the last line in the Suppliers table o Take a screenshot Run a query that displays the names of the four tables that you created in the RetailSales database o Take a screenshot Backup Perform a Full backup of the RetailSales database Take a screenshot that displays the size of the RetailSales database backup 0 Note: You can either run an SQL query on the size of the backup or take a screenshot of File Explorer showing the file size. Table Information (Revisited) Add the following information to the database into the appropriate table. Customers Table CustomerID: 130 FirstName: Tamara LastName: Egorova Address: 6665 Kiseleve Way City: Seren Province: MN PostalCode: 59E 3R3 PhoneNumber 955-556-2223 Suppliers Table SupplierID: 8859992 SupplierName: Kalindi Corp Address: 1 Starfield Way City: Calli Province: YK PostalCode: CBA LIE PhoneNumber: 332-654-7855 Products Table ProductID 62223335 Description: Projector Screen 100 Inch 16:9 Cost: 5100 Retail Price 109.96 SupplierID 8859992 Transactions Table TransNum: 55488855 CustomerID: 121 ProductID: 62223335 RetailPrice: 109.96 Quantity: 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!