THE DATA MODEL / TUTORIALOUTLET DOT COM - PowerPoint PPT Presentation

About This Presentation
Title:

THE DATA MODEL / TUTORIALOUTLET DOT COM

Description:

Four entities have been identified for the data model – Partner, Customer, Order and Product Some attributes for each of these entities include: Partner – Name, Address Customer – Name, Email Address Order – Date, Dollar Amount Product – Name, Description – PowerPoint PPT presentation

Number of Views:2
Slides: 4
Provided by: albert0086

less

Transcript and Presenter's Notes

Title: THE DATA MODEL / TUTORIALOUTLET DOT COM


1
THE DATA MODEL / TUTORIALOUTLET DOT COM
2
THE DATA MODEL / TUTORIALOUTLET DOT COM
The data model  FOR MORE CLASSES VISIT
www.tutorialoutlet.com Four entities have been
identified for the data model Partner,
Customer, Order and Product Some attributes for
each of these entities include Partner Name,
Address Customer Name, Email Address Order
Date, Dollar Amount Product Name,
Description Be sure to identify the unique
identifier (primary key) for each entity the
attribute or attributes that uniquely identify
each row in an entity.  Also identify any foreign
keys you would include as attributes for the
entities to establish relationships between
them.  Highlight the unique identifier(s)
(primary key) for each entity in yellow. 
Highlight foreign keys that you include as
attributes for entities in pink. Below is
information on the relationships between the
entities A partner can provide many different
types of products to Amazon, and a given product
could be provided by more than one partner.  A
partner record could be set up without any
associated products, but a product must have at
least one partner record associated with it.
3
THE DATA MODEL / TUTORIALOUTLET DOT COM
Thank you
Write a Comment
User Comments (0)
About PowerShow.com