sql project
Budget: $10 – $30 USD
You will be graded partially at this point on the following deliverable items:
- Design of the database: EER model, create DB script forward engineered from EER model (note that you may not have the complete DB design yet. However it's expected that you should have at least 3 tables with relationships defined)
- Inserting entries to the database (3-5 entries for each table): the insert statements must be in the right sequence to execute correctly
Midway project submission should include the following:
A EER model file (.mwb) that illustrates the database design and tables
A .sql script generated from Forward Engineering tool using EER model
A .sql script that includes insert statements to populate data into each table
- Design of the database: EER model, create DB script forward engineered from EER model (note that you may not have the complete DB design yet. However it's expected that you should have at least 3 tables with relationships defined)
- Inserting entries to the database (3-5 entries for each table): the insert statements must be in the right sequence to execute correctly
Midway project submission should include the following:
A EER model file (.mwb) that illustrates the database design and tables
A .sql script generated from Forward Engineering tool using EER model
A .sql script that includes insert statements to populate data into each table