ITEC-8145 Entity Relationship Of Sales
Added on 2022-08-19
15 Pages1086 Words16 Views
|
|
|
Running head: ITEC-8145
ITEC-8145
Name of the Student:
Name of the University:
Author Note:
ITEC-8145
Name of the Student:
Name of the University:
Author Note:
ITEC-81451
Table of Contents
Normalization.............................................................................................................................2
Customer................................................................................................................................2
Sales Representatives.............................................................................................................4
Orders.....................................................................................................................................5
Order Lines.............................................................................................................................6
Part Description......................................................................................................................7
Business Rules...........................................................................................................................9
Entity Relationship Diagram....................................................................................................11
References................................................................................................................................13
Table of Contents
Normalization.............................................................................................................................2
Customer................................................................................................................................2
Sales Representatives.............................................................................................................4
Orders.....................................................................................................................................5
Order Lines.............................................................................................................................6
Part Description......................................................................................................................7
Business Rules...........................................................................................................................9
Entity Relationship Diagram....................................................................................................11
References................................................................................................................................13
ITEC-81452
Normalization
Customer
3NF
CustName
Customer ID Last Name First Name
124 Student’s last name Student’s first name
256 Instructor’s last name Instructor’s first name
311 Charles Don
315 Daniels Tom
405 Williams Al
412 Adams Sally
522 Nelson Mary
567 Dinh Tran
587 Galvez Mara
622 Martin Dan
CustAddress
Customer ID Street Address City State Zip Code
124 481 Oak Lansing MI 49224
256 215 Pete Grant MI 49219
311 48 College Ira MI 49034
315 914 Cherry Kent MI 48391
405 519 Watson Grant MI 49219
Normalization
Customer
3NF
CustName
Customer ID Last Name First Name
124 Student’s last name Student’s first name
256 Instructor’s last name Instructor’s first name
311 Charles Don
315 Daniels Tom
405 Williams Al
412 Adams Sally
522 Nelson Mary
567 Dinh Tran
587 Galvez Mara
622 Martin Dan
CustAddress
Customer ID Street Address City State Zip Code
124 481 Oak Lansing MI 49224
256 215 Pete Grant MI 49219
311 48 College Ira MI 49034
315 914 Cherry Kent MI 48391
405 519 Watson Grant MI 49219
ITEC-81453
412 16 Elm Lansing MI 49224
522 108 Pine Ada MI 49441
567 808 Ridge Harper MI 48421
587 512 Pine Ada MI 49441
622 419 Chip Grant MI 49219
CustBlnc
Customer ID Current Balance Credit Limit
124 818.75 1000
256 21.5 1500
311 825.75 1000
315 770.75 750
405 402.75 1500
412 1817.5 2000
522 98.75 1500
567 402.4 750
587 114.6 1000
622 1045.75 1000
CustSales
Customer ID Sales Rep ID
124 3
256 6
412 16 Elm Lansing MI 49224
522 108 Pine Ada MI 49441
567 808 Ridge Harper MI 48421
587 512 Pine Ada MI 49441
622 419 Chip Grant MI 49219
CustBlnc
Customer ID Current Balance Credit Limit
124 818.75 1000
256 21.5 1500
311 825.75 1000
315 770.75 750
405 402.75 1500
412 1817.5 2000
522 98.75 1500
567 402.4 750
587 114.6 1000
622 1045.75 1000
CustSales
Customer ID Sales Rep ID
124 3
256 6
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Implementation Assignment Reportlg...
|10
|1642
|12