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.

 

Transcribed Image Text:

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 NOT NULL letters Can contain Team_Name Character 30 letters Team_Description Character 50 NOT NULL Can contain letters Team_Color Character 10 NOT NULL YN Uniform_T Uniform_ID Character 10 NOT NULL Primary key NOT NULL Can contain letters 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 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 NOT NULL letters Can contain Team_Name Character 30 letters Team_Description Character 50 NOT NULL Can contain letters Team_Color Character 10 NOT NULL YN Uniform_T Uniform_ID Character 10 NOT NULL Primary key NOT NULL Can contain letters 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

Answer rating: 100% (QA)

Step 1 Create relations from entities with same attr... View the full answer