SELECT DISTINCT it.name as Item, i.name as Ingredient FROM madewith as m, ingredients as i, items as it WHERE m.itemid = it.itemid AND m.ingredientid = i.ingredientid AND quantity*3 > inventory

Theodbs Assignment

Private Sub Command1_Click()

If Combo1 = "Chicken salad" Then

If List1 = "Chicken" Or List1 = "Crouton" Or List1 = " Secret Dressing" Or List1 = "Lettuce" Then List2.AddItem "" + List1.Text Else

MsgBox ("No Need!")

End If

End If

If Combo1 = "Fruit Plate" Then

If List1 = "Orange" Or List1 = "Apple" Or List1 = " Secret Dressing" Or List1 = "Lettuce" Then List2.AddItem "" + List1.Text Else

MsgBox ("No Need!")

End If

End If

If Combo1 = "Fruit Salad" Then

If List1 = "Apple" Or List1 = "Grape" Or List1 = " Orange" Or List1 = "Pineapple" Then List2.AddItem "" + List1.Text Else

MsgBox ("No Need!")

End If

End If

If Combo1 = "Garden Salad" Then

If List1 = "Lettuce" Or List1 = "Crouton" Or List1 = " Secret Dressing" Or List1 = "Mayonaise" Then

List2.AddItem "" + List1.Text Else

MsgBox ("No Need!")

End If

End If
End Sub

Private Sub Command2_Click()

If Label2.Caption Like "-1" Then

MsgBox ("Select an item from list")

Exit Sub

End If

Index = Label2.Caption

List1.RemoveItem

IndexEnd Sub

Private Sub Command3_Click()

List1.Clear

End Sub

Private Sub Timer1_Timer()

Label2.Caption = List1.ListIndex

End Sub

RDBMS

(Relational DataBase Management System) Software for storing data using SQL (structured query language). A relational database uses SQL to store data in a series of tables that not only record existing relationships between data items, but which also permit the data to be joined in new relationships. SQL (pronounced 'sequel') is based on a system of algebra developed by E F Codd, an IBM scientist who first defined the relational model in 1970. Relational databases are optimized for storing transactional data, and the majority of modern business software applications therefore use an RDBMS as their data store. The leading RDBMS vendors are Oracle, IBM and Microsoft.

RDBMS usually include an API so that developers can write programs that use them.
Typical RDBMS include
Microsoft Access
Microsoft SQL Server
Sybase (The forerunner of Microsoft SQL Server)
IBM DB2
Oracle
Ingres
MySQL
Postgres