The Project Background Your team just won a database maintenance contract for an Israeli restaurant management company that operates 30 restaurants in 5 cities across Israel. These restaurants serve a large variety of cuisines. The restaurant management company runs a membership program that the membership card can be used for all the restaurants under its management. When you started working on the database, you found that the previous contractor left you little information about it. In such a situation, the typical practice is to study the database by either experimenting with the applications and the database, interviewing the users, or both. However, the client is unlikely to allow these standard practices to avoid any potential disruptions to restaurant operations. Fortunately, the client agrees that you may download some data to analyze the database for making any necessary improvements. Here you have 10 .csv files storing data from 10 tables.

Goals of the Project The client is considering expanding to more cities in Israel with more cuisine lines (types of restaurants). Therefore, it wants to know if the current database can be improved to support the expansion. The client also wants to learn the member's dining patterns and requests your team to create a View for the membership program manager to make analyses. In short, your goals are to I. Optimize the database for daily operations and future expansion, and II. Propose and create Views for the membership program manager to perform member performance and preference analysis. Requirements 1. Generate the conceptual model (E-R model) based on the existing data structure