Description
There are 5 very small assignments in the pdf that require basic knowledge of C++. Sum of 2 numbers. Revenue Predictions and 3 others. I need each of these sections completed in separate files.
Unformatted Attachment Preview
LAB – Identifiers and Output
a) Sum of two numbers: Write a program that stores the integers 234
and 516 in variables, and stores the sum of these two in a
variable named result. Display your output in equation form.
b) Revenue Prediction: The Online Retail division of Amazon
generates 73% of total sales for the company. Based on that
percentage, write a program that will predict how much revenue
the retail division will generate if the Amazon reports $340.5
million in revenue for the year.
Display your output in the format below:
Amazon’s Total Revenue: $[totalRevenue]M
Online Retail % of Total Revenue: [percentOfTotalRevenue]%
Online Retail’s Revenue: $[onlineRetailRevenue]M
c) Sales Tax: Write a program that will compute the total sales tax
on a purchase of $179.89. Assume the state sales tax is 8% and
the county sales tax is 3%.
Display your output in the format below:
Purchase Price:
State Tax %:
State Tax Amount:
County Tax %:
County Tax Amount:
Total Tax Owed:
$[purchasePrice]
[state_tax_percent]%
$[stateTaxAmt]
[county_tax_percent]%
$[countyTaxAmt]
$[totalTax]
Identifiers and Output
d) Restaurant Bill: Write a program that computes the tax and tip
on a restaurant bill for a patron with a $159.81 meal charge.
The tax should %8 of the meal cost. The tip should be 20% of
the total after adding the tax.
Display your output in the format below:
================================================================
Meal Receipt
================================================================
Meal Cost:
Tax Amount:
Tip Amount:
Total Bill:
$[mealCost]
$[taxAmt]
$[tipAmt]
$[totalBill]
================================================================
e) Average of Values: Write a program that stores the following
values in five different variables, 34, 61.5, 91.8, 73, and 102.
It also stores the value 5 in a constant named TOTAL_NUM_VALUES.
The program should first calculate the sum of the five variables
and store the result in a variable named sum. Then the program
should divide the sum variable by the TOTAL_NUM_VALUES constant
to get the average. Store the average in a variable named avg.
Display your output in the format below:
The sum of the five numbers is: [sum]
The average of the five numbers is: [avg]
Identifiers and Output
f) Annual Pay: Suppose an employee gets paid every two weeks and
earns $2580.00 each pay period. In a year the employee gets
paid 26 times. Write a program that defines the following
variables:
payAmount – This variable will hold the amount of pay the
employee earns each pay period.
payPeriods – This variable will hold the number of pay periods
in a year.
annualPay – This variable will hold the employee’s total annual
pay, which will be calculated.
The program should calculate the employee’s total annual pay by
multiplying the employee’s pay amount by the number of pay
periods in a year, and store the result in the annual pay
variable.
Display your output in the format below:
================================================================
Employee’s Annual Paystub
================================================================
Amount Earned per Pay Period: $[payAmount]
Total Number of Pay Periods: [payPeriods]
Employee’s Annual Pay: $[annualPay]
================================================================
Identifiers and Output
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Actually, I finished. Pl...
Completion Status:
100%
Review
Review
Anonymous
Nice! Really impressed with the quality.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Columbus State Community College SQL Statement Programming Quiz 10
QUESTION 1What is true with respect to a row’s primary key? Select ALL answers that apply.A.The primary key should conta ...
Columbus State Community College SQL Statement Programming Quiz 10
QUESTION 1What is true with respect to a row’s primary key? Select ALL answers that apply.A.The primary key should contain a value that should never change; the value should be immutable.B.The primary key must not contain the value null.C.The primary key uniquely identifies each row in a table.D.The primary key of one table is used only to create a relationship to a different table’s primary key.2 points QUESTION 2In the drawing shown below, what kind of relationship exists between the Customers table and the Titles table? Select the best answer from the following. A.One-To-One relationship.B.One-To-Many relationship.C.Many-To-Many relationship using the StreamingHistory table as a composite entity.D.There is no relationship between the Customers and the Titles tables.2 points QUESTION 3In the drawing shown below, what kind of relationship exists between the Empoyee table and the EmployeePayHistory table? Select the best answer from the following. A.One-To-One relationship.B.One-To-Many relationship.C.Many-To-Many relationship.D.From the diagram given you cannot tell if there are any relationships between these two tables.2 points QUESTION 4Referencing the table below, what can you say about the following T-SQL Delete statement? Select the best answer from the following. A.This statement will not run because it is incomplete.B.This statement will not run because it is invalid due to invalid syntax.C.This statement will delete all the rows from the Movies table.D.This statement will delete the Movies table—remove the table from the database.2 points QUESTION 5In cloud architecture, which of the following is an example of SaaS? Select the best answer from the following.A.A database is hosted in a data center and is provided to the customer as a service. You have no control over the infrastructure, server, operating system, etc. You control only database itself.B.A database is installed on a virtual machine that resides in the cloud infrastructure. You have control over the operating system, but not to the physical hardware.C.A database is installed in an on-premise infrastructure. You have complete control over the infrastructure, hardware, operating system, etc.D.A database cannot be provisioned in a Software as a Service environment.2 points QUESTION 6Referencing the table below, what can you say about the following T-SQL Insert statement? Note that the Id column is an identity specification. Select the best answer from the following. A.This insert statement will insert exactly one row into the Movies table.B.This insert statement will fail because the Id column is not included in the list of columns.C.This insert statement will fail because neither the RottenTomatoesScore nor the TotalEarned columns are included in the list of columns.D.This insert statement will fail because the syntax is wrong.2 points QUESTION 7The ‘T’ in T-SQL stands for, what? Select the best answer from the following. A.TransactB.TypedC.Trans NotationalD.Translated2 points QUESTION 8What is an “attribute”? Select the best answer from the following.A.An attribute is the same, or synonymous with, a column in a table.B.An attribute, for our purposes, is the same as a table in the database.C.There are no attributes in a relational database. Attributes are only part of NoSQL databases.D.An attribute provides the meta-data about the entire database.2 points QUESTION 9Which of the following is NOT a tool used in conducting needs assessments? Select the best answer from the following.A.Agile.B.Observation.C.Interviews.D.Questionnaires.2 points QUESTION 10Referencing the table below, what can you say about the following T-SQL Update statement? Select the best answer from the following. A.This statement will not run because it is incomplete.B.This statement will not run because it is invalid due to invalid syntax.C.This statement will update the first row that it finds in the table setting the Year column = 2020.D.This statement will update all the rows in the table setting the Year column = 2020.2 points QUESTION 11When thinking about the normalization process/normalizing our database, what do we know about multivalued attributes? Select the best answer from the following.A.Normalization requires that we use multivalued data in a relational database.B.Normalization doesn’t address this issue. Single- versus multi-valued attributes is simply a design choice and is an issue that is left up to the personal choices of the database designer.C.This is not an issue for relational databases. Discussion of multivalued attributes only occurs in NoSQL databases.D.In the design of a relational database there should never be multivalued attributes. 2 points QUESTION 12What is “Referential Integrity”? Select the best answer from the following.A.Referential integrity is a process followed by database designers to ensure their database designs are correct.B.Referential integrity is not part of the relational database design.C.Referential integrity is achieved when related tables are grouped together within a schema.D.Referential integrity is a constraint enforced by the DBMS that ensures consistency of the cross-references between and among tables.2 points QUESTION 13Insert the correct T-SQL clauses for a basic select command that returns all rows and all columns from a table called Employees filtered by the State column and sorted by the EmployeeLastName column. * Employees State = ‘OH’ EmployeeLastName2 points QUESTION 14In a relational database how is data integrity achieved? Select the best answer from the following.A.Data integrity is achieved through online transaction processing or OLTP.B.Data integrity is achieved through three-valued predicate logic supporting the Null marker.C.Data integrity is achieved and enforced through the software built to interact with a database.D.Data integrity is achieved through rules called constraints.2 points QUESTION 15Which of the following is work that is done as part of systems analysis? Select ALL answers that apply.A.Systems analysis helps to ensure the database design reflects the needs of the organization.B.Systems analysis helps in understanding the environment in which the database will be deployed.C.Systems analysis helps to ensure everyone in the organization understands the technical design of the database.D.Systems analysis helps in knowing how the end product should work.2 points QUESTION 16When joining tables in a Select statement there must exist a common column in both tables and it is a technical requirement that this column have the same name in each table. This statement is . . . Select the best answer from the following. A.TrueB.FalseC.True, but only for SQL Server.D.True, but only for NoSQL database.2 points QUESTION 17The Select statement belong to which category of SQL statements? Select the best answer from the following.A.Data Definition Language (DDL).B.Data Manipulation Language (DML).C.Data Control Language (DCL).D.Set Theory2 points QUESTION 18What is true of foreign keys. Select the best answer from the following.A.A foreign is created by giving it the same name as the column that it matches in the primary (parent) table. The DBMS automatically links the tables based on the column names.B.A foreign key is a column or columns whose value is the same as the primary key of another table in the database. In some cases, a foreign key can be created within the same table as primary key, but this is rare.C.A foreign key is a hidden column in a table that contains multiple pieces of information so that two or more tables can be related together.D.Foreign keys are not used in relational database design.2 points QUESTION 19What is an “ERD”? Select the best answer from the following.A.An ERD is an Entity-Relationship diagram.B.An ERD means that there is an “Error in the Relational Design.”C.An ERD is an Elemental Redesign Document.D.ERD is the service in AWS where a database is created.2 points QUESTION 20What is a relational database? Select the best answer from the following.A.An organized collection of structured data, and information about relationships.B.Any organized list that contains data is “technically” a relational database.C.A collection of information stored in a central repository that can be queried.D.Any system that can process online transactions (OLTP).2 points QUESTION 21The term Relational in the context of a relational databases means what? Select the best answer from the following.A.The term Relational stems from the fact that relational databases form relationships between tables.B.The term Relational comes from the title of the seminal paper written by E.F. Codd—the father of the relational database.C.The term Relational is related to the mathematic term relationin set theory.D.The term Relational refers to a set of unrelated information.2 points QUESTION 22What is an “entity”? Select the best answer from the following.A.An entity represents one of the columns in an individual table.B.There are no entities in a relational database. Entities are only part of NoSQL databases.C.An entity provides the meta-data about the entire database.D.An entity, for our purposes, is the same as a table in the database.2 points QUESTION 23You know that you have a lot of old data in the Courses table where those courses have not been taught in years and never will be again—meaning that no current Student rows are matched to these old Courses rows. You want to identify which rows in Courses are no longer matched with any Students. Which is the best join to use to accomplish this? Select the best answer from the following.A.The inner join will produce the result set needed.B.You must use a self-join to produce the result set needed.C.You will have to query each table individually and match the results in Excel to answer the question.D.You can use either the left or right join to produce the result set needed.2 points QUESTION 24What is a DBMS? Select the best answer from the following.A.A DBMS is a collection of programs enabling users to access databases, manipulate data, and present data.B.A DBMS serves as an intermediary between applications that use a database and open-source database technologies.C.DBMS is an outdated term used to refer to database technology before the advancement of relational database management systems.D.A DBMS is any program or application that has a relational database as its backend.2 points QUESTION 25What kind of processing is ideally suited for using a Relational Databases? Select the best answer from the following.A.Service Oriented Architecture (SOA)B.Data warehousing.C.Online Transaction Processing (OLTP)D.Stream data processing.2 points QUESTION 26What does a primary key constraint enforce or do? Select the best answer from the following.A.Tables containing multiple primary keys allows for fast searches on the table’s data.B.Primary keys enforces referential integrity.C.Primary keys enforce the uniqueness of rows.D.Primary keys enforce check constraints forcing rows to meet certain criteria before being allowed into the database.2 points QUESTION 27What is a “meaningful” identifier? Select the best answer from the following.A.This generally is a key that contains sensitive information that needs to be protected.B.This generally is a key where the value of the key carries implicit meaning.C.This is a key that will never be changed because the information it contains must never be lost.D.A “meaningful” identifier is always the same as a foreign key in a relationship.2 points QUESTION 28In the drawing shown below, what is the database term for the text ‘HumanResources’ shown in the parenthesis next to each of the table names? Select the best answer from the following. A.HumanResources is an attribute in both of these tables.B.HumanResources is an entity in both of these tables.C.HumanResources is the schema to which each of the two tables belong.D.HumanResources is simply part of the table name itself. For example, the full table name for one of the tables is ‘Employee (HumanResources)’.2 points QUESTION 29Referencing the table below, what can you say about the design of the table? Select ALL answers that apply. A.This table contains all the attributes (columns) that are needed.B.This table is okay as a start but does violate normalization rules—specifically it is not in Third Normal Form (3NF).C.I can’t know without doing good systems analysis work whether this table meets the organization’s needs.D.The design of this table is perfect for the software application that will use it.2 points QUESTION 30Which of the following is true when using an inner join? Select the best answer from the following.A.Only rows from the left-side of the join are returned if there is no match for that row in the table on the right-side of the join.B.All rows from the left-side of the join are returned and then matched against related rows from the table on the right-side of the join.C.All rows from the right-side of the join are returned and then matched against related rows from the table on the left-side of the join.D.Only rows that have related rows on both sides of the join are returned.2 points Click Save and Submit to save and submit. Click Save All Answers to save all answers.
Nonlinear Optimization
The purpose of this assignment is to introduce how to find solutions
to business problems using nonlinear optimization ...
Nonlinear Optimization
The purpose of this assignment is to introduce how to find solutions
to business problems using nonlinear optimization techniques.Using specified data files, chapter example files, and templates
from the “Topic 7 Student Data, Template, and Example
Files” topic material, complete Chapter 14, Problems 69, 70
(ignore the SolverTable portion), 72 (ignore the SolverTable portion),
and 94. Use Microsoft Excel’s Solver Add-In to complete these
problems. For Problems 70, 72, and 94, run the Solver’s Answer
and Sensitivity Reports. Interpret and summarize the key results.To receive full credit on the assignment, complete the following.Ensure that all Solver settings are defined through the use of
the Solver dialog box.Ensure that Excel files include the
associated cell functions and/or formulas if functions and/or
formulas are used.Include a written response to all
narrative questions presented in the problem by placing it in the
associated Excel file.Include Answer and Sensitivity
Reports interpretation and summary of key results.Place
each problem in its own Excel file. Ensure that your first and last
name are in your Excel file names.APA style is not required, but solid academic writing is expected.This assignment uses a rubric. Please review the rubric prior to
beginning the assignment to become familiar with the expectations for
successful completion. QUESTION 1- Can linear and nonlinear optimization problems use the same approach to
find a solution? For example, if the GRG algorithm is used to solve a
nonlinear optimization problem, will it work to solve a linear
optimization problem? Discuss whether or not the GRG algorithm will
always find a corner point similar to the feasible-region approach. QUESTION 2- Nonlinear optimization problems can have multiple solutions, and a
solution can be local or global. Can there be multiple local solutions?
Explain your answer. Can there be multiple global solutions? Explain our
answer.
Create the Home Page for the Dog Hall of Fame
Part 1:In previous work, you completed a wireframe and site map for the Dog Hall of Fame website in the dogfame.html webpa ...
Create the Home Page for the Dog Hall of Fame
Part 1:In previous work, you completed a wireframe and site map for the Dog Hall of Fame website in the dogfame.html webpage. In this lab, you’ll update that page with content and HTMLtags. By following the steps below:Save the dogfame.html page as index.html because it will serve as your home page for this site.Add a banner.jpg image as the first line of content in the <header> section with the following attribute values:alt="banner logo for Dog Hall of Fame"height="300"width="720"Create an unordered list of links to future pages that link to index.html, winners.html, and nominations.html in the nav section.Previously, you collected content, images, and stories to add to the Dog Hall of Fame website in these three areas: Hero dog, Working dog, and Companion dog. Add that content to the <div id="main"> section of the index.html page using heading, paragraph, and list tags as appropriate. Add four dog images.Validate and correct your webpage, spell check the content, and check the links between the index.html page and the services.html page. Zip your lab folder with all files and pictures.Part 2:Anytime you gather information or images from the web, copyright laws and academic fair use policies and ethics come into play. Research and apply the fair use and copyright policies that apply to the content you gather on the Internet as applied to the exercises for this class.
RecipeBox Driver Application
In the last stepping stone lab for this course, you will create a test application by writing a RecipeBox driver applicati ...
RecipeBox Driver Application
In the last stepping stone lab for this course, you will create a test application by writing a RecipeBox driver application. This class should create a menu and let users execute the various operations defined for your classes.Go to the Start Here page and download the Stepping Stone code .zip for the starter code for this assignment.To complete this assignment, review the following documents:Stepping Stone Lab Six GuidelinesStepping Stone Labs Two Through Six Rubric
5 pages
Java Programs
int pint = (((cups - bushels * 128) - gallon * 16) - quart * 4) / 2; int cup = (int)Math.ceil(((((cups - bushels * 128) - ...
Java Programs
int pint = (((cups - bushels * 128) - gallon * 16) - quart * 4) / 2; int cup = (int)Math.ceil(((((cups - bushels * 128) - gallon * 16) - quart * 4) - ...
Similar Content
University of California Program Design C Programming Task
Write a program to check if an email address read from a file is a UCLA email, an email that contains ucla.edu. The output...
Washington College Exploratory Data Analysis Using a Real Data Set Project
The project will
be a short exploratory data analysis using a real data set to investigate some research
questions. At a...
COMP 1005 German University of Technology in Oman Student Information System Report
solve only Task 1, 2,3 and 4 (please see attachment)Rules & Regulations:- All resources should be cited using CU Harvard s...
programming assignment help
please help me in the following...
submit deliverable and question.
For your task, submit a deliverable answering the question about the IT project and your personal project. Submit your fin...
EEEN20010 University College Dublin Game of Hangman Program Project
Please write a program by using C language and use codeblocks to write the program. Also, please while writing the program...
Reasons For Infinite Loops And How To Prevent Them In Programming
Reasons for Infinite Loops and how to Prevent them in Programming Reasons for Infinite Loops and how to Prevent them in Pr...
Step By Step Guide
Double click on the New Project to create a new project. You can give the project any name or use the default one...
Souvenir Sales Analysis In R
souvenir_sales.ts ...
Related Tags
Book Guides
Where'd You Go Bernadette
by Maria Semple
The Old Man and the Sea
by Ernest Hemmingway
The 48 Laws of Power
by Robert Greene
The Unwinding of the Miracle
by Julie Yip-Williams
I Cant Make This Up - Life Lessons
by Kevin Hart
The Trial
by Franz Kafka
The Kite Runner
by Khaled Hosseini
Breakfast at Tiffanys
by Truman Capote
The President is Missing
by James Patterson, Bill Clinton
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Columbus State Community College SQL Statement Programming Quiz 10
QUESTION 1What is true with respect to a row’s primary key? Select ALL answers that apply.A.The primary key should conta ...
Columbus State Community College SQL Statement Programming Quiz 10
QUESTION 1What is true with respect to a row’s primary key? Select ALL answers that apply.A.The primary key should contain a value that should never change; the value should be immutable.B.The primary key must not contain the value null.C.The primary key uniquely identifies each row in a table.D.The primary key of one table is used only to create a relationship to a different table’s primary key.2 points QUESTION 2In the drawing shown below, what kind of relationship exists between the Customers table and the Titles table? Select the best answer from the following. A.One-To-One relationship.B.One-To-Many relationship.C.Many-To-Many relationship using the StreamingHistory table as a composite entity.D.There is no relationship between the Customers and the Titles tables.2 points QUESTION 3In the drawing shown below, what kind of relationship exists between the Empoyee table and the EmployeePayHistory table? Select the best answer from the following. A.One-To-One relationship.B.One-To-Many relationship.C.Many-To-Many relationship.D.From the diagram given you cannot tell if there are any relationships between these two tables.2 points QUESTION 4Referencing the table below, what can you say about the following T-SQL Delete statement? Select the best answer from the following. A.This statement will not run because it is incomplete.B.This statement will not run because it is invalid due to invalid syntax.C.This statement will delete all the rows from the Movies table.D.This statement will delete the Movies table—remove the table from the database.2 points QUESTION 5In cloud architecture, which of the following is an example of SaaS? Select the best answer from the following.A.A database is hosted in a data center and is provided to the customer as a service. You have no control over the infrastructure, server, operating system, etc. You control only database itself.B.A database is installed on a virtual machine that resides in the cloud infrastructure. You have control over the operating system, but not to the physical hardware.C.A database is installed in an on-premise infrastructure. You have complete control over the infrastructure, hardware, operating system, etc.D.A database cannot be provisioned in a Software as a Service environment.2 points QUESTION 6Referencing the table below, what can you say about the following T-SQL Insert statement? Note that the Id column is an identity specification. Select the best answer from the following. A.This insert statement will insert exactly one row into the Movies table.B.This insert statement will fail because the Id column is not included in the list of columns.C.This insert statement will fail because neither the RottenTomatoesScore nor the TotalEarned columns are included in the list of columns.D.This insert statement will fail because the syntax is wrong.2 points QUESTION 7The ‘T’ in T-SQL stands for, what? Select the best answer from the following. A.TransactB.TypedC.Trans NotationalD.Translated2 points QUESTION 8What is an “attribute”? Select the best answer from the following.A.An attribute is the same, or synonymous with, a column in a table.B.An attribute, for our purposes, is the same as a table in the database.C.There are no attributes in a relational database. Attributes are only part of NoSQL databases.D.An attribute provides the meta-data about the entire database.2 points QUESTION 9Which of the following is NOT a tool used in conducting needs assessments? Select the best answer from the following.A.Agile.B.Observation.C.Interviews.D.Questionnaires.2 points QUESTION 10Referencing the table below, what can you say about the following T-SQL Update statement? Select the best answer from the following. A.This statement will not run because it is incomplete.B.This statement will not run because it is invalid due to invalid syntax.C.This statement will update the first row that it finds in the table setting the Year column = 2020.D.This statement will update all the rows in the table setting the Year column = 2020.2 points QUESTION 11When thinking about the normalization process/normalizing our database, what do we know about multivalued attributes? Select the best answer from the following.A.Normalization requires that we use multivalued data in a relational database.B.Normalization doesn’t address this issue. Single- versus multi-valued attributes is simply a design choice and is an issue that is left up to the personal choices of the database designer.C.This is not an issue for relational databases. Discussion of multivalued attributes only occurs in NoSQL databases.D.In the design of a relational database there should never be multivalued attributes. 2 points QUESTION 12What is “Referential Integrity”? Select the best answer from the following.A.Referential integrity is a process followed by database designers to ensure their database designs are correct.B.Referential integrity is not part of the relational database design.C.Referential integrity is achieved when related tables are grouped together within a schema.D.Referential integrity is a constraint enforced by the DBMS that ensures consistency of the cross-references between and among tables.2 points QUESTION 13Insert the correct T-SQL clauses for a basic select command that returns all rows and all columns from a table called Employees filtered by the State column and sorted by the EmployeeLastName column. * Employees State = ‘OH’ EmployeeLastName2 points QUESTION 14In a relational database how is data integrity achieved? Select the best answer from the following.A.Data integrity is achieved through online transaction processing or OLTP.B.Data integrity is achieved through three-valued predicate logic supporting the Null marker.C.Data integrity is achieved and enforced through the software built to interact with a database.D.Data integrity is achieved through rules called constraints.2 points QUESTION 15Which of the following is work that is done as part of systems analysis? Select ALL answers that apply.A.Systems analysis helps to ensure the database design reflects the needs of the organization.B.Systems analysis helps in understanding the environment in which the database will be deployed.C.Systems analysis helps to ensure everyone in the organization understands the technical design of the database.D.Systems analysis helps in knowing how the end product should work.2 points QUESTION 16When joining tables in a Select statement there must exist a common column in both tables and it is a technical requirement that this column have the same name in each table. This statement is . . . Select the best answer from the following. A.TrueB.FalseC.True, but only for SQL Server.D.True, but only for NoSQL database.2 points QUESTION 17The Select statement belong to which category of SQL statements? Select the best answer from the following.A.Data Definition Language (DDL).B.Data Manipulation Language (DML).C.Data Control Language (DCL).D.Set Theory2 points QUESTION 18What is true of foreign keys. Select the best answer from the following.A.A foreign is created by giving it the same name as the column that it matches in the primary (parent) table. The DBMS automatically links the tables based on the column names.B.A foreign key is a column or columns whose value is the same as the primary key of another table in the database. In some cases, a foreign key can be created within the same table as primary key, but this is rare.C.A foreign key is a hidden column in a table that contains multiple pieces of information so that two or more tables can be related together.D.Foreign keys are not used in relational database design.2 points QUESTION 19What is an “ERD”? Select the best answer from the following.A.An ERD is an Entity-Relationship diagram.B.An ERD means that there is an “Error in the Relational Design.”C.An ERD is an Elemental Redesign Document.D.ERD is the service in AWS where a database is created.2 points QUESTION 20What is a relational database? Select the best answer from the following.A.An organized collection of structured data, and information about relationships.B.Any organized list that contains data is “technically” a relational database.C.A collection of information stored in a central repository that can be queried.D.Any system that can process online transactions (OLTP).2 points QUESTION 21The term Relational in the context of a relational databases means what? Select the best answer from the following.A.The term Relational stems from the fact that relational databases form relationships between tables.B.The term Relational comes from the title of the seminal paper written by E.F. Codd—the father of the relational database.C.The term Relational is related to the mathematic term relationin set theory.D.The term Relational refers to a set of unrelated information.2 points QUESTION 22What is an “entity”? Select the best answer from the following.A.An entity represents one of the columns in an individual table.B.There are no entities in a relational database. Entities are only part of NoSQL databases.C.An entity provides the meta-data about the entire database.D.An entity, for our purposes, is the same as a table in the database.2 points QUESTION 23You know that you have a lot of old data in the Courses table where those courses have not been taught in years and never will be again—meaning that no current Student rows are matched to these old Courses rows. You want to identify which rows in Courses are no longer matched with any Students. Which is the best join to use to accomplish this? Select the best answer from the following.A.The inner join will produce the result set needed.B.You must use a self-join to produce the result set needed.C.You will have to query each table individually and match the results in Excel to answer the question.D.You can use either the left or right join to produce the result set needed.2 points QUESTION 24What is a DBMS? Select the best answer from the following.A.A DBMS is a collection of programs enabling users to access databases, manipulate data, and present data.B.A DBMS serves as an intermediary between applications that use a database and open-source database technologies.C.DBMS is an outdated term used to refer to database technology before the advancement of relational database management systems.D.A DBMS is any program or application that has a relational database as its backend.2 points QUESTION 25What kind of processing is ideally suited for using a Relational Databases? Select the best answer from the following.A.Service Oriented Architecture (SOA)B.Data warehousing.C.Online Transaction Processing (OLTP)D.Stream data processing.2 points QUESTION 26What does a primary key constraint enforce or do? Select the best answer from the following.A.Tables containing multiple primary keys allows for fast searches on the table’s data.B.Primary keys enforces referential integrity.C.Primary keys enforce the uniqueness of rows.D.Primary keys enforce check constraints forcing rows to meet certain criteria before being allowed into the database.2 points QUESTION 27What is a “meaningful” identifier? Select the best answer from the following.A.This generally is a key that contains sensitive information that needs to be protected.B.This generally is a key where the value of the key carries implicit meaning.C.This is a key that will never be changed because the information it contains must never be lost.D.A “meaningful” identifier is always the same as a foreign key in a relationship.2 points QUESTION 28In the drawing shown below, what is the database term for the text ‘HumanResources’ shown in the parenthesis next to each of the table names? Select the best answer from the following. A.HumanResources is an attribute in both of these tables.B.HumanResources is an entity in both of these tables.C.HumanResources is the schema to which each of the two tables belong.D.HumanResources is simply part of the table name itself. For example, the full table name for one of the tables is ‘Employee (HumanResources)’.2 points QUESTION 29Referencing the table below, what can you say about the design of the table? Select ALL answers that apply. A.This table contains all the attributes (columns) that are needed.B.This table is okay as a start but does violate normalization rules—specifically it is not in Third Normal Form (3NF).C.I can’t know without doing good systems analysis work whether this table meets the organization’s needs.D.The design of this table is perfect for the software application that will use it.2 points QUESTION 30Which of the following is true when using an inner join? Select the best answer from the following.A.Only rows from the left-side of the join are returned if there is no match for that row in the table on the right-side of the join.B.All rows from the left-side of the join are returned and then matched against related rows from the table on the right-side of the join.C.All rows from the right-side of the join are returned and then matched against related rows from the table on the left-side of the join.D.Only rows that have related rows on both sides of the join are returned.2 points Click Save and Submit to save and submit. Click Save All Answers to save all answers.
Nonlinear Optimization
The purpose of this assignment is to introduce how to find solutions
to business problems using nonlinear optimization ...
Nonlinear Optimization
The purpose of this assignment is to introduce how to find solutions
to business problems using nonlinear optimization techniques.Using specified data files, chapter example files, and templates
from the “Topic 7 Student Data, Template, and Example
Files” topic material, complete Chapter 14, Problems 69, 70
(ignore the SolverTable portion), 72 (ignore the SolverTable portion),
and 94. Use Microsoft Excel’s Solver Add-In to complete these
problems. For Problems 70, 72, and 94, run the Solver’s Answer
and Sensitivity Reports. Interpret and summarize the key results.To receive full credit on the assignment, complete the following.Ensure that all Solver settings are defined through the use of
the Solver dialog box.Ensure that Excel files include the
associated cell functions and/or formulas if functions and/or
formulas are used.Include a written response to all
narrative questions presented in the problem by placing it in the
associated Excel file.Include Answer and Sensitivity
Reports interpretation and summary of key results.Place
each problem in its own Excel file. Ensure that your first and last
name are in your Excel file names.APA style is not required, but solid academic writing is expected.This assignment uses a rubric. Please review the rubric prior to
beginning the assignment to become familiar with the expectations for
successful completion. QUESTION 1- Can linear and nonlinear optimization problems use the same approach to
find a solution? For example, if the GRG algorithm is used to solve a
nonlinear optimization problem, will it work to solve a linear
optimization problem? Discuss whether or not the GRG algorithm will
always find a corner point similar to the feasible-region approach. QUESTION 2- Nonlinear optimization problems can have multiple solutions, and a
solution can be local or global. Can there be multiple local solutions?
Explain your answer. Can there be multiple global solutions? Explain our
answer.
Create the Home Page for the Dog Hall of Fame
Part 1:In previous work, you completed a wireframe and site map for the Dog Hall of Fame website in the dogfame.html webpa ...
Create the Home Page for the Dog Hall of Fame
Part 1:In previous work, you completed a wireframe and site map for the Dog Hall of Fame website in the dogfame.html webpage. In this lab, you’ll update that page with content and HTMLtags. By following the steps below:Save the dogfame.html page as index.html because it will serve as your home page for this site.Add a banner.jpg image as the first line of content in the <header> section with the following attribute values:alt="banner logo for Dog Hall of Fame"height="300"width="720"Create an unordered list of links to future pages that link to index.html, winners.html, and nominations.html in the nav section.Previously, you collected content, images, and stories to add to the Dog Hall of Fame website in these three areas: Hero dog, Working dog, and Companion dog. Add that content to the <div id="main"> section of the index.html page using heading, paragraph, and list tags as appropriate. Add four dog images.Validate and correct your webpage, spell check the content, and check the links between the index.html page and the services.html page. Zip your lab folder with all files and pictures.Part 2:Anytime you gather information or images from the web, copyright laws and academic fair use policies and ethics come into play. Research and apply the fair use and copyright policies that apply to the content you gather on the Internet as applied to the exercises for this class.
RecipeBox Driver Application
In the last stepping stone lab for this course, you will create a test application by writing a RecipeBox driver applicati ...
RecipeBox Driver Application
In the last stepping stone lab for this course, you will create a test application by writing a RecipeBox driver application. This class should create a menu and let users execute the various operations defined for your classes.Go to the Start Here page and download the Stepping Stone code .zip for the starter code for this assignment.To complete this assignment, review the following documents:Stepping Stone Lab Six GuidelinesStepping Stone Labs Two Through Six Rubric
5 pages
Java Programs
int pint = (((cups - bushels * 128) - gallon * 16) - quart * 4) / 2; int cup = (int)Math.ceil(((((cups - bushels * 128) - ...
Java Programs
int pint = (((cups - bushels * 128) - gallon * 16) - quart * 4) / 2; int cup = (int)Math.ceil(((((cups - bushels * 128) - gallon * 16) - quart * 4) - ...
Earn money selling
your Study Documents