Create a logical ERD for each of the problems on the following pages using the crowsfoot notation discussed in class. Be sure that each entity has the entity name at the top of the box, the primary key attribute or attributes in the middle of the box, and the non-primary key attributes in the bottom of the box. Lines should separate each part of the entity box. Follow these instructions about each ERD: The ERD should not have any many-to-many (M:N) relationships. Seriously. No M:N relationships. All attributes should be placed within an entity. Each entity must have a primary key defined. A primary key may consist of one or more attributes. Each relationship must have a foreign key. Denote the foreign key(s) with the notation (FK) on the ERD. It is not necessary to number the foreign keys. Each relationship must include both a maximum and minimum cardinality for both sides of the relationship. Each relationship must have a relationship verb. Keep in mind that 1:1 relationships are rare. Make sure that you carefully scrutinize any 1:1 relationships to ensure that they are actually 1:1.

Question #1. Design a database for ProLearning, a company that provides training services. ProLearning plans to use this database to keep track of: customers and potential customers, trainers, training offered and training categories, scheduled training, and expenses related to a specific training event. Each row in the worksheet represents one training class (called a training event) conducted by ProLearning. There is currently no unique identifier for a training event, but it is recommended that you create one like an EventID. Here are some business rules about the sample data: A customer has only one address and phone number. A customer is an organization rather than an individual person. The hourly price of training is related to the Training Type. In other words, the hourly price does not change if different trainers conduct the same course. The training expenses and travel expenses fluctuate by each different training event. For example in the sample data, the training expenses for Beginning MS Access Development were $250 for one training event while they were $85 for a different offering of that same course. The database must store the training expenses and travel expenses for each training event, rather than for a type of training event. The hourly rate paid to a trainer is related to a trainer. A trainer only has one hourly rate. If the end training date is null on the spreadsheet, then the training event has not yet occurred but is scheduled to occur. The training category is related to the type of training (as made unique by the trainingID). The company keeps track of only one category per specific type of training class. Create sample data tables for your final data model showing how all the data in ProLearningData spreadsheet will be stored among your newly designed tables. Make sure you include data for foreign keys as necessary to support the relationships on your data model (ERD).

Prolearning, IL Customer ID Customer Name 2 Customer Custom Customer Trainer City er State Zip Customer Phone ID Customer Address Trainer Trainer Name Hourly Rate Trainine Trainine Travel Training Category Hourly Price Expenses Expenses Start Training End Trainine Training Training Date Date Hours ID Training Description 3 10058 Fish Suvi 8997 Ocak Di NV 39521 17751265-8551 312 LA Marlin $25.00 11/20/2021 11/71/7921 12 Permin MS A Dog Ollic $50.00 $250.00 $15.00 4 312 Jane Martin $25.00 8 10058 EcoMed Services, Inc. 8922 Oakbroek Drne kena 10058 File SHIVE: 8997 kecak Di 12.577 Crandall Enterprises, 45 West 9th Street San Diego 5 49221 2751 261 8551 897521 (775265-8551 92128 898 777 6118 11/22/2021 11/22/2021 11/27/2021 11/24/7921 11/19/20121 11/24/20121 $15.00 SAR5.00 777, 20% Soon 24 $75.00 S6.5.10 15 Advanced MS Access Development uthea Developer 200 501 Service DES 211 9 Server Administration DE Ldministrator $99.00 $135.00 $150.00 $155.00 $150.00 $199.00 E: 42 $920.00! 7 12577 Crandall Enterprises, LLC 45 Miest Sth Street San Diego 321200581772-0001 525.CO 11/6/2021 11/9/2021 26 $95.00 $0.00 $505.00 15 Advanced MS Access Development Office Develope Sharepoint and Krawledge 57 MATHIET Olli 17577 Gratall Fleurs C 45 Weih STP- 51 Nige CA 92128 RSA 772 600 $29.00 17/4/2071 17/4/7021 $115.00 $42.00 $289.00 3:12 Jare Martin Kendall 26 SL Marianne 218 Yourdon Marianne 218 Yourtoi 212 Yeunion 9 1277 Crandall Enterprises, LLL 45 West sth Street San Diego CA 921284981272 GJU GODS SCO.UD 12/4/2021 12/1/2021 24 5/1 Procct Management Introduction PM $ $125.00 $235.00 $7.00 10 M 18923 Triceprvens, Ir 18922 Times, Inc. 3711 Corriente Blvd Stile Matis CA 3711 Corriente Santa Maria CA 93451 8051788-1122 ( 93454 ROSAR 4123 $50.00 $60.00 11/6/2021 11/11/2021 11/9/7071 11/10/2021 24 16 571 Project Management Inc.in 575 Pot Vallgement Salware 5125.00 $317.00 $195.0.1 $25.00 $49805 $731.00 PM 12 19800 Sivcrlard Inr 87 Double Diamond Las Vegas NV 99 109 7021544-6698 ( 312 Jare Martin $25.00 10/22/2321 11/5/2021 16 12 Beginning MS Access Development Office User $50.00 $85.00 $358.09 13 21500 Brez kerview Industries 990 Mericups Ave. Les vers WY BS115 1021945-1588 312 Jane Martin $25.00 11/29/2021 11/30/2021 16 $85.00 $135.00 $12000 | 15 dvd MS Access Development Cilice Developer Advanced MS Excel VBA 19 Programming cathlon Developer 14 251019 Crestiako Products 334 Horwoad Kud LAS VEGAS NV 49044 (7182 1489/91 312 lare Martin S25.10 12/2/20121 1272/2021 10 $89.00 SII.O. $.!! 15 16 19800 Siverlord Inr 19800 Siverlard in 87 Double Diarrone Las Vegas 8: Douala Diarrang Las Vegas NY NY BS109 70215428608 49109 (7025448 012 Jane Martin 22/ Anna Martinez 525.00 S/.00 1/31/2022 2/2/2022 15 Advanced MS Access Development Office-Ceveloper 200 SL Server Introduction De Descloser $35.00 $ 150.00 171