Flowchart, ERD and data dictionary PDF

Preview

Summary

Download Flowchart, ERD and data dictionary PDF

Description

MP3caprice.com Assignment 2

Presented to Professor Malleswara Talla COMM 226 Business Technology Management Section AA

Prepared by Alexander Fedotov 40113191 Shunwen Huang 27714394

Concordia University November 2019

Flow Chart

Assumptions: 1) One order can be paid only by one card. 2) Only cards can pay the order (no PayPal, etc.) 3) Prior for an order to be created, the customer must have a shopping cart.

Data Dictionary Table Name Album

Artist

Artist Album (associate)

Customer

Customer Order (Associate)

Label

Atribute Name

Contents

Format 1E+10

Y

PK

99

Y

FK

Artist

FK

Label

album_id

Album ID

Number(Interger)

artist_id

Artist ID

Number(Byte)

label_id

Record label ID

Number(Byte)

99

album_title

Album title

Short Text(50)

xxxxxxxxxx

album_desc

Album description

Long Text

xxxxxxxxxx

album_price

Album price

Currency

album_genre

Album genre

Short Text(50)

album_rating

Album rating scale(1-5)

Number

album_cust_review

Album customer review

Long Text

artist_id

Artist ID

Number(Byte)

Range

Required

PK or FK

FK Preferenced Table

Type

9999.99 xxxxxxxxxx 9

1 to 5

xxxxxxxxxx 99

Y

PK

artist_fname

Artist first name

Short Text(25)

xxxxxxxxxx

artist_lname

Artist last name

Short Text(25)

xxxxxxxxxx

artist_album_totalno

Artist Total number of albums

Number(Byte)

99

art_country

Artist original country

Short Text(25)

xxxxxxxxxx

label_id

Record label ID

Number(Byte)

99

FK

artist_album_id

Association Artist to Album id

Number(Interger)

1E+10

PK

artist_id

Artist ID

Number(Byte)

album_id

Album ID

Number(Interger)

Label

99 1E+10

cust_id

Customer account number

AutoNumber

999999999

cust_fname

Customer last name

Short Text(25)

xxxxxxxxxx

cust_lname

Customer first name

Short Text(25)

xxxxxxxxxx

cust_address_streetno.

Customer address

Number(Interger)

cust_address_streetname

Customer address

Short Text(25)

Y

PK

Y

PK

9999 xxxxxxxxxx

cust_address_city

Customer address

Short Text(25)

xxxxxxxxxx

cust_address_province

Customer address

Short Text(25)

xxxxxxxxxx

cust_address_country

Customer address

Short Text(25)

xxxxxxxxxx

cust_address_postalcode

Customer address

Short Text(25)

xxxxxxxxxx

cust_emailaddress

Customer emaill address

Short Text(25)

cust_birthdate

Customer date of birth

Date/Time

xxxxxxxxxx yyyy-mmdd

cust_order_id

Association Customer to Order id

Number(Byte)

99

cust_id

Customer account number

AutoNumber

999999999

FK

order_id

Order ID

Number(Byte)

99

FK

Order

album_id

Album ID

Number(Interger)

1E+10

FK

Album

FK

Shopping Cart

shopping_cart_id

Shopping cart ID

Number(Byte)

99

label_id

Record label ID

Number(Byte)

99

label_title

Record label title

Short Text(50)

xxxxxxxxxx

label_URL

Short Text(50)

xxxxxxxxxx

label_rep_fname

Record label website URL Record label's representative first name

Short Text(25)

xxxxxxxxxx

label_rep_lname

Record label's representative

Short Text(25)

xxxxxxxxxx

Y

PK

Customer

last name Order

Payment

Shopping Cart

order_id

Order ID

Number(Byte)

99

Y

PK

cust_id

Customer account number

AutoNumber

999999999

Y

FK

Customer

album_id

Album id

Number(Byte)

Y

FK

Album

date_create

Album date created

Date/Time

99 yyyy-mmdd

order_shipfee

Order shipping price

Currency

9999.99

order_totalprice

Order total price

Currency

9999.99

pay_id

Payment ID

Number(Interger)

order_id

Order ID

Number(Byte) Short Text (10) Number(Long Interger)

9999

Y

PK

99

Y

FK

Y

PK

pay_method

Payment method

xxxxxxxxxx

pay_card_no

Payment cardholder number

pay_card_fname

Payment cardholder first name

Short Text(25)

xxxxxxxxxx

pay_card_lname

Payment cardholder last name

Short Text(25)

xxxxxxxxxx

pay_cvv

Payment CVV number

Number(Interger)

shopping_cart_id

Number(Byte)

cust_id

Shopping Cart ID Shopping Cart customer account number

AutoNumber

album_id

Shopping Cart album ID

Number(Byte)

shopping_cart_totalprice

Shopping Cart total price

Currency

Order

"Visa" or "Mastercard"

999999999

999 99 999999999

Y

FK

Customer

99

Y

FK

Album

9999.99...