Posts

Showing posts from September, 2021

Presentation : Database Management : MySQL and phpMyAdmin

 

Database and System Management MySQL

Image
  Provide a MySQL script to recreate the final database you implemented in the previous tasks. ·          The script should recreate all the tables, constraints, views, and triggers you have implemented. Name the SQL script “CreateDB.sql” Provide a MySQL script to add several rows to each of the tables you created. ·          Do your best to use data and formatting that mimics what is used in a real online ordering system (i.e., emails, first name, last name, credit card information, etc.). Name the SQL script “PopulateData.sql”