RDBMS Lab@Home 8

1. Write an SQL statement to insert a record into the PictureDetails table, which is created in the PictureLibrary database. The following table shows the data to be inserted into the PictureDetails table.

Ans.

2. Delete all the records from the ProductBrand table in the NarrowFabrics database. Ensure that you do not delete the table.

Ans. 

3. Write an SQL statement to insert a record into the OfficeLocation table, which is created in the PictureLibrary database. The following table shows the data to be inserted into the OfficeLocation table.

Ans. 

4.The users of AdventureWorks need to publish the details of all the customers and their address on the organization's website. To perform this task, you need to retrieve the data in the XML format.

Ans. https://drive.google.com/open?id=0B08RKBSts8D8ZUFDR3FrOUI5amc

5. The EmployeeDetails table contains the records of the employees. Write a query to delete the records of those employees who are designated as clerk. In addition, ensure that all the deleted rows are displayed after the execution of the query. (Use the AdventureWorks database)

Ans.https://drive.google.com/open?id=0B08RKBSts8D8azJXUEZiTjl6aFE

6. The management of AdventureWorks requires a list containing the skills of all the candidates who have applied for a vacancy. The details of all the candidates are stored in the XML format in the HumanResources.JobCandidate table. How will you display the list?

Ans. https://drive.google.com/open?id=0B08RKBSts8D8cV9DaTZyWERFLWc

7. Delete all the records from the Employee table in the AdventureWorks database where the department ID is 5.

Ans. https://drive.google.com/open?id=0B08RKBSts8D8NEswTHhKSzVwbDA

8. The details of the two employees designated as clerk have been removed from the EmployeeDetails table. Write the SQL statement to reflect these changes made in the EmployeeDetails_Backup table. (Use the AdventureWorks database)

Ans. https://drive.google.com/open?id=0B08RKBSts8D8dXdMVGFtSkp2WHM

9. There is a change in the production process of the bicycle with the product model ID 7. Due to this change, the bicycle will not be going to work center 10. You need to update this change in the database. How will you perform this task? (Use the AdventureWorks database)

Ans.https://drive.google.com/open?id=0B08RKBSts8D8WnpXWmttVDA5ZWc

10.Write a query to copy the records of sales with unit price greater than $ 2024.994 in a new table named Sales_od. (Use the AdventureWorks database)

Ans. https://drive.google.com/open?id=0B08RKBSts8D8dEt6dlQxZnBKa1U

11. You need to create a table named Student_Details to store the details of students in the database. The structure is shown in the following table.

Ans.https://drive.google.com/open?id=0B08RKBSts8D8TlVzVlAtdWVfRDA

12. Insert a record with the following address in the Address table of the AdventureWorks database: 2125 Yan Street, Bothell-79, Postal Code-98011

Ans. https://drive.google.com/open?id=0B08RKBSts8D8QVBtM3g5eGh0R28