father-food project

CSCE156 Fall 2004 Introduction to Computer Science II PHP Scripts to Interface to a Database: Since this assignment deals with PHP, and debugging can be a challenge, and the syntax and some of the capabilities can be weird, you should start this assignment immediately. A father wants to keep track of who in his family likes which foods. Each family member has a first name, last name, and age, and each food has a brand name and a product name. The following SQL statements create tables to meet the father's specifications: CREATE TABLE People ( FirstName varchar(30) NOT NULL, LastName varchar(30) NOT NULL, Age int NOT NULL, PersonID int NOT NULL, primary key(PersonID) ); CREATE TABLE Food ( Brand varchar(30) NOT NULL, Product varchar(30) NOT NULL, FoodID int NOT NULL, primary key(FoodID) ); CREATE TABLE PeopleFood ( PersonID int NOT NULL, FoodID int NOT NULL, primary key(PersonID,FoodID) ); Since the father is not very comfortable with SQL, he wants a usable interface into the database, and has decided to hire you to build it. Since his database is already in place, you MUST use exactly the database structure that is specified by the above CREATE TABLE statements. Here is what the interface is supposed to do: * It should allow for easy adding, modifying, and deleting of people and foods, and should allow for easy adding and deleting of relations between people and foods. * For a given person, it should list all the foods that person likes, and for a given food, it should list all the people who like that food. * The user should be able to search for a specific person, a specific food, or list all people/all foods. * The user should be able to specify a person P and get a list of all other people who have at least k foods in common with person P, where k is a user-settable parameter. (An analogous function should exist for listing all foods that have at least k people in common with some food F.) * The user should be able to specify two people and the system will list all the foods that they both like. (An analogous function should exist for listing all people who like each of a pair of foods.) * All of the information should be displayed so it is easy to use. * The level of detail (e.g. whether a person's age is displayed or whether a brand name is displayed) should be specified (and dynamically changed) by the user. Your goal is to create a completely working interface that is correct, easy to use, pleasing to the eye, well-designed, well-coded, and clearly documented. A few hints: * Keep in mind things like modularity of design, etc. If I decided to change the interface significanlty, or use a different database, etc., I should not have to wade through all of your code--the changes I need to make should be confined one or a few files, and should be as minimal as possible. * If the structure of the database changes, it will clearly require changing some of the queries. You should make it easy for me to do so. In other words, you should reuse queries wherever possible, and confine them to few places where they are easy to find. * Is the interface provided separated enough from the underlying logic? * Think reuse. Think about what other types of things someone might want to do with the database. I am not suggesting implementing every possible query one might want to do, but your application logic should allow one to easily add capablities at both the application layer and the front-end. * You should be thinking in terms of an n-tier architecture, where the logic and interface are as separate as possible. * We will use a specific database to test your program, but you will not have access to this database. Thus you need to develop your own test suite of records in the database and queries to perform. When you are finished, write a 1-3 page description of the hows and whys of your design. Include how you partitioned the code into files and classes and why, where you put various things (like SQL statements, FORMS, HTML code, style setting, etc.) and why, how you designed and implemented the interface and why, etc.