Question: Exercisel: Create and link tables 1. Open MySQL Workbench- Create a new schema - name it custorders 2. Create two new tables, named Customer and

Exercisel: Create and link tables 1. Open MySQL Workbench- Create a new schema - name it custorders 2. Create two new tables, named Customer and Order, in MYSQL WORKBENCH with the following fields and do not forget to create a pr key for each of the following tables. [Important: Select the appropriate data type and choose constraints appropriately]. a. customer: customer_id, lastname, firstname, address, ci state, post_code, home_phone b. order: order_id, date, amount_due, discount_recd c. Make sure that you create appropriate foreign key column in video colled table in order to create one-to-many relationship between customer and ord table. d. Make sure that CASCADE is selected for both On Update and On Delete options. 3. Enter some data in the customer and order tables. 4. Close your database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Tasks 1 Managing User Privileges a. Create a new user, using 'CREATE USER' with username as your first name, and the password P@ssword. (Use MYSQL Shell or Command Line) b. Write a GRANTstatement...

For problems #1 and #2 create EER diagrams and save them to .mwb files. For problems #3 take the database diagram you created in problem #2 and convert to an sql file. Then take the two .mwb files...

Open MySQL Workbench and access your local database server.Run the below provided mailorder.sql script to define the mailorder database. After verifying that you have created all the tables...

1. Use MySQL Workbench to create an EER model from the script file named create_my_guitar_shop.sql thats in the mgs_ex_starts folder. From the model, create an EER diagram that shows the...

This task has 5 marks. It is about debugging an SQL code containing DDL statements for a collection of related tables. You need to follow ALL STEPS (From Step 1 to Step 10). You need to debug the...

(PLEASE DO NOT COPY AND PASTE ANOTHER ANSWER! the ones I have found do not apply to mine, I fixed those issues already) (Comment reply) I actually only need help with creating an ERD new (see link...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

STEP 1: Create Data Dictionary for provided elements As the DBA for your company, you have decided to install a new version of the MySQL database to replace the current database version being used....

The Review Questions 7.3 to 7.40, from the Kroenke book starting page 357, have been duplicated below, to assist in the completion of this Lab Assignment. RQ Questions 7.1, 7.2 and 7.3 are answered...

* Requirements Specification ( this is a fictional scenario ) A fitness company stores the current assignments of trainers to customers in a document file like this: * Trainer: Jones, William; phone...

Now assume that Citrus Products begins producing the same liter of orange juice in Japan. The product costs 250 yen to produce and ship to Australia, where it can be sold for 6 Australian dollars....

In each of the following equations, state whether y varies directly as x, inversely as x, or neither directly nor inversely as x. (a) 7xy = 14 (b) x - 2y = 12 (c) -2x + 3y = 0 (d) x = 3 / 4 y (e) x /...

Know the accounting equation which is the structure of the Balance Sheet including what makes up Equity

Given the following two finite automata, find out their equivalent regularexpressions.