Hello, Thanks for the help. You are designing a simple database connected applic

Question

Hello, Thanks for the help.

You are designing a simple database connected application that contains one form and one table. The purpose of the application is to allow the user to enter new books into the library's inventory.

Part 1

- Briefly describe your table. You discussion should include attributes, justification, and data type for each field. You should have at least five fields of your choosing.

- Write the SQL command to create the table that you described above.

- Write the SQL command to insert a record into the table.

- Write the SQL command to delete a record from the table.

- Write at least 2 conditional SELECT queries.

Part 2

- Design a simple interface using the drag and drop tools in NetBeans to support inserting a record into your database table.

Explanation / Answer

- SQL command to create the table library_inventory:

Create table library_inventory(Book_id int Primary key, Book_Name nvarchar(2000) , Auther nvarchar(2000))

SQL command to insert a record into the table:

insert into library_inventory(Book_id , Book_Name,Auther)
values
(1,'Introduction to Algorithms ','Thomas H. Cormen '),
(2,'Structure and Interpretation of Computer Programs ',' Harold Abelson '),
(3,'The C Programming Language ','Brian W. Kernighan '),
(4,'The Pragmatic Programmer: From Journeyman to Master ','Andrew Hunt ')

SQL command to delete a record from the table:

delete from library_inventory where Book_id = 4

2 conditional SELECT queries:

Select * from library_inventory where Auther = ' Harold Abelson '

Select * from library_inventory where Book_id in (1,2)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.