Assignment
Please submit your work as a .doc file. Please make sure to name your file with your last name first, and include your name on the actual document as well.
This assignment focuses on database-connected applications. Other than SQL, you do not have to write any code, but for a perfect score, you should be able to check off every item on the list shown below:
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.
- 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.
- Design a simple interface using the drag and drop tools in NetBeans to support inserting a record into your database table. Include a screenshot in your write-up.