Posted: September 10th, 2021

IST7000 – Data Get research paper samples and course-specific study resources under   homework for you course hero writing service – Manage ment – Week 2 ERD Diagram

IST7000 – Data Get research paper samples and course-specific study resources under   homework for you course hero writing service – Manage ment – Week 2 ERD Diagram
Definition
Name: your name

The entity relationship diagram is crucial to the creation of a successfully implemented application and database. A good understanding of how to identify the components that define the Entity Relationship Diagram is needed. Select one of the following 5 scenarios and design an entity relationship diagram with the following components:

• Identify the entities that need to be modeled
• Identify the attributes that each entity will include
• Identify the relationships as required.
• Identify the primary keys (identifier attributes)
• Identify any business rules or assumptions that are associated with your data model

Scenario 1 – Online Ordering and Delivery Service for Sandwich Shop
Joe’s Sub Shop is starting an online ordering system that will provide local delivery within five miles of the sub shop. The customer can order a limited menu of the sandwiches the sub shop creates. The online order system will need to track the following information customer, order and product. They shop will need to know the quantity ordered, toppings and other directions for the order. The delivery driver will need to know the address and phone number of the customer.

ANSWER:
ERD Diagram for Definition for Scenario Question 1.

An entity-relationship diagram (ERD) can be defined as a data modeling technique that is design graphically to illustrates an information system’s entities and the relationships between those entities. The ERD is a conceptual and representational model of data used to represent the entire entity framework infrastructure.
Below is my explanation:
Entities: The entities from my scenario and my diagram are; Customers, Address, Orders, Products and Payment.
Attributes:
Customer: Customer name, customer_Id, phone number.
Address: Address_Id , place, Zip code
Orders: Customer_Id, quantity order, prices, payment_Id, and Date
Products: Product_Id, product name, and product type (sandwich)
Payment: Payment_Id, payment type, and card type.
Relationships:
Customer has only one address, therefore, customer is having one to one relation between customer and address.
Customer places many orders, therefore, customers are having many to many relationships between customer and order.
Order has many products; therefore, order is having one to many products between order to the product
Order has one payment; therefore, payment is having one to one payment methods between order to payment.
Primary Keys:
Customer_Id, address_Id, Order_Id, Product_Id, online order_Id, and Payment_Id.
The business rules are stated below:
Joe’s Sub Shop is starting an online ordering system. Joe’s Sub shop would be providing delivery locally to the customers within the range of five miles to the sub shop with the limited menu of the sandwiches.
Any online order system will need to be tracked the customer’s information.

Here is the question.
Assignment Definition:
For this assignment, you are to utilize the data model that was designed from the Week 2 ERD Diagram Definition assignment. This data model will be further reviewed and taken from the conceptual model to logical and physical model status.
Make sure you define the following:
1. Select a database management system (Oracle, SQL Server, MYSQL, etc.) and identify the data types and sizes for all attributes.
2. Make sure all relationships have been addressed and corrected.
3. Review the data model to ensure that it is in at least 3rd normal form (as defined by the normalization process).

Order | Check Discount