justLee.er 1.02 KB
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
# just lee
# Use MS Visio to draw an entity-relationship diagram (ERD) for the JustLee Book database (reference the structure of the database in
# Figure 1-5 in the Ppt presentation above). Draw a fully-labeled ERD that includes entities, labeled relationships 
# (indicate whether each relationship is mandatory or optional),
# primary keys, foreign keys, and cardinalities. Follow the format (Crow’s Foot notation) and naming conventions used in class.

[CUSTOMERS]
*CustomerN
Lastname
Firstname
Email
Address
City
State
Zip
Referred
Region

[ORDERS]
*OrderN
+CustomerN
Orderdate
Shipdate
Shipstreet
Shipcity
Shipstate
Shipzip
Shipcost

[ORDERITEMS]
*+OrderN
*+ItemN
ISBN
Quantity
Paideach

[BOOKS]
*ISBN
Title
Pubdate
+PubID
Cost
Retail
Discount
Category

[PROMOTION]
*Gift
Minretail
Maxretail

[PUBLISHER]
*PubID
Name
Contact
Phone

[BOOKAUTHOR]
*+ISBN
*+AuthorID

[AUTHOR]
*AuthorID
Lname
Fname

CUSTOMERS 1--* ORDERS
ORDERS 1--+ ORDERITEMS
BOOKS 1--+ ORDERITEMS
BOOKS 1--+ BOOKAUTHOR
PUBLISHER 1--* BOOKS
AUTHOR 1--* BOOKAUTHOR
#PROMOTION 1