Database design in MySQL PHP
Budget: $2 – $8 AUD
Your database tables must be created using SQL statements which must be detailed in your
final documentation. You will also supply a supporting .sql file which can be run by the assessor in
order to create the tables in MySQL. You must include all primary and foreign keys as well
as any other table or column constraints you feel are appropriate. Using appropriate sample
data and your own imagination, you will populate your finished tables.
2. Optimize and secure your database
Apply suitable database optimization and query-tuning techniques – such as indexing and
clustering to your final set of tables. Note and explain these in your supporting technical
documentation.
Budget-40AUD
final documentation. You will also supply a supporting .sql file which can be run by the assessor in
order to create the tables in MySQL. You must include all primary and foreign keys as well
as any other table or column constraints you feel are appropriate. Using appropriate sample
data and your own imagination, you will populate your finished tables.
2. Optimize and secure your database
Apply suitable database optimization and query-tuning techniques – such as indexing and
clustering to your final set of tables. Note and explain these in your supporting technical
documentation.
Budget-40AUD