PROF SocratesPlease 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.
20 Points - 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.
10 Points - Write the SQL command to create the table that you described above.
10 Points - Write the SQL command to insert a record into the table.
10 Points - Write the SQL command to delete a record from the table.
10 Points - Write at least 2 conditional SELECT queries.
40 Points - 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.
10 years ago
Purchase the answer to view it
database-connected_applications.docx
