The client isconsidering expanding to more cities in Israel with more cuisinelines (types of restaurants). Therefore, it wants to know if thecurrent database can be improved to support the expansion. Theclient also wants to learn the member’s dining patterns andrequests your team to prepare a View for the membership programmanager to make analyses. In short, your goals are 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.
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.
3) A written report. The report explains the SQLcodes to theclient. Each block of SQL codes needs to have a correspondingparagraph in the written report introducing the intention andexpectation for these codes. Index the report and the SQL codescarefully and adequately.
- Goals Of The Project The Client Is Considering Expanding To More Cities In Israel With More Cuisine Lines Types Of Rest 1 (63.71 KiB) Viewed 100 times