Description
Unformatted Attachment Preview
CSC 122 – INTRODUCTION TO PROGRAMMING
PROG #4
100 POINTS
Programming Exercise #4
Property Tax
Due: March 19, 2015
Instructions: A county collects property taxes on the assessment value of property,
which is 60 percent (0.6) of the property’s actual value. For example, if an acre of land
is valued at $10,000, its assessment value is $6,000. The property tax is then 72¢ for
each $100 (0.0072) of the assessment value. The tax for the acre assessed at $6,000
will be $43.20. Write a program that asks for the actual value of a piece of property and
calls a function named showPropertyTax to display the assessment value and
property tax. Both the assessment value and property tax information will need to be
passed as arguments to the function. See Program 5-9 (page 187) in textbook and the
sample program included with this programming exercise on passing arguments to a
function.
Programming Style Requirements
1. To write a new Python program in IDLE, you open a new editing window to store
your code (also referred to as source code). Click File on the menu bar, then
click New File or alternatively you can press Ctrl+N.
2. Standard Output Program Header Information
CSC 122-W1 - Program #4
By
The standard output program header information is to be included at the top of
the program and should be the first lines displayed on the output screen.
3. Comments
The program must include a main comment block (3-4 lines is sufficient) after
the standard output program header information that describes the purpose of
the program. In Python, comments begin with the # character in column 1.
Also, there must be comments throughout the program to describe your
processes (i.e. formula, loop, etc.). Note, comments can also be put at the end
of a line of code.
4. Descriptive names must be used for all variables in the program.
5. The assessment value and property tax must be passed as arguments to the
showPropertyTax function.
Winter 2015
1
Due: 3/19/2015
CSC 122 – INTRODUCTION TO PROGRAMMING
PROG #4
6. Property Tax Information
Display the assessment value and property tax rounded to two (2) decimal
places as shown in the screen capture below.
7. Required Output:
The above screen capture shows correct program execution:
Note: The blue text in the required output above is the text generated by the program.
8. Saving the Program
Save the program created in the text editor window as Prog4.py
9. Running the Program
While in the text editor window, run the program by pressing the F5 key or by
clicking Run on the editor window’s menu bar, then Run Module. If the program
has not been saved since the last modification was made, a dialog box will
appear. Click OK to save the program. When the program runs you will see its
output displayed in IDLE’s Python Shell window.
When the program is working correctly and free of syntax errors, submit the Prog4.py
file to Blackboard. (DO NOT send the program via email. Only homework submitted via
Bb will be graded.)
Winter 2015
2
Due: 3/19/2015
CSC 122 – INTRODUCTION TO PROGRAMMING
PROG #4
Grade Rubric:
*Points
Description
5
The program is saved with the proper filename.
5
The program displays the standard output header information.
10
The program includes a main comment block along with comments to
describe processes used in the program (i.e. formula, loop, etc.).
10
The program uses descriptive names for all variables used in the program.
40
The program has a function called showPropertyTax to the assessment
value and property tax information. The function is passed the assessment
value and property tax as arguments.
20
The program correctly calculates the assessment value and property tax.
See screen capture above.
10
The program displays the assessment value and property tax rounded to
two (2) decimal places.
100
Total Points
*NOTE: NO CREDIT WILL BE GIVEN FOR A PROGRAM WITH SYNTAX
ERRORS.
Steps for Uploading the Program to Blackboard
1. Click on the Course Content tab. This will take you to the course assignment
that has been posted.
2. Click on the Programming Assignments folder. Program #4 is located in this
folder.
3. Click the >> Program #4 link to start the uploading process.
4. Go to the Assignment Materials area to attach the Prog4.py file. Click the Browse
for Local File button to locate and attach your file.
5. Once you have attached the Prog4.py file, click the Submit button to submit your
program.
6. Program #4 submission has been completed.
Winter 2015
3
Due: 3/19/2015
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
Review
Review
Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!
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.
CS192 Grantham University Team Management Modularized Program Paper
Team ManagementYou are in charge of managing a local softball team, one in which there is a lot of turnover. While you hav ...
CS192 Grantham University Team Management Modularized Program Paper
Team ManagementYou are in charge of managing a local softball team, one in which there is a lot of turnover. While you have a couple of regulars, much of the team members come and go frequently. When it comes to organizing games, it is becoming more and more difficult to keep track of the current members, so you decide to write a small program to help you track the current players.Write a modularized program that will utilize a main menu to control the program’s functions and a list to store the members of your team. The following functions that your program needs to include:Print the current member list.Add a new member.Remove a member.Modify an existing member.Exit the programRemeber that you can create a function using 'def.' In other words, for adding a new member, you will need a function similar to: def aaddmember.Note: Since we have not covered File Access, do not worry about long term storage for your list. Each time you run the program, you will have to create a new list. You are welcome to skip ahead to the File I/O if you would like to tackle this additional functionality, but file access is NOT required for this assignment.For this project:You will submit your python code in either the original .py file, or copied into a .txt file.A screenshot of your code having been executed (run). How to Take a Screenshot.Tips: The menu logic will use the same structure as your previous programs. A single variables will be used as the control value, and based on what the user entered as the control value, will determine the course of action taken inside of the loop.Example output:C:\>python week4.pyWelcome to the Team Manager===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 2Enter new member's name: Nathan===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 2Enter new member's name: Toby===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 1NathanToby===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 3Enter member name to be removed: Toby===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 1Nathan===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 4Enter the name of the memeber you want to edit: NathanEnter the new name of the member: Nathan Braun===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 1Nathan Braun===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 9Exiting Program...
Ashford University Data Science in Finance and Insurance Analysis Essay
The classification is the lecture and required material to read. Make sure read it before working on project.The HW 6 file ...
Ashford University Data Science in Finance and Insurance Analysis Essay
The classification is the lecture and required material to read. Make sure read it before working on project.The HW 6 file contains the hw instruction and format.If you need anything else, let me know.Thanks!
4 pages
Ai In Healthcare
Artificial intelligence (AI) is the ability of computers to simulate the intelligence of human beings in a way that these ...
Ai In Healthcare
Artificial intelligence (AI) is the ability of computers to simulate the intelligence of human beings in a way that these actions are close to how a ...
Similar Content
Ethics: VIRUS PROTECTION SCAMS
Everyone should worry about getting a computer virus that will corrupt or destroy files. Some suggest that software develo...
java programming lab
instructions are all in the attached files. ...
JBU Neighbor Identity Matlab Commands Lines Questions
3. Neighbor Identification
In this problem, we'll write a script to identify all the neighbors of a given cell in a rectan...
C Programming Code Interpretation Questions
Code interpretation•I give you some code, you say what the output is•Draw UML for the code•I give you some code, wri...
I need help
The following formula gives the distance between two points (x1, y1) and (x2, y2) in the Cartesian plane: Given the cen...
UCLA Java Springboot Need to Add Log Functions Question
I need help with my spring-boot project. it needs to add metrics and log data function. Create the following custom metric...
Project Proposal
Integrating database system is a database project that ensures that the normal daily operation of the merged companies res...
Primary Task Response
Discuss which method can help you retrieve the needed data in the quickest and most efficient manner, and justify the reas...
Ans Qz1
1- What file in the etc/ directory contains user’s hashed password? 2-What file and file-field are read by the finger co...
Related Tags
Book Guides
Death Of A Salesmen
by Arthur Miller
Salt To The Sea
by Ruta Sepetys
Treasure Island
by Robert Louis
Communist Manifesto
by Karl Marx
The Lord of the Flies
by William Golding
Herzog
by Saul Bellow
Where the Crawdads Sing
by Delia Owens
Shattered - Inside Hillary Clintons Doomed Campaign
by Amie Parnes and Jonathan Allen
The Point of it All - A Lifetime of Great Loves and Endeavors
by Charles Krauthammer
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.
CS192 Grantham University Team Management Modularized Program Paper
Team ManagementYou are in charge of managing a local softball team, one in which there is a lot of turnover. While you hav ...
CS192 Grantham University Team Management Modularized Program Paper
Team ManagementYou are in charge of managing a local softball team, one in which there is a lot of turnover. While you have a couple of regulars, much of the team members come and go frequently. When it comes to organizing games, it is becoming more and more difficult to keep track of the current members, so you decide to write a small program to help you track the current players.Write a modularized program that will utilize a main menu to control the program’s functions and a list to store the members of your team. The following functions that your program needs to include:Print the current member list.Add a new member.Remove a member.Modify an existing member.Exit the programRemeber that you can create a function using 'def.' In other words, for adding a new member, you will need a function similar to: def aaddmember.Note: Since we have not covered File Access, do not worry about long term storage for your list. Each time you run the program, you will have to create a new list. You are welcome to skip ahead to the File I/O if you would like to tackle this additional functionality, but file access is NOT required for this assignment.For this project:You will submit your python code in either the original .py file, or copied into a .txt file.A screenshot of your code having been executed (run). How to Take a Screenshot.Tips: The menu logic will use the same structure as your previous programs. A single variables will be used as the control value, and based on what the user entered as the control value, will determine the course of action taken inside of the loop.Example output:C:\>python week4.pyWelcome to the Team Manager===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 2Enter new member's name: Nathan===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 2Enter new member's name: Toby===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 1NathanToby===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 3Enter member name to be removed: Toby===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 1Nathan===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 4Enter the name of the memeber you want to edit: NathanEnter the new name of the member: Nathan Braun===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 1Nathan Braun===========Main Menu===========1. Display Team Roster.2. Add Member.3. Remove Member.4. Edit Member.9. Exit Program.Selection> 9Exiting Program...
Ashford University Data Science in Finance and Insurance Analysis Essay
The classification is the lecture and required material to read. Make sure read it before working on project.The HW 6 file ...
Ashford University Data Science in Finance and Insurance Analysis Essay
The classification is the lecture and required material to read. Make sure read it before working on project.The HW 6 file contains the hw instruction and format.If you need anything else, let me know.Thanks!
4 pages
Ai In Healthcare
Artificial intelligence (AI) is the ability of computers to simulate the intelligence of human beings in a way that these ...
Ai In Healthcare
Artificial intelligence (AI) is the ability of computers to simulate the intelligence of human beings in a way that these actions are close to how a ...
Earn money selling
your Study Documents