Fillin the blanks with the missing word to complete each of the given statements 1. Is a language used to communicate with a database.2. The is a collection of related objects created by the user, such as tables, views, domains, constraints, and anggers among others.3. Predicates are used to queries. the effects of the statements and4. The SQL Server Management Studio or SSMS presents a for managing, configuring, monitoring, and administering instances on the SQL Server.5. Server name is the default or instance of SQLIV. Scenario Analysis. Analyze and provide the solutions being asked in the scenario below.Angelo wants to create a database application for his computer shop where he can store his customer profiles and their transactions. To help Angelo, (1) determine the table and its structure, (2) give the steps in creating a database and table, (3) give the instructions to insert and delete data, and (4) provide sample data that can be encoded in the table.

1. SQL is a language used to communicate with a database.
2. The database is a collection of related objects created by the user, such as tables, views, domains, constraints, and triggers among others.
3. Predicates are used to filter queries. The effects of the statements and
4. The SQL Server Management Studio or SSMS presents a GUI for managing, configuring, monitoring, and administering instances on the SQL Server.
5. Server name is the default or instance of SQL.

IV. Scenario Analysis.

To help Angelo,

(1) Determine the table and its structure:

Table: Customers

• CustomerID (Primary Key, Auto Increment)
• FirstName
• LastName
• Email
• Phone

Table: Transactions

• TransactionID (Primary Key, Auto Increment)
• CustomerID (Foreign Key)
• Product
• Date
• Amount

(2) Steps in creating a database and table:

• Open SQL Server Management Studio
• Connect to the SQL Server instance
• Right-click on Databases and select New Database
• Name the database and click OK
• Right-click on the new database, select New Query
• Write the SQL commands to create the tables

(3) Instructions to insert and delete data:

To insert data:

INSERT INTO Customers (FirstName, LastName, Email, Phone)
VALUES ('John', 'Doe', '[email protected]', '1234567890');

To delete data:

DELETE FROM Customers
WHERE CustomerID = 1;

(4) Sample data that can be encoded in the table:

Customers:

• CustomerID: 1, FirstName: 'John', LastName: 'Doe', Email: '[email protected]', Phone: '1234567890'

Transactions:

• TransactionID: 1, CustomerID: 1, Product: 'Laptop', Date: '2022-01-01', Amount: 1000.00