ms project software engineering sample file

The customer ordered online then the data table has the customer’s address, customer name, order details, and delivery boy id. The customer data table has customer order details and customer names. The Staff has staff id, staff age, staff assigned work, staff address, and staff experience.ĭata table for a delivery system where it has details of delivery boy, location of the delivery, order details

The manager data table has the manager id, manager name, manager age and management experience, and manager address.

The Restaurant is located in different locations so it has a restaurant id and restaurant address. The staff are of different types such as cashier, waiter, receptionist, cleanerĬustomers who order online, who visit the store and have dine-in, and others who take awayĭelivery guy who takes the orders and delivers the food to the customer The store manager who takes care of the restaurant manages the staff and the daily supplies like food items Stage2: logical design: The Database consists of 5 data tables which are Stage1: Analysis: The main objective of the database is to manage the details of the staff of the restaurant, the customer who visits the restaurant to order and take away behavior that the customers who order online, and manage the delivery system where the restaurant can assign delivery boys to deliver the food the customer.

Must learn to design a logical relational database.

Microsoft Access is a database management system from Microsoft that combines the relational Microsoft jet database engine with a Graphical user interface and software tools.

The language and its implementations provide strong support to software engineering principles. C# is a programming language that is simple, and modern.

Learning C# to create an application to connect with Microsoft access.

Collecting the information from the Restaurant owner visa by reading articles or interviewing the store manager of the company.

This database system is developed in such a way that restaurant can get accurate details of both offline and online ordering through mobile or web application so customer gets a notification if the order is ready for pickup and customer can track the order if he/she orders online for home delivery.ĭue to this database management system, we can reduce the complexity between restaurant management and customers.

Ms project software engineering sample file