Questions Regarding the Database

Please check the attached images for the guideline

Let me know if you have any questions.

Doc file belongs the previous assignmet

Scenario 2
A Local Football League
Name
Affiliation
Date
In this scenario, I will create the E-R Diagram with 5 tables and attributes on each table.
Formulating this ERD, I have used the PostgresSQL .x database. This database is accurate for me,
as it allow me to simply build the tables and attribute direct to the features that I need to form.
Local Football League (Database)
Data type and Sizes
On the above database design, I have included sizes together with the data types of my
attributes in each table. Such in the Team table, the data type is int, having the sizes of Var 256 to
the attribute of Team_Name. In Uniform table, the data type is also int, having var 128 size to the
Uniform_name. In the Players table, I have data type int, having var 256 to those attributes of both
First and Last name and the Player age attribute, also, var 64 to the Player number and Player age
attributes. In the Games table, I have int data type. In the Positions table, I have also data type
together with the Fact table with timestamp and var 256.
Data Model (3NF)
The data model within my database is in the 3rd normal form. As seen on the above
database that I have formulated, this accurately demonstrate and satisfies the prerequisites for the
3NF. Additionally, this is typically adequate which eventually, I have made the tables in accordance
to the relation of attributes and its relationships.
• 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.
Two Sample Data Dictionary Formats
Data Dictionary for Hotel Management System
Service Order Table – This table contains the employee and services they provided
Attribute
Data Type
Size
Primary
Key
Description
Y
Service_Order_ID
INTEGER
Unique ID of service order
Order ID
INTEGER
To identify which order (foreign key)
Service_ID
INTEGER
To define Service details (foreign key)
Category Table – This table contains all categories of food
Attribute
Primary
Key
Data Type
Size
Description
Y
Category_id
INTEGER
Unique Id of category
Category_Name
VARCHAR2
50
Name of Category
Employee Table-This table contains details of employee
Attribute
Data Type
Size
Primary
Key
Description
Y
Employee_id
INTEGER
Unique Id of employee
Name
VARCHAR2
50
Name of employee
AddressLine1
VARCHAR2
100
Address of employee
AddressLine2
VARCHAR2
100
Address of employee
Zipcode
VARCHAR2
10
Zip code of related address
State
VARCHAR2
30
State of residence
Country
VARCHAR2
30
Country of related address
BDate
Date
Birth date of employee to fetch age of
employee
Contact Number
VARCHAR2
20
Contact information such as mobile, house,
cell, work number
Data Dictionary
Table Name
Column Name
Comments
Column
Type
Column
Size
Column
Status
In bytes
CM_T
CM_Number
Character
10
Not Null
Can contain letters
Primary
Key
CM_Requestor
Character
30
Not Null
CM_Request_Date
Date Time
Not Null
Format
mm/dd/yyyy
hh:mm:ss
CM_Request_Desc
Character
50
Not Null
CM_Request_Type
Character
10
Not Null
C.E.,L,P,T,S,V
CM_Platform
Character
1
Not Null
L,U,
MW
Approval_T
Apprv_Cm_Number
Character
10
Not Null
Can Contain letters
Primary
Key
Apprv_Schd_Dept_Flag
Character
1
Not Null
Y.N
Apprv_Spt_Dept_Flag
Character
1
Not Null
Y.N
Apprv_Spt_CM_Flag
Character
1
Not Null
Y.N
Apprv_Schd_Cmnts
Character
50
Apprv_Spt_Cmnts
Character
50
Apprv_CM_Cmnts
Character
50
SLCM_T
SCM_CM_Number
Character
Character
10
Not Null
Can contain letters
Primary
Key
SLCM_Request_Type
Character
10
Not Null
C.E.L,P,T
SLCM_Assginee_Group
Character
20
Not Null
SLCM_Ack_Date
Date
Time
Not Null
Format mm/dd/yy
Hh:mm:ss
SLCM_Start_Date
Date Time
Not Null
Format mm/dd/yy
Hh:mm:ss
SLCM_CTD_Date
Date Time
Not Null
Format mm/dd/yy
Hh:mm:ss
pg.4