Question: Step 1: Create a new database and name it Wedgewood Step 2: Create a New Query to type the SQL Code to Create all the

all the tables (Do not Insert Data) listed in Slide 8 (DO

NOT USE ACCESS) in Chapter 3 PPT Slides (Do not include column

Supervisor in EMPLOYEE). Make sure to use the correct Data Type of

each column based on the Data listed in the tables listed in Chapter 3 PPT Slides 13, 14, 16, and 17. Make sure to Refresh your Tables Folder after creating every Table. Start building Parent tables before Child tables Step 3: Use CONSTRAINTS to create Primary Key and Foreign Key(s) Step 4: Execute the SQL Code (Run Query). The query

Step 1: Create a new database and name it Wedgewood

Step 2: Create a New Query to type the SQL Code to Create all the tables (Do not Insert Data) listed in Slide 8 (DO NOT USE ACCESS) in Chapter 3 PPT Slides (Do not include column Supervisor in EMPLOYEE). Make sure to use the correct Data Type of each column based on the Data listed in the tables listed in Chapter 3 PPT Slides 13, 14, 16, and 17.

Make sure to Refresh your Tables Folder after creating every Table. Start building Parent tables before Child tables

Step 3: Use CONSTRAINTS to create Primary Key and Foreign Key(s)

Step 4: Execute the SQL Code (Run Query). The query must run successfully without any errors.

Step 5: Refresh your Database. Then, show me that the tables were created successfully in the Database (available in the left margin)

Step 6: Create Database Diagram

I MUST USE SQL TO FOLLOW THESE STEPS!!!

\begin{tabular}{|l|} \hline DEPARTMENT \\ \hline BudgetCode OfficeNumber DepartmentPhone \\ \hline \end{tabular} \begin{tabular}{l} EMPLOYEE \\ \hline EmployeeNumber FirstName LastName Department Position Supervisor OfficePhone EmailAddress \\ \hline PROJECT \\ \hline ProjectID ProjectName Maxtmours StartDate EndDate \\ \hline \end{tabular} \begin{tabular}{llll} \hline DepartmentName & BudgetCode & OfficeNumber & DepartmentPhone \\ Administration & BC-100-10 & BLDG01-210 & 3602858100 \\ Legal & BC-200-10 & BLDG01-220 & 3602858200 \\ Human Resources & BC-300-10 & BLDG01-230 & 3602858300 \\ Finance & BC-400-10 & BLDG01-110 & 3602858400 \\ Accounting & BC-500-10 & BLDG01-120 & 3602858405 \\ Sales and Marketing & BC-600-10 & BLDG01-250 & 3602858500 \\ InfoSystems & BC-700-10 & BLDG02-210 & 3602858600 \\ Research and Development & BC-800-10 & BLDG02-250 & 3602858700 \\ Production & BC-900-10 & BLDG02-110 & 3602858800 \end{tabular} siideh \begin{tabular}{llllll} ProjectlD & ProjectName & Department & MaxHours & StartDate & EndDate \\ \hline 1000 & 2019 Q3 Production Plan & Production & 100.00 & 05/10/19 & 06/15/19 \\ 1100 & 2019 Q3 Marketing Plan & Sales and Marketing & 135.00 & 05/10/19 & 06/15/19 \\ 1200 & 2019 Q3 Portfolio Analysis & Finance & 120.00 & 07/05/19 & 07/25/19 \\ 1300 & 2019 Q3 Tax Preparation & Accounting & 145.00 & 08/10/19 & 10/15/19 \\ 1400 & 2019 Q4 Production Plan & Production & 100.00 & 08/10/19 & 09/15/19 \\ 1500 & 2019 Q4 Marketing Plan & Sales and Marketing & 135.00 & 08/10/19 & 09/15/19 \\ 1600 & 2019 Q4 Portfolio Analysis & Finance & 140.00 & 10/05/19 & \end{tabular} slide16 Side 17 \begin{tabular}{|l|} \hline DEPARTMENT \\ \hline BudgetCode OfficeNumber DepartmentPhone \\ \hline \end{tabular} \begin{tabular}{l} EMPLOYEE \\ \hline EmployeeNumber FirstName LastName Department Position Supervisor OfficePhone EmailAddress \\ \hline PROJECT \\ \hline ProjectID ProjectName Maxtmours StartDate EndDate \\ \hline \end{tabular} \begin{tabular}{llll} \hline DepartmentName & BudgetCode & OfficeNumber & DepartmentPhone \\ Administration & BC-100-10 & BLDG01-210 & 3602858100 \\ Legal & BC-200-10 & BLDG01-220 & 3602858200 \\ Human Resources & BC-300-10 & BLDG01-230 & 3602858300 \\ Finance & BC-400-10 & BLDG01-110 & 3602858400 \\ Accounting & BC-500-10 & BLDG01-120 & 3602858405 \\ Sales and Marketing & BC-600-10 & BLDG01-250 & 3602858500 \\ InfoSystems & BC-700-10 & BLDG02-210 & 3602858600 \\ Research and Development & BC-800-10 & BLDG02-250 & 3602858700 \\ Production & BC-900-10 & BLDG02-110 & 3602858800 \end{tabular} siideh \begin{tabular}{llllll} ProjectlD & ProjectName & Department & MaxHours & StartDate & EndDate \\ \hline 1000 & 2019 Q3 Production Plan & Production & 100.00 & 05/10/19 & 06/15/19 \\ 1100 & 2019 Q3 Marketing Plan & Sales and Marketing & 135.00 & 05/10/19 & 06/15/19 \\ 1200 & 2019 Q3 Portfolio Analysis & Finance & 120.00 & 07/05/19 & 07/25/19 \\ 1300 & 2019 Q3 Tax Preparation & Accounting & 145.00 & 08/10/19 & 10/15/19 \\ 1400 & 2019 Q4 Production Plan & Production & 100.00 & 08/10/19 & 09/15/19 \\ 1500 & 2019 Q4 Marketing Plan & Sales and Marketing & 135.00 & 08/10/19 & 09/15/19 \\ 1600 & 2019 Q4 Portfolio Analysis & Finance & 140.00 & 10/05/19 & \end{tabular} slide16 Side 17

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!

Your ZOOM Recording must include your Video (Student Face), and Desktop Recording of your demonstration. When you choose the Desktop Recording through Share Screen, keep the default selection...

Use SQL Server Management Studio (SSMS) Step 1: Create a new database and name it WP_Database Step 2: Create a New Query to type the SQL Code to Create the table in the picture. Make sure to use the...

can someone write the queries on SSMS please create these tables with sql query The demonstration recording must start before you open SSMS. Students must demonstrate every step Use SQL Server...

Use SSMS to complete the following steps: Step 1 : Create a new database and name it Inventory Step 2 : Use SQL CODE to create the Tables listed in the Attached File ( Show me the tables in the left...

Step 1: Create a new database and name it Inventory Step 2: Use SQL CODE to create the Tables listed above \begin{tabular}{|ccccc|} \hline CustomerlD & CustomerFirstName & CustomerLastName &...

Requirements: In order to complete this, you will need to perform the following: Create tables Create key constraints Create check constraints Import data to the table (provided) Ensure bad data...

Queues Objectives Design and write a method to insert items into a queue Design and write a method to remove items from a queue Design and write a method to look at the first and last item on the...

Using netbeans to do this. You will be creating a contacts application to store information about clients for a business. I will give you a GUI project that I developed and you will to provide the...

write a php program code solve the second pic Step 1: Create a new database named PlantStore in MySQL server. Step 2: Import the provided file (plant squl) to the previous database in order to create...

Please explain in detail so I can follow what you did!! thank you! Step 1 Create a new project . Name it Assignment_5_1 . Step 2 Build a solution . Write the Java source code necessary to build a...

The table to the right shows the arrival data for two airlines in five cities. Complete parts (a) through (c) below. Excelsior Airlines Paradise Airlines Percentage Number of on-time 88.2% Percentage...

You have been asked to prepare a Project Proposal for a restaurant, that wishes to extend its current operation by adding a page to its existing website. They wish to set up an online ordering system...

A call option to buy 1 0 , 0 0 0 at a strike price of $ 1 . 8 0 = 1 . 0 0 is equivalent to 2 2 Multiple Choice 3 . 5 points 0 1 : 5 8 : 5 9 #none of the options 3 : 0 1 1 rurNoa put option on 1 0 , 0...

The force constant of a massless spring is 2 5 . 0 N / m . A mass of 0 . 4 5 kg is oscillating in simple harmonic motion at the end of the spring

How would you create an objects and program document using UML?

Describe each of the 12 UML diagrams in your own words.

Explain the three methods described for calculating value at risk.