Project 2 involves developing an ER and relational solution for the case and completing an implementation as per the guidelines below. Use LucidChart for parts 1 and 2 and SQL server/Access for part 3. Include the following in Word (in landscape mode, if necessary). Use the snipping tool to include the relevant portion. Submit a single file for the following: 1. The high-level ER data model of the application. This diagram does not have fields. (30%) 2. Logical ER model for one use case with at least four tables, although you can complete the full case's relational model. The model should include the fields and have foreign keys. The diagram is your relational representation. (40%) 3. An implementation of the relational representation in SQL Server or Access for one use case (say, about four tables). Show primary and foreign keys, and build relationships. Include the relationship diagram in the solution. Steps 2 and 3 can be combined. (20%) 4. List two non-primary key fields that should be indexed. (10%) Equipment Some of the rooms at the center contain pieces of exercise equipment. Each piece of equipment has a unique serial number (provided by its manufacturer) used to track it in the center. Also recorded for each piece are its purchase date and the date of its last maintenance. Each piece of equipment belongs to a specific equipment type. For example., the center might own five StairMaster 5000 machines, each having a unique serial number, all considered a single equipment type. Each equipment type is assigned 1 a unique sequential three-digit identification number. Also recorded for each type are its description, the manufacturer's model number, and the recommended maintenance interval for that model of equipment. Maintenance/Repair For equipment maintenance, information on the manufacturer of the equipment is recorded. Each equipment type is associated with a single manufacturer, which is referenced by an assigned unique sequential two-digit manufacturer ID number. Additional information maintained on each manufacturer is the company name, address, phone number, and fax number. When the maintenance or repair is required on one or more equipment, a work order is generated. Each such work order is given a unique sequential five-digit number. Also recorded for each work order is the date of the order, the serial numbers of the equipment involved, the vendor performing the maintenance, and (when the work is completed) the amount charged for the work. Vendor information such as id, name, contact information is maintained Project 2 involves developing an ER and relational solution for the case and completing an implementation as per the guidelines below. Use LucidChart for parts 1 and 2 and SQL server/Access for part 3. Include the following in Word (in landscape mode, if necessary). Use the snipping tool to include the relevant portion. Submit a single file for the following: 1. The high-level ER data model of the application. This diagram does not have fields. (30%) 2. Logical ER model for one use case with at least four tables, although you can complete the full case's relational model. The model should include the fields and have foreign keys. The diagram is your relational representation. (40%) 3. An implementation of the relational representation in SQL Server or Access for one use case (say, about four tables). Show primary and foreign keys, and build relationships. Include the relationship diagram in the solution. Steps 2 and 3 can be combined. (20%) 4. List two non-primary key fields that should be indexed. (10%) Equipment Some of the rooms at the center contain pieces of exercise equipment. Each piece of equipment has a unique serial number (provided by its manufacturer) used to track it in the center. Also recorded for each piece are its purchase date and the date of its last maintenance. Each piece of equipment belongs to a specific equipment type. For example., the center might own five StairMaster 5000 machines, each having a unique serial number, all considered a single equipment type. Each equipment type is assigned 1 a unique sequential three-digit identification number. Also recorded for each type are its description, the manufacturer's model number, and the recommended maintenance interval for that model of equipment. Maintenance/Repair For equipment maintenance, information on the manufacturer of the equipment is recorded. Each equipment type is associated with a single manufacturer, which is referenced by an assigned unique sequential two-digit manufacturer ID number. Additional information maintained on each manufacturer is the company name, address, phone number, and fax number. When the maintenance or repair is required on one or more equipment, a work order is generated. Each such work order is given a unique sequential five-digit number. Also recorded for each work order is the date of the order, the serial numbers of the equipment involved, the vendor performing the maintenance, and (when the work is completed) the amount charged for the work. Vendor information such as id, name, contact information is maintained