Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Communication

Authors: Yahya R Kamalipour

2nd Edition

049505027X, 9780495050278

More Books

Students also viewed these General Management questions