Consider the following parking tickets. Create ERD using Crow’s Foot notation with relationship cardinality, modality, & relationship strength and implement normalization on each entity to finalize your ERD. Note that St Lic, Lic No (car plate # and State where it is issued) are for a car; St ID, LN, FN, and Phone# are for the owner of the car; code represents a specific parking violation with the corresponding fine. Parking Ticket Table St ID Lname Fname PhoneNumb StLic LicNumb Ticket# Date Code Fine 38249 Brown Thomas 111-7804 FL BRY123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE141 14987 10/05/12 3 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25
Consider the following parking tickets. Create ERD using Crow’s Foot notation with relationship cardinality, modality, & relationship strength and implement normalization on each entity to finalize your ERD. Note that St Lic, Lic No (car plate # and State where it is issued) are for a car; St ID, LN, FN, and Phone# are for the owner of the car; code represents a specific parking violation with the corresponding fine.
Parking Ticket Table
St ID Lname Fname PhoneNumb StLic LicNumb Ticket# Date Code Fine
38249 Brown Thomas 111-7804 FL BRY123 15634 10/17/12 2 $25
16017 11/13/12 1 $15
82453 Green Sally 391-1689 AL TRE141 14987 10/05/12 3 $100
16293 11/18/12 1 $15
17892 12/13/12 2 $25
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)