Here ya go
items: id(pkey), name categories: id(pkey), name category_items: id(pkey), category_id (fkey categories), item_id(fkey items) menu.json { "category”:[{ “name”: “Appetizer”, }, { “name”: “Entree” } ] ], "item”:[ { "name":"French Fries", "category":"Appetizer" }, { "name":"Onion Rings", "category":"Appetizer" }, { "name":"Sandwich", "category":"Entree" }, { "name":"Tacos", "category":"Entree" }, { "name":"Ice Cream Sundae", "category":"Dessert" } ], "restaurant":"Joe's Grill" } } Existing classes: class category: def __init__(self, name): self.name = name class item: def __init__(self, name, category_name): self.name = name self.category_name = category_name Helper Functions that Already exist // json.get_categories(file_name) -> returns array of active category objects (category.name) // json.get_items(file_name) --> returns array of item object (item.name, item.category_name) // db.write(table_name, <a data dict or an array of data dicts>) //db.write('categories', {'name': 'c1'})