Question 1 (30 marks) A food establishment has many outlets in various parts of Singapore, offering both set meals as well as ala carte items. A set meal consists of two or more food items that are bundled (e.g., soup, main and dessert) and is attractively priced compared to when food items are purchased individually. In addition, set meals and ala carte food items enjoy discounts of varying amount periodically. To expand its customer base, the food establishment also makes use of several delivery platforms to allow customers to make online orders. Write My Assignment Hire a Professional Essay & Assignment Writer for completing your Academic Assessments Native Singapore Writers Team 100% Plagiarism-Free Essay Highest Satisfaction Rate Free Revision On-Time Delivery You are to construct a conceptual (ER) model to support the daily operations of the food establishment and to subsequently perform data analysis on data from its daily operations. Daily operations include: • Introducing new set meals and ala carte food items, indicating name, price, description, and availability, and identified with an item code. Marking set meals and ala carte food items as available/not available when they are no longer in the menu. Setting up discount amount and discount period (start of period and end of period) for set meals and ala carte food items. Updating the current undiscounted prices of set meals and ala carte items. • Establishing new outlets, each with an address, a seating capacity, area of location (north, south, east, west, and central), phone numbers, and a unique outlet name. Having a central kitchen allows all outlets to offer the same set meals and ala carte items at standard prices. Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers Get A Free Quote • Accepting orders both online and in-person. Each order is identified by an order number and date and time of order. Online order is made through delivery platform to the outlet selected on the platform. An online order also includes the delivery charges levied on the customer, the time the order was collected. For every delivery platform, record the name of the delivery partner, an email and a contact to call in cases of delivery issues. For in-person order, record the size of the dining group. • Allowing for customer feedback Customers can provide feedback on either the food items, service and/or delivery. Each feedback is identified by an auto-generated identification number, the date and time of the feedback is made, a description and a rating. Upon receipt, a staff may categorise the feedback as positive or negative and then provide a response with a datetime of response. In some cases, there may be several follow-up responses to a feedback after some investigation. Some analysis includes the following queries, therefore, do ensure that your design can support these queries: • The size of order in terms of number of food items purchased where food items in set meal are individually counted. Include the total cost of the order, total discount applied, the number of discounted food items and the number of food items without a discount. • The average spending per pax for in-person orders. • The number of online and in-person orders respectively in hourly slots, e.g., 11.00 am to 11.59 am, showing the most popular hour slots first. • The number of orders by outlet area of location (north, south, east, west, central) and the average number of phone lines (or phone numbers) for outlets in an area of location. • The number of negative and number of positive feedback received for orders made online and orders made in-person for each outlet. Construct a conceptual (ER) model from the statements of requirements to represent the data model, showing • entities, with entities name, relevant attributes and identifier, (13 marks) • relationships with maximum and minimum cardinalities and relationship name (17 marks) State your assumption(s) for only data requirements that are not specified. Show your model as ONE diagram. Buy Custom Answer of This Assessment & Raise Your Grades Get A Free Quote
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO ChatGPT.NO PLAGIARISM – CUSTOM PAPER
Looking for unparalleled custom paper writing services? Our team of experienced professionals at AcademicWritersBay.com is here to provide you with top-notch assistance that caters to your unique needs.
We understand the importance of producing original, high-quality papers that reflect your personal voice and meet the rigorous standards of academia. That’s why we assure you that our work is completely plagiarism-free—we craft bespoke solutions tailored exclusively for you.
Why Choose AcademicWritersBay.com?
- Our papers are 100% original, custom-written from scratch.
- We’re here to support you around the clock, any day of the year.
- You’ll find our prices competitive and reasonable.
- We handle papers across all subjects, regardless of urgency or difficulty.
- Need a paper urgently? We can deliver within 6 hours!
- Relax with our on-time delivery commitment.
- We offer money-back and privacy guarantees to ensure your satisfaction and confidentiality.
- Benefit from unlimited amendments upon request to get the paper you envisioned.
- We pledge our dedication to meeting your expectations and achieving the grade you deserve.
Our Process: Getting started with us is as simple as can be. Here’s how to do it:
- Click on the “Place Your Order” tab at the top or the “Order Now” button at the bottom. You’ll be directed to our order form.
- Provide the specifics of your paper in the “PAPER DETAILS” section.
- Select your academic level, the deadline, and the required number of pages.
- Click on “CREATE ACCOUNT & SIGN IN” to provide your registration details, then “PROCEED TO CHECKOUT.”
- Follow the simple payment instructions and soon, our writers will be hard at work on your paper.
AcademicWritersBay.com is dedicated to expediting the writing process without compromising on quality. Our roster of writers boasts individuals with advanced degrees—Masters and PhDs—in a myriad of disciplines, ensuring that no matter the complexity or field of your assignment, we have the expertise to tackle it with finesse. Our quick turnover doesn’t mean rushed work; it means efficiency and priority handling, ensuring your deadlines are met with the excellence your academics demand.
