Please Use Java for the programming language. Thank you!
Questions: l) Design a relational database schema for a database application of your choice. (45%-break down is below) a) State and describe your requirements, i.e. business rules for the application you choose. You may explore a similar existing system to come up with a list of requirements for your database and its front-end application. You may also use one of the databases you designed in the previous assignments as your starting point. (5%) b) Design and draw your Entity-Relationship Diagrams using MySql Workbench Microsoft Word / yEd / or any other drawing tool of your choice. (5%) Design and declare your relational data model using SQL (10%-break down is below) c) (1) Minimum 3 relations (tables) (2%) (2) Minimum 3 attributes per table (2%) (3) Minimum 10 records per table (6%) d) Normalize your database design to the level of 3NF: Use either a top-down or a bottom-up approach ( 10%) The logical model of your database application should include: (15%-breakdown is below) e) (1) Minimum one INSERT, one DELETE, one UPDATE query (3%) (2) Minimum three SELECT queries (3%) (3) Minimum one JOIN, one GROW BY, one VIEW query (396) (4) Minimum one Trigger (3%) (5) Minimum one Stored Procedure (3%) 2) Implement Develop the physical model of your database application using MySql Workbench. Your MySQL code is the third tier (backend data tier) of your 3-Tier architecture. (25%) 3) The business logic forms the application tier, which is the second tier of your 3-Tier architecture. The application tier takes the information from the presentation tier and queries the data tier (backend). (20%) 4) The first tier of your 3-Tier architecture is the presentation tier which enables the client/user to access the database. This user interface could be a form to fill in, or a field to choose etc. depending on your application and design. (10%) Questions: l) Design a relational database schema for a database application of your choice. (45%-break down is below) a) State and describe your requirements, i.e. business rules for the application you choose. You may explore a similar existing system to come up with a list of requirements for your database and its front-end application. You may also use one of the databases you designed in the previous assignments as your starting point. (5%) b) Design and draw your Entity-Relationship Diagrams using MySql Workbench Microsoft Word / yEd / or any other drawing tool of your choice. (5%) Design and declare your relational data model using SQL (10%-break down is below) c) (1) Minimum 3 relations (tables) (2%) (2) Minimum 3 attributes per table (2%) (3) Minimum 10 records per table (6%) d) Normalize your database design to the level of 3NF: Use either a top-down or a bottom-up approach ( 10%) The logical model of your database application should include: (15%-breakdown is below) e) (1) Minimum one INSERT, one DELETE, one UPDATE query (3%) (2) Minimum three SELECT queries (3%) (3) Minimum one JOIN, one GROW BY, one VIEW query (396) (4) Minimum one Trigger (3%) (5) Minimum one Stored Procedure (3%) 2) Implement Develop the physical model of your database application using MySql Workbench. Your MySQL code is the third tier (backend data tier) of your 3-Tier architecture. (25%) 3) The business logic forms the application tier, which is the second tier of your 3-Tier architecture. The application tier takes the information from the presentation tier and queries the data tier (backend). (20%) 4) The first tier of your 3-Tier architecture is the presentation tier which enables the client/user to access the database. This user interface could be a form to fill in, or a field to choose etc. depending on your application and design. (10%)
