Explain life cycle of database management system?

are you talking about you start by finding a need or a problem (like modification errors when adding or deleting, modifying information) for a company? (eg. payroll or inventory)
You have to make an ER model (entity-relationship model) to show the process of the system and make sure that the main entity is fulfilling the need of the user.
The relationships between each table depend on whether the tables rely on each other or whether they exist independent of other tables. You also must consider business rules and referential integrity. The business rules would be how the system is used in relation to the business and referential integrity is where the tables connect to each other. It means that any foreign key information must exist in its related table.
Then you transfer the information found into access or mysql. you do this through structure query language. You will have to look up all the processes for that on the internet.

After it is in you you will have to look up a way to put it online or to make it easy for the user with a switchboard.

First answer by ID1136750185. Last edit by ID1136750185. Question popularity: 1 [recommend question]