- A Web App front end for the Sakila database
- The database models the data associated with a film rental business
- The Web App will provide data for 3 levels of user:
- Visitor: Will be able to see all information about films and actors (anyone who accesses the Web App with no credentials)
- Browsing for films and actors made easier
- Able to search by a specific film title, actor first/last name or film category
- Customer: Will be able to see their own account information including which films they have rented
- Allows for personalised experience for each customer
- Able to rent a specific film
- Owner: Has all levels of access and can write to the database. Can see all customer information and films that have been taken out
- Allows for organised control when it comes to owners
- Able to update the information of a specific film
- Able to delete a specific film
- Visitor: Will be able to see all information about films and actors (anyone who accesses the Web App with no credentials)
- Spring Boot
- As a Java-based framework
- Thymeleaf
- As a Java-based templating engine
- My SQL
- As a database
- JUnit
- Including Mock testing
- Scrum Framework within Agile
- The entire project was built in less than 3 days as means of learning how to prioritise requirements in an agile environments
- Altering a database was the main struggle we faced with due to numerous primary-foreign key relationships between tables
- Once the application is started, the first page any user will see is the Landing Page that welcomes the user. User can choose further action from the navigation bar at the top of the screen.
- Should a user choose to search all the available films, they would be directed to the page below. They can search for the film by the film title.
- User has the option to view film details by clickin on the hyperlinked film title. They will be redirected to the following page. It is important to note the user will be asked to log in should they choose to click on the
Rent Filmbutton.
- User can also choose to search for actors using their first name, last name or both. It should be noted that by clicking on the actor ID, user will be displayed with all the films the selected actor appears in.
- By selecting the
Loginbutton in the navigation bar, the user will be prompted for their credentials. They will only be logged in if the credentials are valid.
- If the credentials entered correspond to a customer, they will be recognised as a customer and then redirected to the customer page where they will be able to view their information including the films they have rented in the past.
- If the credentials entered correspond to an owner's crednetials, they will be recognised as an owner and then redirected to the owner page where they will be able to view their information, perform admin actions as well as have an insight in the current count of customers and available films.
- Should an owner want to take a closer look at the films the business offers, they can choose to select
View All Filmsand they will be redirected to the following page. In addition to being able to browse for a specific film, they can view all the details for the selected film including the number of currently availble copies. They will also be able to performseditordeleteactions by selcting the corresponding option onActioncolumn.
- Should an owner want to take a closer look at the current customers of the business, they can choose to select
View All Customersand they will be redirected to the following page. In addition to being able to browse for a specific customer, they will also be able to view their rental history by selectingDetailoption in theHistorycolumn.
- Whenever the user chooses to sign out, all they have to do is navigate back to their profile page by selecting the
Customer PageorOwner Pagebutton (depending on their access level) in the top righ corner and then select theSign Outbutton that can be found just above their user information.
- Allow user to type the input, instead of filtering it
- Allow search for films by language
- Allow for changes in the inventory to be made to reflect the most up to date rental status
- Add film/customer functionality
- Edit/delete customer functionality
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent