computer science

profileMERTON BRUCE

 

due tonight

 

After normalizing your tables designed from Week Three, this week you must create database and construct tables and submitted your DDL scripts.Using the MySQL Workbench, or MariaDB™ 's HeidiSQL , to construct the tables in MySQL or MariaDB™ from the logical database design from your normalized ERD.Populate each table with at least ten data records that would support the user's functional requirements.Each table must have primary key attribute. Execute queries that you use to create database, tables and their related attributes.Write a 175- to 350-word Status Update for your Learning Team using Microsoft® Word describing the work you have completed this week. The Status Update is a simple Microsoft® Word document that lets the instructor know what the team has accomplished during the week.Complete work on your Learning Team Database.Compress the output of the queries including all of the scripts to create the database tables, to establish keys and constraints, to populate data within the database, and queries into a single ZIP folder.Submit your ZIP folder to the Assignment Files tab.

  • 7 years ago
  • 10
Answer(0)
Bids(0)