Question: 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
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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
