Database Management
数据库管理
This is part of the final project of IST 659 Database Management conducted by Professor Micheal Fudge at Syracuse University. This project is a group project conducted by Beca Qian and Vicky Chou.
Car Rental Database Management
We aim to create a database management platform to manage the details of cars, payment, customers, suppliers, and insurance so that everything is connected, referable, and valid.
-
7 tables: car, user, order, review, payment, maintenance record, insurance
-
Users & Car rental company managers
-
PowerApps layout
Conceptual Data Model: data requirement
Conceptual Model
Logical Model: ERD
PowerApps Layout
User Story
As a consumer:
I can sign in or join this rental platform(create a new account) so that I can start to rent a car..
As a consumer:
I can automatically get the cost of my car rental plan (if I am not a member I won’t get a discount, else, I can get 90% of the order) so that I don’t need to calculate the cost by myself.
As a consumer:
As a customer, I can rate and comment on my previous order so that I can give feedback to the car rental company and their services.
As a car rental company manager:
●I can review the maintenance records of each car so that I can keep an eye on the quality of our cars.
●I can review the insurance history of each car so that I can make sure each car has effective insurance and I can trace the bill amount as well.