5. Database Design - consisting of two parts. First part provides all entities needed for the system and show relationships among them (using ERDs). Second part, mapping the ERDS to tables with...

5. Database Design - consisting of two parts. First part provides all entities needed for the system and show relationships among them (using ERDs). Second part, mapping the ERDS to tables with appropriate attributes, data types and formatsThis assignment will be undertaken in groups of Three or Four students. Based on the below case study provided, students are required to write a design requirements document for developing (later) a website of the case study. This assignment is aimed at developing a web-based application for a fictious banking website. The system is an online application that can be accessed throughout the organization and outside as well with proper login provided. The directory of the website has been planned to have a simple MVC architecture, with a centralised storage of the database. The user interfaces have to be designed using HTML5 and CSS3 styling when necessary. The middleware can be developed using PHP scripts along with the SQL queries. Following are the functional needs of the system: 1. Customer must have a valid user ID and password to login to the system. (You can have a hardcoded user details to start with in the back end. Also have initial balance to start with zero) 2. After the valid user logs in, the system shows the present balance in that particular account. 3. Customer can perform transactions like deposit and withdrawal from his/her account. There are only three types of account available: Saving Bank Account, Credit Bank Account, and Everyday Bank Account. 4. Transfer of funds to other accounts. 5. Deposit of funds by the client. 6. You need to keep track of all the transactions for future references as this is supposed to be show the customer as a statement. 7. It is required that the system also have another type of user who is an Administrator of the system. 8. Administrator can see, add, edit and remove any customers from the banking list. 9. All the above-mentioned tasks should be interacting with the Database in the backend using SQL queries along with the PHP scrips in the middleware and HTML, HTML5 and CSS for the front end. 10. When a user logs out after depositing funds or transferring funds and then logs in back again, the old transactions along with the updated balance should not be lost.