Assignment | MIST 351 Assignment

Running head: MIST 351 ASSIGNMENT
MIST 351 Assignment
Name of the Student
Name of the University
Author’s name

MIST 351 ASSIGNMENT1
Part One:
Table: Team
Entity Primary Key Foreign Key Reference
TID Yes
TName
TColor
Manager Yes (Null) Member (MNum)
Table: Member
Entity Primary Key Foreign Key Reference
MNum Yes
MFirst
MLast
Team Yes Team (TID)
Table: MemberPhone
Entity Primary Key Foreign Key Reference
MNum Yes Yes Member (MNum)
MPhone Yes
Table: Player

MIST 351 ASSIGNMENT2
Entity Primary Key Foreign Key Reference
MNum Yes Yes Member (MNum)
PDOB
PSize
Parent Yes Parent (PID)
Table: Parent
Entity Primary Key Foreign Key Reference
PID Yes
PFirst
PLast
IsMarriedTo Yes (Null) Parent (PID)
Table: Uniform
Entity Primary Key Foreign Key Reference
UID Yes
UType
UColor
Table: Supplier
Entity Primary Key Foreign Key Reference