Sedemac Mechatronics Research and Development Interview Questions and Answers

To create a complete schema for a hotel, you need to consider various entities like rooms, guests, reservations, staff, amenities, etc.

• Entities to include: rooms, guests, reservations, staff, amenities, invoices, payments

• Relationships between entities: guest stays in a room, staff manages reservations, amenities are available in rooms

• Attributes for each entity: room number, guest name, reservation date, staff ID, ameni

The number of television sets Flipkart should have in inventory to satisfy the entire demand during the big billion days.

• Estimate the demand based on previous sales data and market trends.

• Consider the production capacity and lead time for restocking.

• Factor in potential competition and pricing strategies.

• Use predictive analytics to forecast demand and optimize inventory levels.

• Ensure adequate safety stock to avoid stock

Sorry, I do not have access to the procurement data of Lays India.

• No data available

• Cannot answer the question

My favorite restaurant is a cozy Italian place called La Trattoria.

• Create a social media presence and post mouth-watering pictures of the food

• Offer a loyalty program to encourage repeat customers

• Partner with food bloggers and influencers to promote the restaurant

• Host special events like wine tastings and cooking classes

• Offer delivery and takeout options to reach a wider audience