# CSE324 / DBMS Lab

## Syllabus

{% file src="<https://2980675225-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7uMP7Ghb8mcjzaqhpGZJ%2Fuploads%2FUZBMU4VPhA3wKSRDW23C%2FCSE324%20DBMS%20Lab%20Syllabus%20BTECH-IT.pdf?alt=media&token=c177adcc-5496-42b7-9f77-6e2b9f3c95ed>" %}

## Resources

<details>

<summary>EXPT 1</summary>

Using create command design three specific table and the table structure is given below.

Table name- Book with Columns for ISBN / TITLE / PUB\_YEAR / UNIT\_PRICE / AUTHOR\_NAME / PUB\_NAME

Table name- Author with Columns for AUTHOR\_NAME / COUNTRY

Table name- Publisher with Columns for PUB\_NAME / PUB\_ADD1

\<See the Syllabus PDF above for Actual Data to be filled>

</details>

<details>

<summary>EXPT 2</summary>

Write the SQL query to find the name of all publisher from Book relation.

</details>

<details>

<summary>EXPT 3</summary>

Write the SQL query to display the name of all publisher using distinct clause.

</details>

<details>

<summary>EXPT 4</summary>

Write the SQL query to find the names of author from the author table where the first two characters of names are ‘ba’.

</details>

<details>

<summary>EXPT 5</summary>

Write the SQL query to display title of books published in year 2004.

</details>

<details>

<summary>EXPT 6</summary>

Write the SQL query to display title of books having price between 300 to 400.

</details>

<details>

<summary>EXPT 7</summary>

Write the SQL query to display title of books having price between 300 to 400 using operators.

</details>

<details>

<summary>EXPT 8</summary>

Write the SQL query to display title of books with author\_name and country published in year 2004.

</details>

<details>

<summary>EXPT 9</summary>

Write the SQL query to display all title and (unit\_price\*10) as an attribute from book table using arithmetic expression.

</details>

<details>

<summary>EXPT 10</summary>

Write the SQL query to add the new column in all three tables.

</details>

<details>

<summary>EXPT 11</summary>

Study the concept of Views and their utility in DBMS, write the SQL query to design a view.

</details>

<details>

<summary>EXPT 12</summary>

Write the SQL query to make the attribute ISBN as a primary key in Book relation.

</details>

<details>

<summary>EXPT 13</summary>

Write the SQL query to display the all the titles of Books with price and year in descending order.

</details>

<details>

<summary>EXPT 14</summary>

Write the SQL query to study the use of Delete and Drop command in DBMS

</details>

<details>

<summary>EXPT 15</summary>

Study the concept of Triggers, cursors and stored procedures in DBMS.

</details>

{% embed url="<https://mantavyam.notion.site/18152f7cde8880d699a5f2e65f87374e>" %}
Get Credited for sharing your Knowledge Source with your Peer
{% endembed %}

{% embed url="<https://mantavyam.notion.site/17e52f7cde8880e0987fd06d33ef6019>" %}
Submit Queries/Feedbacks/Suggestions/Complaints using this Form
{% endembed %}