Goals of the Project The client is considering expanding to more cities in Israel with more cuisine lines (types of rest

[answerhappygod]

Goals of the Project
The client is considering expanding to more cities in Israelwith more cuisine lines (types of restaurants). Therefore, it wantsto know if the current database can be improved to support theexpansion. The client also wants to learn the member’s diningpatterns and requests your team to prepare a View for themembership program manager to make analyses. In short, your goalsare to
I. Optimize the database for daily operations and futureexpansion, and
II. Propose and create Views for the membership program managerto perform member performance and preference analysis.
Requirements
1. Generate the conceptual model (E-R model) based on theexisting data structure.
2. Draw the schema for the database. Mark the primary andforeign keys and connect them with links showing theirrelations.
3. Check referential integrity constraints for all foreign keyswith SQL Server. If you decide 3NF is sufficient for the business,you must check the consistency between the duplicated columns withSQL Server.
4. Provide justifications on whether the existing database cansupport the expansion plan. If not, propose and implementimprovements on those tables that may not support theexpansion.
5. Propose a VIEW or a table with sufficient columns for themembership program manager to analyze the members. Create the viewwith SQL Server.
Deliverables
1) A presentation to the client. As per the client’s request,the content pages of the presentation have to be precisely 5 pages,including
a. 1 page for the E-R model,
b. 1 page for the schema of the original database,
c. 1 page for the reasons why the existing database design canor cannot support the expansion plan,
d. 1 page for the schema of the updated database (the databasethat can support the expansion plan),
and
e. 1 page for the design of the VIEW or a table for themembership program manager with the reasons for including thecolumns.
You are welcome to add backup slides for Q&A. Your team willhave 7 minutes to present to the client, including Q&A.
2) A single .sql file containing all the SQL syntax for checkingthe referential integrity constraint and/or duplicationconsistency, updating the database, and creating the membershipprogram manager’s VIEW or table. The file is due on Wednesday, July27, at 11:59 PM.
3) A written report is due on Wednesday, July 27, at 11:59 PM.The report explains the SQLcodes to the client. Each block of SQLcodes needs to have a corresponding paragraph in the written reportintroducing the intention and expectation for these codes. Indexthe report and the SQL codes carefully and adequately. Otherwise,the client may find the report and the .sql unreadable.
Useful Resources
• Creating Tables and Importing Data from .csv Files You mayrefer to the following Microsoft document for importing the tablesand data from CSV files with Azure Data Studio.https://docs.microsoft.com/en-us/sql/az ... rver-ver16
• Drawing the E-R Model and Schemas
Draw.io is a powerful and free online flow-chart drawing tool.You may select the Entity-Relationship Diagram template to draw theE-R model and use the Database2 template under the Software tab tocreate schemas. https://app.diagrams.net