View the step-by-step solution to:

Electronic copies should be a ZIP file of your VB project folder. Include at least 2 or 3 fields in the "PK" table, and 4 or more in the "FK" table.

Had an example in the file

Electronic copies should be a ZIP file of your VB project folder. Before submitting, please be sure that you are able to unzip the file, load the project, and execute it – best to do this on a different system Basic Data Maintenance Application – Database & Interface 1) In your database on SQL Server or Teradata create two tables with a referential integrity (PK-FK) constraint. Include at least 2 or 3 fields in the “PK” table, and 4 or more in the “FK” table. Provide a schema document with information about your two tables and the relationship between them. 2) Build a simple Windows Form using Visual Basic that performs the following operations: Provide an interface containing a list of values for your “PK” table. Include a listbox, combobox, or grid to hold a list of items in the FK table that relate to the selected item from the PK table, and inputs for each of the fields in the FK table. Include buttons to “Update” and “Delete” the selected FK item and “Insert” a new FK item. 3) Provide a copy of your ERD, and a ZIP file of your VB Project folder through the assignment link on Blackboard. When the form loads, populate the PK drop-down box with items in the PK table. When a PK item is selected, load the appropriate list of FK items in the FK list. When an item from the FK list is selected, populate the inputs with the item field information. When the “Update” button is clicked, update the selected item in the database with information from the form. Whene the “Delete” button is clicked, delete the selected item in the database. When the “Insert” button is clicked, insert a new item into the database with the selected values. Be sure to refresh the data on your form if anything has changed. Include a meaningful field that contains an aggregate value taken from a SQL query.
Background image of page 1
Example (You may not use this example for your exercise) State (PK) & ZIP Code (FK) (the tables you created in your SQL assignment) – related to each other by the State Abbreviation (AR, OK, TX, etc.). The screenshot below represents an application that behaves in the following way: When a State (PK table) is selected, ZIP Codes for that state are displayed in the adjacent list. When a ZIP Code (FK table) is selected from the list, details about that ZIP Code are displayed in the “input” fields. A user may change one or more fields and press the “Update” button, which should update the correct record appropriately in the database. A user may enter a new ZIP code for the selected state, with information provided in the input boxes, and press the “Insert” button, which should result in a new record being created in the ZIP code table. For a couple of extra points, another field could be added containing the average latitude and/or longitude for the selected state, or the number of ZIP Codes in the state.
Background image of page 2
Sign up to view the entire interaction

Top Answer

Zip File. In case of... View the full answer

Assignment07.zip - Preview not available

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online