Systems Analysis and Design Based on your experiences in databases, select any patient clinic and create a data model a. Construct an entity-relationship context diagram and normalize to 3rd normal form and resolve any many-to-many relationships.

Draw an Entity Relationship Diagram for the proposed system based on therequirements showing the Entities, Attributes and Cardinality between entities.   Entities and Attributes Flavor Attributes: FlavorID, Name, Description Inventory Attributes: InventoryID, FlavorID, Quantity, ReorderThreshold Sale Attributes: SaleID, CustomerID, FlavorID, Date, Quantity, TotalAmount Customer Attributes: CustomerID, Name, Email, Phone Feedback Attributes: FeedbackID, CustomerID, Comment, Date, Rating Supplier Attributes: SupplierID, Name, ContactInfo Order Attributes: OrderID, SupplierID, FlavorID, OrderDate, Quantity, DeliveryDate Forecast Attributes: ForecastID, FlavorID, PredictedDemand, Date Relationships and Cardinality Flavor - Inventory One Flavor can have multiple inventory records. (1:N) Flavor - Sale One Flavor can be part of multiple sales. (1:N) Customer - Sale One Customer can have multiple sales. (1:N) Customer - Feedback One Customer can…

Develop/create a Decision Table and Decision Tree that represents the registration system at your school or an imaginary school. You will need to identify external entities, processes, and data stores before drawing the diagrams. P.S: I already have context diagram and the Diagram 0 DFD which are provided in the photos below.