Pay
Sports Card Collecting Data Model

Sports Card Collecting Data Model

Source_Types

PK source_type_code

source_type_description

eg Collector, Individual

eg Supplier, Unknown

Players

PK player_id

name

gender

playing_career

date_of_birth

place_of_birth

other_details

Sports

PK sport_name

sport_description

eg Baseball, Basketball

eg NFL Football1

Players_Teams

PF player_id

PF team_id

PK date_from

date_to

Teams

PK team_id

FK sport_name

team_name

location

first_date

last_date

other_details

Sources

PK source_id

Fk source_type_code

source_name

source_address

phone

cell_mobile_phone

email_address

address

city

state

other_details

Cards

PK card_id

FK card_type_code

FK Player_id

FK source_id

Fk team_id

date_purchased

date_sold

card_acquired_from

brand

series

description

other_details

Card_Types

PK card_type_code

card_type_description

eg Complete Set, Insert

eg Rookie, Unopened

eg Hobby Boxes, Retali Boxes

15
0
0
publish time: 2021-06-04
Captain O Captain

Sportscard collecting data model helps design the database at the conceptual, physical, and logical levels. Create a sports card collecting data model using EdrawMax or EdrawMax Online's free data model templates. It should be noted here that sportscard collecting data model structure helps to define the relational tables, primary and foreign key, and stored procedures. As the below image represents, this data model provides a clear picture of the base data and can be used by database developers to create a physical database. A data model explicitly determines the structure of data as these are typically specified by a data specialist.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
22
0
0
DILSHAN SACHINDRA