Physical Database Design

All instruction is at the screenshots

Please let me know if you have any questions

Two sample data dictionary formats are provided here. Decide on one of the sample data
dictionary formats. Use the logical data model that you developed in week 3. Identify the entities
from the draft of your data model submitted during Week 3. Provide a sample data dictionary of
all entities selected for your model.
DATA DICTIONARY
Table Name
Column Name
Column Type
Column size
Column Status
Comment
Team_T
Team_ID
Character
10
NOT NULL
Can contain
Primary key
letters
NOT NULL
Can contain
Team_Name
Character
30
letters
Team_Description
Character
50
NOT NULL
Can contain
letters
Uniform_T
Team_Color
Character
10
NOT NULL
Y,N
Uniform_ID
Character
10
NOT NULL
Can contain
Primary key
letters
NOT NULL
Can contain
Uniform_Name
Character
20
letters
Descrition
Character
50
NOT NULL
Can contain
letters
Game_T
Game_ID
Character
10
NOT NULL
Can contain
Primary key
letters
Game_Stadium
Character
20
NOT NULL
Can contain
letters
Game_Date
Date Time
NOT NULL
Format
(mm/dd/yy
Game_Score
Character
30
NOT NULL
Can contain
letters
Game_Result
Character
50
NOT NULL
Can contain
letters
Player_T
Player_ID
Player_Number
Character
Character
10
10
NOT NULL
Can contain
Primary key
letters
NOT NULL
Can contain
letters
Last_Name
Character
30
NOT NULL
Can contain
letters
First_Name
Character
30
NOT NULL
Can contain
letters
Player_Gender
Character
20
NOT NULL
Can contain
letters
Player_Age
Character
10
NOT NULL
Can contain
letters
Phone_Number
Character
10
NOT NULL
Can contain
letters
Player_Position
Character
30
NOT NULL
Can contain
letters
Position_T
Position_ID
Position_Name
Character
Character
10
30
NOT NULL
Can contain
Primary key
letters
NOT NULL
Can contain
letters
Position_Description
Character
50
NOT NULL
Can contain
letters
Physical Database Design
. Use the Data Dictionary that you developed in week 4 for your selected scenario.
• From the data dictionary tables, build MS Acess tables.
• Via “Database Tools” create table relationships