Create a equipment table with the following information: (Create a composite key) equipmentId - primary key equipmentDesc

Fantastic news! We've Found the answer you've been seeking!

Question:

Create a equipment table with the following information: (Create a composite key)
equipmentId - primary key
equipmentDesc
equipmentPrice - primary key

b. Create an rental table with the following fields:
Rentalid- primary key
RentalDate - primary key
equipmentId - foreign key
equipmentPrice - foreign key
Status

c. Use appropriate data types and CONSTRAINTS, while creating tables.