MySQL Forums
Forum List  »  MySQL Workbench

Re: Integrating the schema with database
Posted by: Peter Brawley
Date: July 28, 2020 12:00PM

It's unclear what, if anything, you're asking.

You need two sites, one for development, one for production. On the development site ...

1 write a thorough requirements document

2 develop a database schema from those requirements

3 create database from that model

4 populate the db with sample data and with appropriate lookup data

5 write all queries and forms entailed by the requirement, test them all against the populated db, revising & correcting as you go.

When that's all done & debugged on your devel/test site, port the db and app code to the production site for alpha & beta testing. When beta testing is done, remove the sample data & go live.

More info about the db development aspect at https://www.artfulsoftware.com/dbdesignbasics.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Integrating the schema with database
94
July 28, 2020 12:00PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.