Appointment System
A generic online database appointment system for service companies to provide available times for an appointment and for customers to select the most convenient time available. The database contains three main tables: Appointment, Account, Service and two many-to-many association tables AccountAppointment and ServiceAppointment. Appropriate links to the user- and installation instructions, user stories, database schema and the link to the app in Heroku are made available below.
Links:
Link to database schema diagram
Link to user stories and SQL statements
Login credentials for the app:
| Role | Username | Password |
|---|---|---|
| Employee | employee1 | test |
| Employee | employee2 | test |
| User | user1 | test |
| User | user2 | test |