Question

You have been tasked to design a database to support your new business. This business could be one of many possibilities such as a car dealership, Internet Sales, Graphic Design, Fitness counselor or anything you can imagine.

Describe the entities and their attributes that might be required for this application, the type of database processing required, and the application software needed.  

Pick something unique for you. Note: this doesn't have to be complex. A few entities and attributes will suffice. Just be sure, the entities make sense for your application.

Describe your business.

Answer 1

Answer:

Business description:

Suppose my new business is '​​​​​​'Computer rental service' , in which there will be two types of customers. One who want to hire PCs, and the other who want to rent-out their PCs.

People can rent-out their PCs to earn rent , by depositing their PCs with my company. My company will then rent-out those PCs to customers who want to hire PCs.

A customer can hire personal compters for a given number of days. The customer have to a rent for using the computer depending on the number of days it is hired, model and configuration of the computer.

In this way my business works as an link between those who want to hire and those who want to rent-out. Earning a small percentage of rent received.

----------------------------------------------------------------------

Entities and their attributes:

1.Entity: Renter

Attributes:

(I) Renter_ID (ii) Renter_Name (III) address (IV) mobile number (v) email_ID

2. Entity: Hirer

Attributes:

(I) Hirer_ID . (ii) Hirer_Name. (III) address (IV) mobile number (v) email_ID

3. Entity: PCs

Attributes:

(I) . PC_ID. (ii) Renter_ID (III) Rate (IV) brand (v) model (vi) ip_address (vii) processor ( memory) (viii) body number

4. Entity: Rent_Transactions

Attributes:

(i) rent_transaction_ID (ii) renter_ID (III) rent_start_date (IV) rent_end_date (v) number_of_days (vi) total_rent_amonut (vii) service_fees (vii) net_amount_paid

5. Entity: Hire_Transactions

Attributes:

(I) hire_transaction_ID. (ii) hirer_ID (III) start_date (iv) end_date (v) number_of_days (vi) rent_charged (vii) service_fees

-------------------------------------------------------------------------

Type of database processes:

Following types of database processes will be done:

1. Create 2. Select 3. Modify 4. Update 5. Delete

Application Software

We can use MS Access if we use a Windows platform or A relational database server (RDBMS) like MySQL to implement the system. In which all the records will be entered manually using an application software as an interface to the RDBMS.

-------------------------------------------------------------------------------

​​​​​​