How to model databases using entity relationship diagrams

Assignment Help Computer Engineering

Reference no: EM133239964

Goal: Learn how to model databases using Entity Relationship diagrams

ERD should display entities, attributes, relationships, cardinalities, names of relationships, keys (PK, FK).Suppress the data types for attributes. Create additional attributes as needed.

AMAZING SCENARIO

A giant in online shopping, Amazing has established itself as a convenient, efficient, and global service. We would like to design a data model for their business. Here are some details.

Amazing sells products (no services) to customers
Products are sourced from one or many vendors
Customers can buy several products at a time in an order
The sale is recorded in a sales order which can contain many line items.
Each line item lists the product purchased, source (vendor), price, quantity, and extended price

Reference no: EM133239964

Questions Cloud

Identify a policy or practice related to recruitment : Human Resource Policy Discussion - Identify a policy or practice related to recruitment in your organization(Restaurants)

Convey the rationale behind your choice : CS 2301 University of the People - Choose the method of which your companys device's CPU will choose process precedence, using the methods mentioned

The repayment of home loan in future : Mrs Smith has residual income of $48,000 pa which she can put towards the repayment of a home loan in the future.

Describe contributions as source of income to united states : Tourism forms an important source of income. Describe these contributions as a source of income to the United States.

How to model databases using entity relationship diagrams : ART-UE 22 New York University how to model databases using Entity Relationship diagrams - Products are sourced from one or many vendors

Why mature firm with history of stable earnings : Explain two reasons why a mature firm with a history of stable earnings, few investment opportunities and a diverse clientele of investors

Discuss how increasing your level of education would affect : Discuss how increasing your level of education would affect how your competitiveness in the current job market and your role in the future of nursing

What you think will happen if you stare at yellow triangle : BIO 102 J Sargeant Reynolds Community College what you think will happen if you stare at the yellow triangle for 30 seconds. Then, create a second hypothesis

Which is associated with hospitality and tourism industry : Find ONE latest Journal Article (2018-2022) which is associated with hospitality and tourism industry.

User Account

All Pages