erd

ER Diagram using 3NF

by

   Let’s consider the following scenario: Papa Georgeo (AKA PG) is opening a Pizzeria and he needs a database to capture and maintain the data for the entities Sales, Customers, Products, Purchase, Suppliers, and Employees.  Business Needs: PG would like to capture all the sales data with the details of every order. An order could … Read more

Diagram

by

Task: Develop an entity relationship diagram for the MPA database. Diagram: Using Visio: Begin with the ”Crow’s Foot Database Notation” Visio template. Include these five entities:  Student Teacher Event Award Music — see below for attribute ideas All reasonable attributes should be included for each entity. A logical primary key (a unique attribute) must be … Read more