First you need to design a relational database with at least three tables. You can do something that relates to your work or a hobby or just something you think of! Two of the tables must be in a one to many relationship in the sense of drive number going to the drive table to get a name. Two of the tables must be in a one to may relationship in the sense of one donor gives many donations. If you want me to check the design before you implement it, send it to me with a note on the subject that says DESIGN TO CHECK.

You need to work with ADO and include the following:

• Write SQL to select records based on conditions with an AND relationship
• Write SQL to select records based on conditions with an OR relationship
• Write SQL to select records from multiple tables
• Update a table
• Look for a match to a user data entry

• Relate two tables and display information on a form
• Relate two tables in a one to many relationship and show the matching one and many
• Use a grid

You can use multiple programs, a single program with multiple forms or multiple commands. Your choice!