All data is case sensitive. Be sure to insert the data in the order provided so...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
All data is case sensitive. Be sure to insert the data in the order provided so all ID's match expectations. Table: AlphaDepartment AlphaDepartment Data First Name Last Name John Jane Table: BravoEmployee Note: This is relational data, instead of Department, the table is using the Department's ID, the column name is AlphaDepartmentID. You can perform the Insert in development mode and run a SELECT on AlphaDepartment to confirm ID. BravoEmployee Data Bob Smith Department Name Doe Sales Marketing Finance Email jsmith@gmail.com Sales jane@gmail.com Marketing Finance Johnson jbob@gmail.com Department Hire Date Annual Salary 3/1/2022 75,000.00 5/5/2022 80,500.00 7/11/2022 70,000.00 Table: Delta Task Note: This is relational data, instead of Project, the table is using the Project's ID, the column name is CharlieProjectID. You can perform the Insert in development mode and run a SELECT on CharlieProject to confirm ID. Same goes for Employee, the table is using the Employee's ID, the column name is BravoEmployeelD. You can perform the Insert in development mode and run a SELECT on BravoEmployee to confirm ID. Delta TaskData Task Name Sales Report Social Media Budget Review ● Project Sales Strategy Task Description Employee Generate sales report for Q1 John Plan and execute social media campaign Marketing Campaign Jane Review budget for Q3 Budget Planning Bob Notes: Your SQL code does not display any results in Develop mode unless you use SELECT statements to return data from the tables;. ie. For a table named Test, you would use SELECT * FROM Test. Make sure that you are not outputting any data when you submit! TIP: You will need to translate the Foreign Keys from their name to their respective IDs. Schema Reference Table: AlphaDepartment • AlphaDepartmentID - integer with range 0 to 65 thousand, auto increment, primary key DepartmentName - variable-length string with max 64 chars, not NULL Table: BravoEmployee BravoEmployeeID - integer with range 0 to 65 thousand, auto increment, primary key FirstName - variable-length string with max 64 chars, not NULL • LastName - variable-length string with max 64 chars, not NULL Email - variable-length string with max 64 chars AlphaDepartmentID - integer with range 0 to 65 thousand, not NULL • HireDate - date, must be 2 Jan 1, 2022 AnnualSalary - number with 7 significant digits and 2 decimal place, must be ≥ 0.00 and ≤ 1000000.00 Table: CharlieProject • Charlie ProjectID - integer with range 0 to 65 thousand, auto increment, primary key ProjectName - variable-length string with max 32 chars, not NULL AlphaDepartmentID - integer with range 0 to 65 thousand, not NULL • DueDate - date, must bez Jan 1, 2023 Table: Delta Task ● ● ● ● • Delta TaskID - integer with range 0 to 65 thousand, auto increment, primary key • TaskName - variable-length string with max 32 chars, not NULL • TaskDescription - variable-length string with max 256 chars Charlie ProjectID - integer with range 0 to 65 thousand, not NULL BravoEmployeeID - integer with range 0 to 65 thousand, not NULL ● All data is case sensitive. Be sure to insert the data in the order provided so all ID's match expectations. Table: AlphaDepartment AlphaDepartment Data First Name Last Name John Jane Table: BravoEmployee Note: This is relational data, instead of Department, the table is using the Department's ID, the column name is AlphaDepartmentID. You can perform the Insert in development mode and run a SELECT on AlphaDepartment to confirm ID. BravoEmployee Data Bob Smith Department Name Doe Sales Marketing Finance Email jsmith@gmail.com Sales jane@gmail.com Marketing Finance Johnson jbob@gmail.com Department Hire Date Annual Salary 3/1/2022 75,000.00 5/5/2022 80,500.00 7/11/2022 70,000.00 Table: Delta Task Note: This is relational data, instead of Project, the table is using the Project's ID, the column name is CharlieProjectID. You can perform the Insert in development mode and run a SELECT on CharlieProject to confirm ID. Same goes for Employee, the table is using the Employee's ID, the column name is BravoEmployeelD. You can perform the Insert in development mode and run a SELECT on BravoEmployee to confirm ID. Delta TaskData Task Name Sales Report Social Media Budget Review ● Project Sales Strategy Task Description Employee Generate sales report for Q1 John Plan and execute social media campaign Marketing Campaign Jane Review budget for Q3 Budget Planning Bob Notes: Your SQL code does not display any results in Develop mode unless you use SELECT statements to return data from the tables;. ie. For a table named Test, you would use SELECT * FROM Test. Make sure that you are not outputting any data when you submit! TIP: You will need to translate the Foreign Keys from their name to their respective IDs. Schema Reference Table: AlphaDepartment • AlphaDepartmentID - integer with range 0 to 65 thousand, auto increment, primary key DepartmentName - variable-length string with max 64 chars, not NULL Table: BravoEmployee BravoEmployeeID - integer with range 0 to 65 thousand, auto increment, primary key FirstName - variable-length string with max 64 chars, not NULL • LastName - variable-length string with max 64 chars, not NULL Email - variable-length string with max 64 chars AlphaDepartmentID - integer with range 0 to 65 thousand, not NULL • HireDate - date, must be 2 Jan 1, 2022 AnnualSalary - number with 7 significant digits and 2 decimal place, must be ≥ 0.00 and ≤ 1000000.00 Table: CharlieProject • Charlie ProjectID - integer with range 0 to 65 thousand, auto increment, primary key ProjectName - variable-length string with max 32 chars, not NULL AlphaDepartmentID - integer with range 0 to 65 thousand, not NULL • DueDate - date, must be 2 Jan 1, 2023 Table: Delta Task ● ● ● ● • Delta TaskID - integer with range 0 to 65 thousand, auto increment, primary key • TaskName - variable-length string with max 32 chars, not NULL • TaskDescription - variable-length string with max 256 chars Charlie ProjectID - integer with range 0 to 65 thousand, not NULL BravoEmployeeID - integer with range 0 to 65 thousand, not NULL ● All data is case sensitive. Be sure to insert the data in the order provided so all ID's match expectations. Table: AlphaDepartment AlphaDepartment Data First Name Last Name John Jane Table: BravoEmployee Note: This is relational data, instead of Department, the table is using the Department's ID, the column name is AlphaDepartmentID. You can perform the Insert in development mode and run a SELECT on AlphaDepartment to confirm ID. BravoEmployee Data Bob Smith Department Name Doe Sales Marketing Finance Email jsmith@gmail.com Sales jane@gmail.com Marketing Finance Johnson jbob@gmail.com Department Hire Date Annual Salary 3/1/2022 75,000.00 5/5/2022 80,500.00 7/11/2022 70,000.00 Table: Delta Task Note: This is relational data, instead of Project, the table is using the Project's ID, the column name is CharlieProjectID. You can perform the Insert in development mode and run a SELECT on CharlieProject to confirm ID. Same goes for Employee, the table is using the Employee's ID, the column name is BravoEmployeelD. You can perform the Insert in development mode and run a SELECT on BravoEmployee to confirm ID. Delta TaskData Task Name Sales Report Social Media Budget Review ● Project Sales Strategy Task Description Employee Generate sales report for Q1 John Plan and execute social media campaign Marketing Campaign Jane Review budget for Q3 Budget Planning Bob Notes: Your SQL code does not display any results in Develop mode unless you use SELECT statements to return data from the tables;. ie. For a table named Test, you would use SELECT * FROM Test. Make sure that you are not outputting any data when you submit! TIP: You will need to translate the Foreign Keys from their name to their respective IDs. Schema Reference Table: AlphaDepartment • AlphaDepartmentID - integer with range 0 to 65 thousand, auto increment, primary key DepartmentName - variable-length string with max 64 chars, not NULL Table: BravoEmployee BravoEmployeeID - integer with range 0 to 65 thousand, auto increment, primary key FirstName - variable-length string with max 64 chars, not NULL • LastName - variable-length string with max 64 chars, not NULL Email - variable-length string with max 64 chars AlphaDepartmentID - integer with range 0 to 65 thousand, not NULL • HireDate - date, must be 2 Jan 1, 2022 AnnualSalary - number with 7 significant digits and 2 decimal place, must be ≥ 0.00 and ≤ 1000000.00 Table: CharlieProject • Charlie ProjectID - integer with range 0 to 65 thousand, auto increment, primary key ProjectName - variable-length string with max 32 chars, not NULL AlphaDepartmentID - integer with range 0 to 65 thousand, not NULL • DueDate - date, must bez Jan 1, 2023 Table: Delta Task ● ● ● ● • Delta TaskID - integer with range 0 to 65 thousand, auto increment, primary key • TaskName - variable-length string with max 32 chars, not NULL • TaskDescription - variable-length string with max 256 chars Charlie ProjectID - integer with range 0 to 65 thousand, not NULL BravoEmployeeID - integer with range 0 to 65 thousand, not NULL ● All data is case sensitive. Be sure to insert the data in the order provided so all ID's match expectations. Table: AlphaDepartment AlphaDepartment Data First Name Last Name John Jane Table: BravoEmployee Note: This is relational data, instead of Department, the table is using the Department's ID, the column name is AlphaDepartmentID. You can perform the Insert in development mode and run a SELECT on AlphaDepartment to confirm ID. BravoEmployee Data Bob Smith Department Name Doe Sales Marketing Finance Email jsmith@gmail.com Sales jane@gmail.com Marketing Finance Johnson jbob@gmail.com Department Hire Date Annual Salary 3/1/2022 75,000.00 5/5/2022 80,500.00 7/11/2022 70,000.00 Table: Delta Task Note: This is relational data, instead of Project, the table is using the Project's ID, the column name is CharlieProjectID. You can perform the Insert in development mode and run a SELECT on CharlieProject to confirm ID. Same goes for Employee, the table is using the Employee's ID, the column name is BravoEmployeelD. You can perform the Insert in development mode and run a SELECT on BravoEmployee to confirm ID. Delta TaskData Task Name Sales Report Social Media Budget Review ● Project Sales Strategy Task Description Employee Generate sales report for Q1 John Plan and execute social media campaign Marketing Campaign Jane Review budget for Q3 Budget Planning Bob Notes: Your SQL code does not display any results in Develop mode unless you use SELECT statements to return data from the tables;. ie. For a table named Test, you would use SELECT * FROM Test. Make sure that you are not outputting any data when you submit! TIP: You will need to translate the Foreign Keys from their name to their respective IDs. Schema Reference Table: AlphaDepartment • AlphaDepartmentID - integer with range 0 to 65 thousand, auto increment, primary key DepartmentName - variable-length string with max 64 chars, not NULL Table: BravoEmployee BravoEmployeeID - integer with range 0 to 65 thousand, auto increment, primary key FirstName - variable-length string with max 64 chars, not NULL • LastName - variable-length string with max 64 chars, not NULL Email - variable-length string with max 64 chars AlphaDepartmentID - integer with range 0 to 65 thousand, not NULL • HireDate - date, must be 2 Jan 1, 2022 AnnualSalary - number with 7 significant digits and 2 decimal place, must be ≥ 0.00 and ≤ 1000000.00 Table: CharlieProject • Charlie ProjectID - integer with range 0 to 65 thousand, auto increment, primary key ProjectName - variable-length string with max 32 chars, not NULL AlphaDepartmentID - integer with range 0 to 65 thousand, not NULL • DueDate - date, must be 2 Jan 1, 2023 Table: Delta Task ● ● ● ● • Delta TaskID - integer with range 0 to 65 thousand, auto increment, primary key • TaskName - variable-length string with max 32 chars, not NULL • TaskDescription - variable-length string with max 256 chars Charlie ProjectID - integer with range 0 to 65 thousand, not NULL BravoEmployeeID - integer with range 0 to 65 thousand, not NULL ●
Expert Answer:
Answer rating: 100% (QA)
You have provided images showing a task related to inserting data into database tables ensuring foreign key relationships are respected and that the d... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
On Earth you weigh 6 0 0 N . On another planet your weight ( the gravity force from the planet exerts on you ) is 4 0 0 N . If the mass of the planet is 4 . 0 0 * 1 0 2 4 kg , , what is its radius?
-
A beam of electrons is incident on a set of slits (it doesn't matter exactly how they're set up) and then on a screen. We denote the position on the screen by x. Suppose that for 4nm < x < 8nm, the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Factors that affect the selection of an inventory costing method do not include: (a) tax effects. (b) balance sheet effects. (c) income statement effects. (d) perpetual vs. periodic inventory system.
-
A metal wire of resistance R is cut into three equal pieces that are then connected side by side to form a new wire the length of which is equal to one-third the original length. What is the...
-
A 91-kg man's thighbone has a relaxed length of 0.50 m, a cross-sectional area of 7.0 104 m2, and a Young's modulus of 1.1 1010 N/m2 . By how much does the thighbone compress when the man is...
-
A list of the typical attributes of creams and pastes is given in Example 1.2. Identify two sunscreen lotion products from two different companies. Compare them based on the four product attributes...
-
1. Construct and interpret a control chart for the packing slip data. 2. Conduct a Pareto analysis of the errors. 3. What information might a separate chart for each error category provide? Conduct a...
-
A block of mass =309 g is dragged with a string across a rough horizontal table. The string tension is =2.47 N, and it pulls upward at an angle of =46.0 with the horizontal. At one particular...
-
Sandra?s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Required: 1. Calculate ending inventory and cost of goods sold at October 31,...
-
Take y = f (x, y), y(0) = 0, where f (x, y) > 1 for all x and y. If the solution exists for all x, can you say what happens to y(x) as x goes to positive infinity? Explain.
-
Costington's Case Group Assignment: Prepare a three-year forecast based on Costington's actual financial statements (Exhibit 10). Note this requires that you create an entirely new spreadsheet model...
-
1. Prepare a flexible budget performance report for 2019. (Indicate the effect of each variance by selecti unfavorable, and No variance.) Variable costs Fixed costs PHOENIX COMPANY Flexible Budget...
-
Air Scrubbers A local paper manufacturing plant emits nitrogen oxide into the air and has decided to install air scrubbers to reduce the amount of pollution. Each scrubber costs $250,000 and the...
-
Facial recognition technology can identify _________points on a persons face. Group of answer choices 29,000 16,000 4,000 54,000
-
write two paragraphs Project Guide Economics: Students must conduct research as to how the corona virus impact the economy in various areas. The economy had either positive or negative effect which...
-
The room should be maintained at 24C bulbs dry and 50% relative humidity. The sensitive room heat gain is 2.3 kW and the latent room heat gain is 0.4 kW. a) Draw the room ratio line on the...
-
Teasdale Inc. manufactures and sells commercial and residential security equipment. The comparative unclassified balance sheets for December 31, 2015 and 2014 are provided below. Selected missing...
-
Create a new Coast Jewelers' Present Value Analysis a. Using the ch7-01 file to start your work, modify that worksheet to do the following: i. Calculate the annuity payment required at the end of...
-
Create additional select queries for Coast Jewelers using comparison operators. a. Create and print a select query for Coast Jewelers that lists the product name, unit price, supplier name, and...
-
Add, change, and delete records to the Coast Jewelers database (use the Chi0-02 file) a. Add the following record to the Buyers table: ID 4, Farley, 555-7187. b. Add Bracelets as a category to the...
-
Enthalpy of superheated steam is given by (a) \(h_{g}+c_{p s} \ln \frac{\mathrm{T}_{\text {sup }}}{\mathrm{T}_{s}}\) (b) \(h_{f}+h_{f g}\) (c) \(s_{g}+x s_{f g}\) (d) \(x s_{f}\)
-
What do you understand by the term priming ?
-
Determine the change in internal energy when one \(\mathrm{kg}\) of steam expands from \(10 \mathrm{bar} 300^{\circ} \mathrm{C}\) to 0.5 bar and 0.9 dry. Take \(c_{p s}=2.1 \mathrm{~kJ} /...
Study smarter with the SolutionInn App