Create a professional presentation to showcase the erd

Assignment Help Computer Engineering
Reference no: EM133529034

Assignment: Business Intelligence and Data Mining- Design and Implement a Database System for a Restaurant Operation- Design Entity Relationship Diagram

Objective:

The objective of this course project is to design an Entity Relationship Diagram (ERD) for a restaurant sales and management system. The project aims to provide students with hands-on experience in analyzing complex business rules and modeling a database schema that effectively captures the data requirements and relationships of a restaurant operation. Through this project, students will enhance their understanding of conceptual database design, normalization, and data modeling techniques.

Business Scenario Description:

PG (Papa Georgios), the owner of a pizzeria and restaurant, wishes to capture all sales data with detailed order information. An order can consist of multiple items, such as pizzas, breadsticks, and beverages, placed by a customer. Employees are hired for various roles, including a restaurant manager, assistant managers, chefs, cooks, waiting staff, and delivery drivers. Reporting hierarchies exist among the employees, with the assistant managers reporting to the manager, and the chefs, waiting staff, and delivery drivers reporting to the assistant managers. Employees can have multiple supervisors. Job history for each employee needs to be maintained.

The restaurant operates from 11 am to 11 pm, and employees are required to be present between 10 am and 12 am to open and close the restaurant. The manager, assistant managers, and chefs receive salaries, while the cooks, waiters, and delivery drivers are paid hourly wages. Chefs require certifications to prepare specific dishes, which need to be up to date. The restaurant manager and assistant managers are required to have special degrees in restaurant management. Employee information such as names, addresses, and dates of birth also needs to be stored.

Employees on salaries do not need to clock in or out, whereas those on hourly wages must record their work hours for payroll calculations. Historical data regarding employment status and promotions of each employee must be stored. The restaurant serves various food items such as pizzas, pasta, garlic bread, chicken wings, beverages, desserts, and sushi. Each item has different serving sizes, prices, and historical prices. Payment methods accepted include cash, checks, and major credit cards.

The restaurant wishes to provide an app that updates customers on the food preparation stage of their order, indicated by coded numbers for stages such as making, baking, preparing, and on the way. Inventory tracking is required to ensure timely reordering of ingredients, including fresh dough, sauces, and other food supplies. Information about food vendors and other supplies, such as cleaning supplies, should be stored in the database.

The restaurant offers a club card (PG Card) to registered customers, awarding points for every dollar spent. Customers accumulate points and can redeem a $10 coupon upon reaching 100 points, which resets their point balance to zero. At the time of payment, customers are prompted to provide a rating for food and service quality on a scale of 1 to 5.

Task

I. Data Analysis and Requirements Gathering:

1. Start by understanding the problem domain thoroughly. Knowing what you're trying to represent in your database is half the battle.

2. Analyze the provided business scenario in detail.

3. Identify entities, relationships, and attributes based on the requirements.

4. Consider complex business rules and data dependencies while gathering requirements.

II. ERD Design and Modeling:

1. Create an Entity Relationship Diagram (ERD) that accurately represents the entities, relationships, and attributes identified.

2. Consider different types of relationships (one-to-one, one-to-many, many-to-many), cardinalities, and attributes required for each entity.

3. Incorporate advanced concepts such as weak entities, ternary relationships, and inheritance (sub-type, super-type relationships) if relevant to the scenario.

4. Use Crow's Foot notations to depict entities, relationships, and cardinalities.

5. Apply normalization techniques to ensure data integrity and minimize redundancy. Entities should be normalized to 3NF.

III. Documentation and Presentation:

1. Prepare comprehensive documentation that explains the rationale behind the design decisions and justifies the chosen relationships, attributes, and cardinalities.

2. Create a professional presentation to showcase the ERD, discussing the entities, relationships, and complex business rules depicted in the diagram.

3. Highlight any additional considerations or design

IV. Evaluation Criteria:

1. Accuracy and completeness of the ERD in reflecting the selected scenario and its complex business rules.

2. Adherence to normalization principles and best practices for efficient and effective database design.

3. Clarity and organization of the documentation and presentation.

4. Demonstration of an in-depth understanding of the scenario and the ability to translate complex business rules into a structured ERD.

Reference no: EM133529034

Questions Cloud

Explain the concept of participation fees : Explain the concept of participation fees. Discuss the benefits, guidelines and /or the pitfalls that you may incur with the implementation of such a program.
Provide discussion of the author review of the literature : Provide discussion of the author's review of the literatureo Population, sample size, and sample selection processo Research method(s) used in the study
Explain why use of analytics contributed to the problem : Share your chosen example, documenting your source. Be sure to summarize the scenario thoroughly. Explain why use of analytics contributed to the problem.
Examine the social media presence of two companies : Examine the social media presence of two companies operating in the same market and prepare a brief presentation on each company's use of social media.
Create a professional presentation to showcase the erd : Create a professional presentation to showcase the ERD, discussing the entities, relationships, and complex business rules depicted in the diagram.
Why do the cells shrink with the infusion of hypertonic : who has diarrhea receives a hypertonic saline solution intravenously to replace the sodium and chloride lost in the stool. Why do the cells shrink with
Exploring self-concept and identity : Exploring your self-concept and identity, including 2 communication theories (intercultural communication).
How does the nurse practitioner program and course align : How does the nurse practitioner program and course align with the AACN Essentials? How does the nurse practitioner program outcomes and course learning
With electronic addiction taking up so much of person life : With electronic addiction taking up so much of a person's life, they will need to determine ways to fill that time. Describe ways that this can be accomplished.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd