Question: For each problem, create an ERD to show how you would keep track of the information. Show entity names, primary keys, attributes for each entity,

For each problem, create an ERD to show how you would keep track of the information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality.

2. ERD entitled MyRentals for an equipment rental business:

CUSTOMER -Customer ID -Name -Address -Phone

EQUIPMENT -Equipment ID -Category -Description -Daily Rate

RENTAL -Rental ID -Customer ID -Equipment ID -Rental Date -Return Date

PAYMENT -Payment ID -Rental ID -Amount -Payment Date

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

STORY: Let us suppose that the average weight of all the 5-axle semi-trucks that drive on Florida highways is 75000 lbs, the standard deviation is 3000 lbs, and 47% of them have red tractor units....

For each problem, create an ERD to show how you would keep track of the information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality....

2/3 A manufacturing company produces products and for the products, the following information is stored: product name, product ID and quantity on hand. The products are made up of many components and...

Lab 1 Case Study: Making the grades-ERD Case description: Making The Grade a non-profit organization that helps students learn how to achieve better grades in schools. The organization has 40 offices...

Assignment: ( 1 ) Develop an E - R diagram for the library management system database project ( 2 0 pts ) and ( 2 ) populate all tables with at least 5 records in each table using MySQL ( 1 0 pts ) ....

Manufacturing Process Management A factory wants to manage its manufacturing process in terms of the raw materials used and the products being obtained in manufacturing process. Each raw material...

For the final assignment of this course, you will analyze user needs to facilitate the development of a database using SQL server to track the software and hardware assigned to the employees of a...

Q . Describe the difference between Chen's Model and Crow's Foot Model notations. Q . Create an ERD based on the Crow s Foot model, using the following requirements: Below are the business rules that...

Please answer all 3 questions. Please provide answer in 3 hrs Assignment Specification In this assignment, you need to perform the following tasks for the given case study: 1. Draw an Entity...

14) The following information is for Brooklyn Corporation: Direct Materials (measured in pounds) Standard price per unit of input Actual price per unit of input Standard inputs per unit of output...

The following information relates to Sage Hill Inc. for the year 2017. Retained earnings, January 1, 2017 $50,880 Advertising expense $1,910 Dividends during 2017 5,300 Rent expense 11,020 Service...

Which of the following, if any, correctly describes the earned income credit? a . Would be available regardless of the amount of the taxpayer s adjusted gross income. b . Would be available...

please answer only if you know programming language is c++ For this lab, your objective is to define the functions below. Define the void function SwapNodes () that takes three generic type Node...