Design a database diagram.

Design a database for a landscaping company to help keep track of their contracts. Each contract has a unique contract number, a date that the contract was signed, and a contract amount. Each contract is also of a given must have a customer and a contract t stored in the database even if the customer does not c currently related to a contract. Sample data for this database is provided below. type. A contract can only be of one type. Each contract is with only one customer. A contract n identifier (CustomerID), a CustomerName, a phone number, a city and a state. A customer may be urrently have a contract. A contract type may be stored in the database even if the contract type is not ContractContract Number Amount Customer Signing DateTypelD Contract T ID CustomerName 30201 $6,500.00-1/19/2018 $7,500.00 9/23/2017 A100 | Landscape Design A120 Playground Design A120 Playground Design Fox and Hound Grille Finn's on the Waterfront Dept. of Neighborhood 11055 269-979-2004 Battle Creek M 616-393-1228 Holland 616-940-3888 Rapids 616-393-1228 Holland 616-940-3380 Flint - MI East Grand 3065 $38,000.00 3069 $15,750.00 2/24/2017 A100 Landscape Design 3070 $35,000.003/3/2017 3071 $37,000.0012/11/2017 C200 Landscape Maintenance 3072 $46,000.001/11/2018B6 10Landscape Renovation 11059 3075 $16,500.00 3077 3078 $13,750.00 9/25/2017A100 Landscape design 3080 $22, MI Finn's on the Waterfront Pleasant Development G.R. Neighborhood Development 616-392-0015 Grand Rapids M A100 Landscape Design 11097 G.R. Neighborhood Develop -- - . - 269-985-1992 Saint Joseph Mi 11067 Blossom Day Care Center A120 Playground design A100 Landscape design 1/8/2018 269-857-1771 Saugatuck MI Cherrywood Senior Center Battle Creek Dental Partners Finn's on the Waterfront Blue Star Mini Golf Dept. of Neighborhood 11058 6,500.00 5/17/2017 269-963-0808 Battle Creek MI 616-393-1228 Holland 269-857-4424 Saugatuck MI 616-940-3888 Rapids 269-985-1992 Saint Joseph MI 616-393-1228 Holland 800.00 4/14/2017 A100 Landscape Design 3081 $21,000.00 10/10/2017 A100 Landscape design East Grand Mi 3090 $25,500.00-6/14/2017-. B720 , playground 11067 Blossom Day Care Center 3099 $6,500.007/25/2017A100 landscape design C200 Landscape Maintenance 11030Finn's on the Waterfront -Mi MI 9,500.008/24/2017 11059 G.R.NeighborhoodDevelopment-1616-392-0015-1 Grand Rapids A100 | LandscapeDesign 3109-1 $41,000.00..--1/18/2018 616-940-3380 Flint 720 Playground renovation11097_-Pleasant Development --$38,000.00 -8/25/2 017 3110