Create and populate a mysql database based on the erd

Assignment Help Accounting Basics
Reference no: EM13918247

PROJECT OVERVIEW:
Scenario and Summary

In this assignment, you will create and populate a MySQL database based on the ERD you created in task2. Update the ERD you submitted for task2 with the corrections required by your instructor. To help you with this task, your instructor will provide you with the data dictionary of the database. This will provide you information on every table that you must create for the ABC Company database. Every entity can be found listed in the data dictionary along with the PK/FK information as well as the data types for the attributes. These data types are MySQL data types so they can go directly in the create table statements. Using the corrected ERD and the data dictionary provided, write the necessary MySQL statements to create the ABC company database. To complete this assignment, you will need to be able to run MySQL via Omnymbus.

Deliverables

1. Corrected ERD based on the instructor feedback and data dictionary. The data dictionary titled COURSE PROJECT Week6Task3DataDictonary.xlsx can be found in the folder titled Course Project Documents. Save your file as Lastname_Task3_revisedERD.vsd.
2. Script file as Lastname_task3.sql which includes all the drop, create, alter, and insert statements needed to create the ABC Company database.
3. Word document showing the run result of the script file saved as Lastname_task3Result.docx.
4. When you are done, upload a zip file containing the three files to the Week 6: Course Project Week 6 Task 3 Dropbox.

STEP 1

Revise the ERD you submitted for the previous task with the feedback provided by your instructor and the help of the given data dictionary document.

STEP 2
• Create a file with the name Lastname_Task3.sql
• In your sql file, to drop the tables in case you run the script repeatedly, please include the following at the top of your script:
o SET FOREIGN_KEY_CHECKS=0;
o DROP TABLE IF EXISTS Inventory CASCADE;
o DROP TABLE IF EXISTS line_item CASCADE ;
o DROP TABLE IF EXISTS product CASCADE;
o DROP TABLE IF EXISTS orders CASCADE;
o DROP TABLE IF EXISTS store CASCADE;
o DROP TABLE IF EXISTS employee CASCADE;
o DROP TABLE IF EXISTS department CASCADE;
o DROP TABLE IF EXISTS Warehouse CASCADE;
o DROP TABLE IF EXISTS region CASCADE;
o SET FOREIGN_KEY_CHECKS=1;
• In your sql file, write create table statements for each table in the database. You can try to create each table one at a time and then test the creation of the table before going on to creating the next table. Use the data types given in the data dictionary. Make sure every table has primary key(s), foreign keys if required, and not nulls if required. (Refer to data dictionary for this information)
• Save the file with the name Lastname_Task3.sql.
• Login to your MySQL account via Omnymbus as specified in the tutorial Login MySQL Omnymbus Environment.docx noted at the bottom of this document
• Create a database following the proper naming convention as specified in the tutorial Creating a Database in MySQL Omnymbus Environment.docx noted at the end of this document.
• Click on the database name you just created.
• Run the script file as specified in the tutorial Running SQL Scripts in MySQL Omnymbus Environment.docx noted at the end of this document. If there are no errors, all tables will be successfully created. You may check them by adding SHOW TABLES at the end of your script file.
• If you have errors, correct those errors and execute the script again until it is error free.
STEP 3
Adding data to your database.
• In your SQL Script, write insert statements to successfully insert data into each table.
• A minimum of 3 rows are required for each table.
• In your SQL Script, check the data in each table by running a SELECT * FROM table query.
• Run your SQL Script to test it.
• When you are satisfied with you're the output of your SQL Script, copy the output to a Word File.
Rubrics

Points for will be awarded according to the following rubrics.
• Visio drawing: Revised E-R model provided as a Visio diagram.
• CREATE STATEMENTS: Successfully creating all tables.
• PRIMARY KEYS: Correct primary keys created for all tables.
• FOREIGN KEYS: All required foreign keys created.
• ALTER STATEMENT: Any alter statements required.
• INSERT STATEMENTS: Minimum three rows per table found.

Reference no: EM13918247

Questions Cloud

Maximizing revenue-market structures : From the scenario, assuming Katrina's Candies is operating in the monopolistically competitive market structure and faces the following weekly demand and short-run cost functions:
Evaluate the pros and cons of various action alternatives : Make use of the appropriate core concepts and analytical tools in Strategic Management to thoroughly describe the ins and outs of the company's situation.
Prepare the matrix of transition probabilities : Prepare the matrix of transition probabilities. Compute the steady-state probabilities. What population changes do your steady-state probabilities project for this metropolitan area?
Ensure that all pertinent issues are explored and examined : What do you think if an organization can possibly use diagnostic means and techniques to test problems and look at current or potential future problems that an organization faces or is likely to face?
Create and populate a mysql database based on the erd : In this assignment, you will create and populate a MySQL database based on the ERD you created in task2. Update the ERD you submitted for task2 with the corrections required by your instructor. To help you with this task, your instructor will prov..
Standard deviation for the number of guinness : What is the mean number of Guinness caps he should see in eight trials? What is the standard deviation for the number of Guinness caps appearing in eight trials?
Develop a combined disc chart : Develop a combined DiSC chart of your Learning Team members for use in developing this paper. Based on the individual assessments, what are the characteristics of your team?
Dispute the interpretation of an ambiguous phrase : Fresh Produce, Inc., and Great Grocery Stores dispute the interpretation of an ambiguous phrase in their contract. In a suit between the parties to construe the contract, a court may accept evidence of:
Frequency of local oscillator-frequency received station : If an FM receiver is tuned to receive a carrier frequency of 95.1 MHz and uses high-side injection, what would be the frequency of local oscillator ?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd