For example, Jim Jones. Client Transactions each row stores data related to a specific stock transaction. An Excel file is available for you to use as your Company Research table. All tables must be assigned a primary key. The client can only purchase stock of companies that are stored in the Company Research table For simplicity, transactions in database only track purchases of stock by a client not sales of stock.
Relationships Use the diagram below to create the appropriate relationships for the database.
Enforce referential integrity. Forms Create forms that can be used to view, add, edit, and delete data from each table in the database. Each form should be well designed, with a consistent look and style. Include command buttons on each form to add, delete, and close each form. This form should have a combo box that allows the user to quickly retrieve the data for a specific client.