Question: Create a equipment table with the following information: (Create a composite key) equipmentId - primary key equipmentDesc equipmentPrice - primary key b. Create an rental

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.

Step by Step Solution

★★★★★

3.38 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Certainly heres how you can create the equipment table and rental table with the specified fields an... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

A researcher recruits 221 college students from an introductory psychology course to participate in a study. They are randomly assigned to complete an intelligence test on a tablet (n = 110) or on...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

For all of your assignments in the class this summer, you will be working on a database for a local veterinary clinic. The focus on the clinic is small animals (pets) and will not provide services...

What is the final pressure of a gas whose initial conditions are 1.407 L, 2.06 atm, and 67C and whose final volume and temperature are 608 mL and 449 K, respectively? Assume the amount remains...

You find an abandoned mine shaft and wish to measure its depth. Using an audio oscillator of variable frequency, you note that you can produce successive resonances at frequencies of 63.58 and 89.25...

At http://ftc.gov/ the Federal Trade Commission provides information on enforcement cases it has brought against franchisors who violate FTC rules. Do you see a pattern? Are some violations more...

In what ways might an assessment of an individuals competency to stand trial differ from an assessment of an individual pleading NGRI?

The Coca-Cola Company and PepsiCo, Inc. Instructions Go to the books companion website and use information found there to answer the following questions related to The Coca-Cola Company and PepsiCo,...

17. Required information [The following information applies to the questions displayed below.] University Car Wash purchased new soap dispensing equipment that cost $213,000 including installation....

1. The endpoints of the bottom side of a parallelogram are at A(2, 1) and B(10, 7). The other two sides both have slope 3, and length 5 cm. (a) (2 points) Provide a very neat and accurate sketch this...

! Required information Problem 14-53 (LO 14-4) (Static) [The following information applies to the questions displayed below.] Jesse Brimhall is single. In 2023, his itemized deductions were $12,000...

Carol is the purchasing manager for J'Divine, a popular wedding photography business. She is responsible for assessing the purchasing and supply activities performed by J'Divine's purchasing and...

How might a neuroscientist use children's interest in video games to design an experimental or longitudinal study determining whether intense amounts of practice in a particular skill causes...

ABA Procedure In this section, name the ABA Procedure being considered. For example, "Differential Reinforcement of Other Behavior (DRO)." Special Methods In this section, discuss the implementation...

Humans, especially children, have an amazing capability to learn language. Within the first year of life, children will have learned many of the necessary concepts to have functional language,...

Martina was geared up for a long day on the bike trail and began her day with a balanced breakfast. Although she brought plenty of water with her, she was also able to stay hydrated because her...

Shepard Industries produced 4,000 tables last month. The standard variable manufacturing overhead (MOH) rate used by the company is $24 per machine hour. Each table requires 0.3 machine hours. Actual...

What are bounds and what do companies do with them?

What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2010?

1. List the name of each publisher thats not located in New York. 2. List the title of each book published by Penguin USA. 3. List the title of each book that has the type MYS. 4. List the title of...

How is it possible to merge a collection of relations that is in third normal form into a cumulative design that is in third normal form but not obtain a collection of relations that is in third...

On a scale of 1 10 (worst best management), how would you rate the management of this interpersonal confrontation? Which conflicting party attempted to be the most productive?

Is it possible that one sex may view a behavior as violent and the other not? What might be some examples where the sexes may differ in their interpretation of a behavior?

Did the parties set a date to return for a follow-up on how well the agreement was working out?