Solved by verified expert:Please check the attached images for the guideline Let me know if you have any questions.Doc file belongs the previous assignmet
20180409215803screen_shot_2018_04_09_at_5.55.42_pm.png
20180409215804screenshot.png
20180328101019erd__1_.docx
Unformatted Attachment Preview
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.
…
Purchase answer to see full
attachment
