Question

Please type out within the browser, any database is fine, as long as it meets criteria below. Use nay kind of layout on a word document, that resembles a databse, any database is fine, with any terms or preferences, etc.

In this lab, you will use SQL to insert, update, and retrieve data from your database.

based off last question, use any schema. https://www.chegg.com/homework-help/questions-and-answers/apply-normalization-rules-database-design-describe-words-1nf-2nf-3nf-apply-design-database-q40101133?trackid=6lmf5w8w

Lab steps:

1. Using your downloaded DBMS (MS SQL Server), create SQL queries that inserts at least three rows in each table.
2. Create SQL queries that update one row in each table.
3. Create SQL queries that retrieve an entire table (any table that you choose).

Create a Word document or a PowerPoint presentation and insert each query and its results, along with screen shots of your queries and results.

Answer 1

1)

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)

VALUES (1, 'Romil', 20,’India’,500000.0 );

INSERT INTO RETAILERS(ID,NAME,AGE,ADDRESS,PRODUCT)

VALUES (2, 'Sahib', 25, 'USA',’Handloom’);

INSERT INTO SELLERS(ID,NAME,AGE,ADDRESS,ORGANIZATION)

VALUES (1,’Rythem', 29,’Nepal',’Puma’);

2)

UPDATE CUSTOMERS

SET ADDRESS = 'Maldives', SALARY = 1000.00;

UPDATE RETAILERS

SET ADDRESS = 'Sweden',PRODUCT=‘Clothes’;

UPDATE SELLERS

SET ADDRESS = 'Bhutan',ORGANIZATION=‘Nike’;

3)

SELECT * FROM RETAILERS;