Using Microsoft Visio create your data model by drawing the Entity-Relationship Diagram for your project. This diagram should include all entities of interest to your subject. Create entities, form relationships, and show cardinalities of the relationships. Consistency is important. Please make sure your ER Diagram matches the data flow diagrams and the business analysis you developed earlier. When creating your ER Diagram you can make assumptions related to the real-life restrictions of your business.

make the necessary changes to make MacDonalds more marketable, more profitable,customers satisfaction total redesign of all our stores, better inventory management,improvement in the way our stores are managed.As of today, not all our MacDonalds offer fantastic service and good marketable strategies thatwill keep our business up and running to compete with other restaurants and the demand ofcustomers expectations.Our information management and design team is struggling to obtain ways to put MacDonaldsat the top of the competition. For example, how can we obtain faster service when people aregoing through the drive thru or when they come inside to buy something. The problem with this,is that sometimes people do not know what they want or people must wait on their order aftermaking their purchase.

Business AnalysisOur customers will place their order on our newly design MacDonalds app. When they aresearching through the menu on the app, it will also show the price of each item before one gets tothe check out. In addition, there will be a time slot for when customers want to pick up theirfood. When they checkout on the app or at the store, customers will be given a receipt with theirorder and an order number. Then they can show or tell the cashier when they go through thedrive thru, or when they go inside what their order number is.When the cashier enters the customer order number and time, the information management teamwill be able to keep track of the time when the order was placed and what item was order insome type of database. We will also be able to keep track of how long it took for the customer toreceive their order.Every six months we will check our database and see what each customer order based on theirorder number. Then we can determine what the customers order the most and send themcoupons based on what they like to order the most. With all. this data, our design team can comeup with ways to design a system that will make our brand more marketable