1) Design and Create a Restaurant Database Your school is sponsoring a conference that will draw participants ?'orn a wide geographical area

Subject:Computer SciencePrice:2.86 Bought11

Share With

1) Design and Create a Restaurant Database Your school is sponsoring a conference that will draw participants ?'orn a wide geographical area. The conference director has asked for your help in preparing a database of restaurants that might be of interest to the participants. At a minimum, she needs to know the following: the type of restaurant vegetarian, fast-food, ?ne dining, and so on), street address, telephone number, and opening and closing times and days. Because most of the participants will stay on campus, she also would like to know the approximate distance ?'om campus. Additionally, she would like to know about any unique or special features the restaurants may have. Design and create a database to meet the conference director's needs. Create the necessary tables, determine the necessary ?elds, enter ten (10} sample data, and prepare a sample report to show the director. {19 marks} Use the restaurant database you created in Question 1. Determine at least five (5) questions the conference director might want to ask the database. Using Microsoft Word, write the questions in your own words. Then, design the queries for Microsoft Access, Run and save each query. (10 marks)