CASE: CREATING A DATABASE MANAGEMENT SYSTEM (DUE MAR. 1 5PM)

THE ISSUE

FLORENCE BIKE RENTALS NEEDS HELP MANAGING ITS RENTAL BUSINESS. YOU ARE ASKED TO CREATE A DATABASE TO HELP THE OWNERS KEEP TRACK OF THE BIKE RENTALS, WHO THE CUSTOMERS ARE, AMOUNT PAID, AND AY DAMAGE TO THE BIKES WHEN THEY ARE RENTED. CURRENTLY FLORENCE BIKE RENTALS OWNS 13 MOUNTAIN BIKES IN THEIR FLEET OFF RENTALS. THE BIKES VARY IN TYPE, SIZE, AND PARTS. WHEN CUSTOMERS RENT BIKES, THEY ARE REQUIRED TO LEAVE THEIR RIVER'S LICENCE AND GIVE YOU THEIR HOME ADDRESS, PHONE, AND A CREDIT CARD NUMBER.

THE TECHNOLOGY

THE DBMS SOFTWARE OF YOUR CHOICE (MICROSOFT ACCESS)

AVAILABLE INFORMATION

A LIST OF INTEGRITY CONSTRAINTS (BUSINESS RULES):

RENTALS CAN HAVE MANY CUSTOMERS ASSIGNED BUT MUST HAVE AT LEAST ONE

A BIKE MUST BE ASSIGNED TO ONE AND ONLY ONE RENTAL TYPE

A CUSTOMER CAN RENT ONE OR MORE BIKES AT ONE TIME

A BIKE CAN BE ASSIGNED TO ONLY ONE CUSTOMER BUT NEED NOT TO BE ASSIGNED TO ANY CUSTOMER

YOUR INDIVIDUAL PROJECT IS TO BE COMPLETED FOLLOWING PHASES:

1. USE ERD FOR FLORENCE BIKE BASE

2.CREATE A PHYSICAL DATABASE SYSTEM USING A PERSONAL DBMS PACKAGE (MICROSOFT ACCESS)

DELIVERABLES:

-E-R DIAGRAM (SHOW BOTH MAX. AND MI. CARDINALITIES)

-ASSURE THAT YOU HAVE CREATED TABLES, PERFORMED COUPLE OF QBE EXAMPLES, RELATIONSHIPS (ADD SYMBOLS), AN EXAMPLE OF 'REPORT', AND AN EXAMPLE OF 'FORM'.

-SUBMIT SCREENSHOTS IN WORD FILE