This database project is focused on the development of a Bike-Sharing Management System. This system will provide an efficient platform for users to access and utilize shared bicycles, streamlining the process of bike rentals and management for the service provider. The system will support the following key elements:
- User Registration and Membership Management
- Bike Inventory and Rental Management
- Maintenance Tracking and Bike Status Updates
- Art Bike Information
This project includes the following activities:
- Conceptual model development (in ERDPlus)
- Relational schema design
- Creating a database in PostrgeSQL
- Filling the database with test data
- Writing several relevant queries and functions
- Creating views
Entity relationship diagram
Relational schema
Database diagram
