Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started