Description
Visual studio c# program
Unformatted Attachment Preview
In the English measurement system, 1 yard equals 3 feet and 1 foot equals 12 inches. Use this
information to create an application that lets the user convert distances to and from inches, feet and
yards.
Figure 4-35 on page 265 shows an example of how the application’s form might appear. In the example,
the user enters the distance to be converted into a TextBox. A ListBox allows the user to select the units
being converted from, and another ListBox allows the user to select the units being converted to.
Note: Be sure to handle the situation where the user picks the same units from both list boxes. The
converted value will be the same as the value entered.
Add the following comments to the beginning of the program.
Name:
Your Name
Class and Section:
CS 165 02
Assignment:
Program Assignment 03
Due Date:
See above
Date Turned in:
Program Description: You write a short description of what the program will do
When you complete the program, do the following.
1. Turn in a printout of the source code with this sheet attached to the front
2. Create a folder with the following name: Program 03
3. Copy your project to this folder
4. Copy the folder to the following location: I:\kopp\inbox\CS 165 02\your name where your
name is a folder located in I:\kopp\inbox\CS 165 02.
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
Hi! H...
Completion Status:
100%
Review
Review
Anonymous
Super useful! Studypool never disappoints.
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
2 pages
Multithreading
Multithreading is the process by which multiple threads are executed at the same time, say simultaneously. Both multithrea ...
Multithreading
Multithreading is the process by which multiple threads are executed at the same time, say simultaneously. Both multithreading and multiprocessing are ...
CS 3723 The University of Texas at San Antonio LISP Programming
Code the macro, iterate, which is based on the following:(iterate controlVariable beginValueExpr endValueExpr incrExpr bod ...
CS 3723 The University of Texas at San Antonio LISP Programming
Code the macro, iterate, which is based on the following:(iterate controlVariable beginValueExpr endValueExpr incrExpr bodyexpr1 bodyexpr2 ... bodyexprN)iterate is passed a controlVariable which is used to count from beginValueExpr to endValueExpr (inclusive) by the specified increment.For each iteration, it evaluates each of the one or more body expressions.Since beginValueExpr,endValueExpr, and incrExpr are expressions, they must be evaluated.The endValueExpr and incrExpr are evaluated before processing the rest of the macro.This means the code within the user's use of the macro cannot alter the termination condition nor the increment; however, it can change the value of the controlVariable.The functional return value of iterate macro doesn't matter, and will probably be T.You can create an intermediate variable named endValue for the endValueExpr. You can create an intermediate variable named incValue for the incrExpr. For 5 bonus points, use gensym to generate the name of those two variables.
Peer Review Unit 2
Primary Task Response: Within the Discussion Board
area, write 400–600 words that respond to the following questions w ...
Peer Review Unit 2
Primary Task Response: Within the Discussion Board
area, write 400–600 words that respond to the following questions with
your thoughts, ideas, and comments. This will be the foundation for
future discussions by your classmates. Be substantive and clear, and use
examples to reinforce your ideas.StoryThe Education Community Services Group (ECSG) has been leading the
market in educational services enrollments for the past five years.
Soon, other leading educational services providers started to overtake
the enrollments because of improvements made through online marketing. A
study was conducted using surveys and analyses with statistics. With
the demand for educational services and network administration
architecture (NSA) revamping, the company found some breathing room. Now
you can go to a number of satellite campuses and online portals to
enroll in the educational offerings that ECSG provides. Results have
been great, and the corporation has been able to lead the task of
rejuvenating student enrollment.Moral of the StoryAs a company, management has to adapt to changes and competition. One
vital step to improving profitability and competitiveness is to
evaluate the current network administration to determine performance
gaps and ensure senior management is receiving the critical information
it requires to make strategic decisions. ECSG, realizing that it is
losing market share to other providers of educational services, has
determined that it needs a more robust network administration
architecture to close the gap with its competitors. If you have that
agility and resiliency, you can survive as a company in the world of
constant competition. As the old saying goes, "If you cannot beat them,
then join them." That is what the corporation did. The chief executive
officer (CEO) made sure that he shares the online market as well.The example companies, organizations, products, people, and events
depicted herein are fictitious. No association with any real company,
organization, product, person, or event is intended or should be
inferred.Assignment DetailsThe story that you just read shows how difficult it can be to get
started with formal enterprise system architecture, particularly if very
little attention was given to enterprise system architecture (ESA) and
documentation of content in an organization. For this discussion,
research the library and Internet for information about the evaluation
of enterprise systems architecture in organizations, and then respond to
the difficulties faced in the story and how some of these difficulties
were overcome.Discuss how you can automate existing company network administration
processes as well as revamp the information technology (IT)
infrastructure.
Identify positive and negative aspects of the selected processes in relation to the operational health of the organization.
Select 1 of the most likely problem areas of an organization’s
network administration infrastructure, and discuss how the difficulties
could be overcome. What did you learn from your classmate's posting?
What additional questions do you have after reading the posting?
What clarification do you need regarding the posting?
What differences or similarities do you see between your posting and other classmates' postings?
NJIT Forecasting with Multiple Linear Regression Python Programming
Prepare the Train and Test,Build Features,Make Multiple Linear Regression,Performance in Trading
NJIT Forecasting with Multiple Linear Regression Python Programming
Prepare the Train and Test,Build Features,Make Multiple Linear Regression,Performance in Trading
Southern New Hampshire University Validating User Input and Debugging Program
OverviewMany Java programs that you create will receive and process user input. In order to ensure that user input is accu ...
Southern New Hampshire University Validating User Input and Debugging Program
OverviewMany Java programs that you create will receive and process user input. In order to ensure that user input is accurate, you will need to use input validation and exception handling. For example, if you ask for a zip code, you want to ensure the user inputs a five-digit number. In this activity, you are given “buggy” code for a paint program that calculates the number of cans of paint required to paint a wall, given the wall’s height and width. You will need to debug the code and improve it by adding code to validate user input and handle exceptions.PromptFor this assignment, you will complete the paint program by debugging the original code and adding code that validates user input and handles exceptions. Use the Uploading Files to Eclipse and the Downloading Files from Eclipse Tutorial tutorials to help you with this project.DebuggingOpen the Virtual Lab by clicking on the link in the Virtual Lab Access module. Then open your IDE. Upload the Paint1.zip folder and review the code for the Paint1.java file.Find and fix the three errors in the given code.Use the input values below to test your program. If you found and fixed all errors, your output should exactly match what is below.TIP: When you run your program in Eclipse, it will prompt you to enter input in the Console window. If you cannot find this window, go to Window, then Show View, then Console.Input Validation and Exception HandlingReview the code, looking for the two code blocks where user input is required.Implement a do-while loop in both blocks of code to ensure that input is valid and any exceptions are handled.TIP: Consider using a try-catch block for exception handling, but it is not required.Use the two sample invalid inputs below to test your program. Your program should respond to each by prompting the user to enter valid input. This should continue to loop until valid input is received.THINK: Why is 0 invalid input for this problem? What is the user being asked to input?Guidelines for SubmissionAttach your completed Paint1.java file to the assignment submission page.Module Six Assignment RubricCriteriaProficient (100%)Needs Improvement (75%)Not Evident (0%)ValueDebuggingDebugs a class so that no errors remain and calculations work correctlyMeets some “Proficient” criteria, but with errors or exclusions such as one or two remaining bugsDoes not attempt criterion30Input Validation and Exception HandlingAdds loops to validate all user input and handle exceptions so that code passes all test casesMeets most “Proficient” criteria, but with errors; areas for improvement may include ability to handle all test casesDoes not attempt criterion70Total: 100%
San Diego State University Database Web Interface Project
Database Web Interface First Name Last Name ID# ...
San Diego State University Database Web Interface Project
Database Web Interface First Name Last Name ID# Email Address Table of Contents How to submit1 P1 – Pet Adoption System (40 Points)2 Database (25 Points)2 PHP/HTML Programming (15 Points)3 P2 Cities (35 Points)4 Part 1 – Arrays - City Distances (12 points)4 Part 2 - Central Point (12 Points)5 Part 3 – Add UI (11 Points)5 P3 – Forms - Certificate Generator Tool (25 Points)5 How to submit After filling all the parts in this file, please follow the following steps. Add your name and ID to the first page.Save the file in the original format (Docx or Doc)Rename the file asUpload and submit your file (only via Blackboard). (please do not convert to other file formats e.g. PDF, ZIP, RAR, …). YOUR First Name– YOUR Last Name–ID.docx Example: John-Smith-234566435.docx Note: The final run results of each problem (screenshot or a copy of the results) should be added to the run result section “orange boxes”. Displaying the final run results accounts for 20% of the points given to each part. P1 – Pet Adoption System (40 Points) Part 1 - Database (25 Points) This question requires PhpMyAdmin to create the pet_adoption database.Follow the below instructions to create this database.Make sure to include the database scripts (CREATE, INSERT, etc.) with your PHP project.They are also to be graded along with your PHP/HTML code. The database must be named as pet_adoption.The database will have these tables: PET_TYPES: ID [INT] – Primary key and auto-generatedNAME [VARCHAR(50) / NOT NULL] – Type of a pet. Notes: Currently, there are only two supported pet types (Dog and Cat). You need to manually insert these pet types using the INSERT statements.Despite of having two supported pet types, make sure that no duplicates of pet types is allowed. PET_BREEDS: ID [INT] – Primary key and auto-generatedNAME [VARCHAR(50) / NOT NULL] – Breed of a pet.IS_DOG_BREED [TINYINT / NOT NULL] – If set to 1, this is the dog breed.Otherwise, it’s the cat breed.ID [INT] – Primary key and auto-generatedNAME [VARCHAR(50) / NOT NULL] – Name of a pet to adopted. Notes: You need to manually insert the pet breeds using the INSERT statements.Make sure that there are no duplicates of dog breeds and/or cat breeds.In other words, create a unique key index on both columns (NAME and IS_DOG_BREED).Using the INSERT statements to insert the following cat breeds:PersianSanvannahJapanese BobtailHimalayanUsing the INSERT statements to insert the following dog breeds: BoxerDalmatianGolden RetrieverShih Tzu PETS: BREED [INT / NOT NULL] – Foreign key to the pet_breeds table.TYPE [INT / NOT NULL] – Foreign key to the pet_types table.ARRIVAL_DATE [DATETIME / NOT NULL] – Date when the pet arrives to the adoption center.OWNER_FIRST_NAME [VARCHAR(50) / NULL] – First name of the new owner.OWNER_LAST_NAME [VARCHAR(50) / NULL] – Last name of the new owner.OWNER_MIDDLE_NAME [VARCHAR(50) / NULL] – Middle name of the new owner.ADOPTION_DATE [DATETIME / NULL] – Date when the pet is adopted. Notes: Enable the delete and update cascading for foreign keys for BREED and TYPE.Insert the pets for adoption using the INSERT statements with the information below: The below SELECT statement is used to generate the above data table.You are welcomed to use it as is or to modify it to suite your needs. SELECT p.name AS pet_name, t.name AS pet_type, b.name AS pet_breed, p.arrival_date, CONCAT(IFNULL(p.owner_first_name, ''), IFNULL(p.owner_last_name, ''), IFNULL(p.owner_middle_name, '')) AS owner_full_name, p.adoption_date FROM `pets` p INNER JOIN `pet_types` t ON t.id = p.type INNER JOIN `pet_breeds` b ON b.id = p.breed ORDER BY t.name, b.name; Insert your SQL code for creation of database in the following box. Your SQL code for creating the database --Copy and paste your code here Also please add screenshots of the database tables in the phpMyAdmin environment here. Part 2 - PHP/HTML Programming (15 Points) Implement the home page (index.php) to display the above data table with two additional columns: Edit and Delete.The Edit column will allow the user to enter the new owner name and the adoption date.The Delete column will allow the user to remove the selected pet from the pet adoption center. Your PHP Code --Copy and paste your code here Run the code and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) Please add the result (screenshot) of data table as well as a sample case for deleting and editing one of the pets in the PETS table (result of clicking on the delete and edit buttons). P2 Cities (35 Points) Part 1 – Arrays - City Distances (12 points) Consider the following X and Y values for the locations of 5 cities. City#XY ---------------------------------------- 1|2.55 2|5.13 3|19 4|5.454 5|5.52.1 Write a PHP program that calculates the distance among all cities and display it as a 5 * 5 table. The element at row = i and col = j will show the distance between cities i and j. For example, row 2 and col 3 will show distance between city 2 and city 3. Note: Distance between two cities is defined as Euclidian distance. For example, the distance between city 2 and city 3 will be: D = sqrt ( (x2-x3)^2+(y2-y3)^2 ) = sqrt ( (5.1-1)^2+(3-9)^2 ) = 7.267 Your PHP Code --Copy and paste your code here Run the code and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) Part 2 - Central Point (12 Points) Given a set of cities, the central point is the city that has the shortest total distance to all other cities. Write a PHP program that finds the central city and its total distance to all other cities for the 5 cities in part 1. Your PHP Code --Copy and paste your code here Run the code and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) Part 3 – Add UI (11 Points) Modify the code in part 1 and 2 and add the following UI (Form) to the code. After running the code, by entering X and Y and clicking on “Add New City” we add a new city. This process continues until all the cities are entered. Then we click on “Show Distance Table” to see the distance table (result of part 1). Clicking on the “Find Central City” will show the central point (result of part 2). Test your code with the list of cities given in part 1 (entered one by one) and show the result. Your PHP Code --Copy and paste your code here Run the code and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) P3 – Forms - Certificate Generator Tool (25 Points) In this problem we are going to design a certificate form. For this problem, the design of the certificate (both HTML and CSS files) are given in the “Problem 3” folder. You just need do add the following form to the page and then link it to the certificate fields using PHP code. More details about this problem and expected is given in the following 3-minute YouTube Video (the video has no voice. Please CTRL+Click on the link or simply copy and paste it in the address bar of your web browser). YouTube Video: https://youtu.be/27VbBvx9fOo Note: No design work is needed for this problem. All the files (HTML, CSS and images) are given. Just the above form should be added to the page and then the fields should be linked to the certificate fields, so that when we click on “Create Certificate” button, then the certificate with info entered by the user is created. Your PHP Code --Copy and paste your code here Run the code and create a certificate for Name: John Smith, Date: 10/20/2020 University: San Diego State University, Program: Computer Science and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) The end
Similar Content
help with my project
hello,read the requirement and do my projectlet me know if you have any questionplease be on time...
IT 404 Saudi Electronic University Webpages Structure and Design Questions
College of Computing and Informatics
Project
Deadline: Thursday 15/05/2022 @ 23:59
[Total Mark for this Assignment is 15]...
The IF Condition is one of the conditions
What is the importance
of using the IF condition in a program?
...
California University of Pennsylvania Java Programming Code Project
helloall details below ------------------------------------------------------------------------------...
Java program named MemoryCalculator
Part 1 - Java program named MemoryCalculator - In your Ubuntu VM (virtual machine), using terminal mode ONLY, do
the foll...
10 questions 10 questions 10 questions 10 questions
10 questions 10 questions 10 questions 10 questions 10 questions 10 questions 10 questions ...
Related Tags
Book Guides
Rules Of Civility
by Amor Towles
Don Quixote
by Miguel de Cervantes
Calypso
by David Sedaris
Crime and Punishment
by Fyodor Dostoyevsky
The Bell Jar
by Sylvia Plath
Little Women
by Louisa May Alcott
I Cant Make This Up - Life Lessons
by Kevin Hart
To Kill a Mockingbird
by Harper Lee
The Girl With The Dragon Tattoo
by Stieg Larsson
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
2 pages
Multithreading
Multithreading is the process by which multiple threads are executed at the same time, say simultaneously. Both multithrea ...
Multithreading
Multithreading is the process by which multiple threads are executed at the same time, say simultaneously. Both multithreading and multiprocessing are ...
CS 3723 The University of Texas at San Antonio LISP Programming
Code the macro, iterate, which is based on the following:(iterate controlVariable beginValueExpr endValueExpr incrExpr bod ...
CS 3723 The University of Texas at San Antonio LISP Programming
Code the macro, iterate, which is based on the following:(iterate controlVariable beginValueExpr endValueExpr incrExpr bodyexpr1 bodyexpr2 ... bodyexprN)iterate is passed a controlVariable which is used to count from beginValueExpr to endValueExpr (inclusive) by the specified increment.For each iteration, it evaluates each of the one or more body expressions.Since beginValueExpr,endValueExpr, and incrExpr are expressions, they must be evaluated.The endValueExpr and incrExpr are evaluated before processing the rest of the macro.This means the code within the user's use of the macro cannot alter the termination condition nor the increment; however, it can change the value of the controlVariable.The functional return value of iterate macro doesn't matter, and will probably be T.You can create an intermediate variable named endValue for the endValueExpr. You can create an intermediate variable named incValue for the incrExpr. For 5 bonus points, use gensym to generate the name of those two variables.
Peer Review Unit 2
Primary Task Response: Within the Discussion Board
area, write 400–600 words that respond to the following questions w ...
Peer Review Unit 2
Primary Task Response: Within the Discussion Board
area, write 400–600 words that respond to the following questions with
your thoughts, ideas, and comments. This will be the foundation for
future discussions by your classmates. Be substantive and clear, and use
examples to reinforce your ideas.StoryThe Education Community Services Group (ECSG) has been leading the
market in educational services enrollments for the past five years.
Soon, other leading educational services providers started to overtake
the enrollments because of improvements made through online marketing. A
study was conducted using surveys and analyses with statistics. With
the demand for educational services and network administration
architecture (NSA) revamping, the company found some breathing room. Now
you can go to a number of satellite campuses and online portals to
enroll in the educational offerings that ECSG provides. Results have
been great, and the corporation has been able to lead the task of
rejuvenating student enrollment.Moral of the StoryAs a company, management has to adapt to changes and competition. One
vital step to improving profitability and competitiveness is to
evaluate the current network administration to determine performance
gaps and ensure senior management is receiving the critical information
it requires to make strategic decisions. ECSG, realizing that it is
losing market share to other providers of educational services, has
determined that it needs a more robust network administration
architecture to close the gap with its competitors. If you have that
agility and resiliency, you can survive as a company in the world of
constant competition. As the old saying goes, "If you cannot beat them,
then join them." That is what the corporation did. The chief executive
officer (CEO) made sure that he shares the online market as well.The example companies, organizations, products, people, and events
depicted herein are fictitious. No association with any real company,
organization, product, person, or event is intended or should be
inferred.Assignment DetailsThe story that you just read shows how difficult it can be to get
started with formal enterprise system architecture, particularly if very
little attention was given to enterprise system architecture (ESA) and
documentation of content in an organization. For this discussion,
research the library and Internet for information about the evaluation
of enterprise systems architecture in organizations, and then respond to
the difficulties faced in the story and how some of these difficulties
were overcome.Discuss how you can automate existing company network administration
processes as well as revamp the information technology (IT)
infrastructure.
Identify positive and negative aspects of the selected processes in relation to the operational health of the organization.
Select 1 of the most likely problem areas of an organization’s
network administration infrastructure, and discuss how the difficulties
could be overcome. What did you learn from your classmate's posting?
What additional questions do you have after reading the posting?
What clarification do you need regarding the posting?
What differences or similarities do you see between your posting and other classmates' postings?
NJIT Forecasting with Multiple Linear Regression Python Programming
Prepare the Train and Test,Build Features,Make Multiple Linear Regression,Performance in Trading
NJIT Forecasting with Multiple Linear Regression Python Programming
Prepare the Train and Test,Build Features,Make Multiple Linear Regression,Performance in Trading
Southern New Hampshire University Validating User Input and Debugging Program
OverviewMany Java programs that you create will receive and process user input. In order to ensure that user input is accu ...
Southern New Hampshire University Validating User Input and Debugging Program
OverviewMany Java programs that you create will receive and process user input. In order to ensure that user input is accurate, you will need to use input validation and exception handling. For example, if you ask for a zip code, you want to ensure the user inputs a five-digit number. In this activity, you are given “buggy” code for a paint program that calculates the number of cans of paint required to paint a wall, given the wall’s height and width. You will need to debug the code and improve it by adding code to validate user input and handle exceptions.PromptFor this assignment, you will complete the paint program by debugging the original code and adding code that validates user input and handles exceptions. Use the Uploading Files to Eclipse and the Downloading Files from Eclipse Tutorial tutorials to help you with this project.DebuggingOpen the Virtual Lab by clicking on the link in the Virtual Lab Access module. Then open your IDE. Upload the Paint1.zip folder and review the code for the Paint1.java file.Find and fix the three errors in the given code.Use the input values below to test your program. If you found and fixed all errors, your output should exactly match what is below.TIP: When you run your program in Eclipse, it will prompt you to enter input in the Console window. If you cannot find this window, go to Window, then Show View, then Console.Input Validation and Exception HandlingReview the code, looking for the two code blocks where user input is required.Implement a do-while loop in both blocks of code to ensure that input is valid and any exceptions are handled.TIP: Consider using a try-catch block for exception handling, but it is not required.Use the two sample invalid inputs below to test your program. Your program should respond to each by prompting the user to enter valid input. This should continue to loop until valid input is received.THINK: Why is 0 invalid input for this problem? What is the user being asked to input?Guidelines for SubmissionAttach your completed Paint1.java file to the assignment submission page.Module Six Assignment RubricCriteriaProficient (100%)Needs Improvement (75%)Not Evident (0%)ValueDebuggingDebugs a class so that no errors remain and calculations work correctlyMeets some “Proficient” criteria, but with errors or exclusions such as one or two remaining bugsDoes not attempt criterion30Input Validation and Exception HandlingAdds loops to validate all user input and handle exceptions so that code passes all test casesMeets most “Proficient” criteria, but with errors; areas for improvement may include ability to handle all test casesDoes not attempt criterion70Total: 100%
San Diego State University Database Web Interface Project
Database Web Interface First Name Last Name ID# ...
San Diego State University Database Web Interface Project
Database Web Interface First Name Last Name ID# Email Address Table of Contents How to submit1 P1 – Pet Adoption System (40 Points)2 Database (25 Points)2 PHP/HTML Programming (15 Points)3 P2 Cities (35 Points)4 Part 1 – Arrays - City Distances (12 points)4 Part 2 - Central Point (12 Points)5 Part 3 – Add UI (11 Points)5 P3 – Forms - Certificate Generator Tool (25 Points)5 How to submit After filling all the parts in this file, please follow the following steps. Add your name and ID to the first page.Save the file in the original format (Docx or Doc)Rename the file asUpload and submit your file (only via Blackboard). (please do not convert to other file formats e.g. PDF, ZIP, RAR, …). YOUR First Name– YOUR Last Name–ID.docx Example: John-Smith-234566435.docx Note: The final run results of each problem (screenshot or a copy of the results) should be added to the run result section “orange boxes”. Displaying the final run results accounts for 20% of the points given to each part. P1 – Pet Adoption System (40 Points) Part 1 - Database (25 Points) This question requires PhpMyAdmin to create the pet_adoption database.Follow the below instructions to create this database.Make sure to include the database scripts (CREATE, INSERT, etc.) with your PHP project.They are also to be graded along with your PHP/HTML code. The database must be named as pet_adoption.The database will have these tables: PET_TYPES: ID [INT] – Primary key and auto-generatedNAME [VARCHAR(50) / NOT NULL] – Type of a pet. Notes: Currently, there are only two supported pet types (Dog and Cat). You need to manually insert these pet types using the INSERT statements.Despite of having two supported pet types, make sure that no duplicates of pet types is allowed. PET_BREEDS: ID [INT] – Primary key and auto-generatedNAME [VARCHAR(50) / NOT NULL] – Breed of a pet.IS_DOG_BREED [TINYINT / NOT NULL] – If set to 1, this is the dog breed.Otherwise, it’s the cat breed.ID [INT] – Primary key and auto-generatedNAME [VARCHAR(50) / NOT NULL] – Name of a pet to adopted. Notes: You need to manually insert the pet breeds using the INSERT statements.Make sure that there are no duplicates of dog breeds and/or cat breeds.In other words, create a unique key index on both columns (NAME and IS_DOG_BREED).Using the INSERT statements to insert the following cat breeds:PersianSanvannahJapanese BobtailHimalayanUsing the INSERT statements to insert the following dog breeds: BoxerDalmatianGolden RetrieverShih Tzu PETS: BREED [INT / NOT NULL] – Foreign key to the pet_breeds table.TYPE [INT / NOT NULL] – Foreign key to the pet_types table.ARRIVAL_DATE [DATETIME / NOT NULL] – Date when the pet arrives to the adoption center.OWNER_FIRST_NAME [VARCHAR(50) / NULL] – First name of the new owner.OWNER_LAST_NAME [VARCHAR(50) / NULL] – Last name of the new owner.OWNER_MIDDLE_NAME [VARCHAR(50) / NULL] – Middle name of the new owner.ADOPTION_DATE [DATETIME / NULL] – Date when the pet is adopted. Notes: Enable the delete and update cascading for foreign keys for BREED and TYPE.Insert the pets for adoption using the INSERT statements with the information below: The below SELECT statement is used to generate the above data table.You are welcomed to use it as is or to modify it to suite your needs. SELECT p.name AS pet_name, t.name AS pet_type, b.name AS pet_breed, p.arrival_date, CONCAT(IFNULL(p.owner_first_name, ''), IFNULL(p.owner_last_name, ''), IFNULL(p.owner_middle_name, '')) AS owner_full_name, p.adoption_date FROM `pets` p INNER JOIN `pet_types` t ON t.id = p.type INNER JOIN `pet_breeds` b ON b.id = p.breed ORDER BY t.name, b.name; Insert your SQL code for creation of database in the following box. Your SQL code for creating the database --Copy and paste your code here Also please add screenshots of the database tables in the phpMyAdmin environment here. Part 2 - PHP/HTML Programming (15 Points) Implement the home page (index.php) to display the above data table with two additional columns: Edit and Delete.The Edit column will allow the user to enter the new owner name and the adoption date.The Delete column will allow the user to remove the selected pet from the pet adoption center. Your PHP Code --Copy and paste your code here Run the code and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) Please add the result (screenshot) of data table as well as a sample case for deleting and editing one of the pets in the PETS table (result of clicking on the delete and edit buttons). P2 Cities (35 Points) Part 1 – Arrays - City Distances (12 points) Consider the following X and Y values for the locations of 5 cities. City#XY ---------------------------------------- 1|2.55 2|5.13 3|19 4|5.454 5|5.52.1 Write a PHP program that calculates the distance among all cities and display it as a 5 * 5 table. The element at row = i and col = j will show the distance between cities i and j. For example, row 2 and col 3 will show distance between city 2 and city 3. Note: Distance between two cities is defined as Euclidian distance. For example, the distance between city 2 and city 3 will be: D = sqrt ( (x2-x3)^2+(y2-y3)^2 ) = sqrt ( (5.1-1)^2+(3-9)^2 ) = 7.267 Your PHP Code --Copy and paste your code here Run the code and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) Part 2 - Central Point (12 Points) Given a set of cities, the central point is the city that has the shortest total distance to all other cities. Write a PHP program that finds the central city and its total distance to all other cities for the 5 cities in part 1. Your PHP Code --Copy and paste your code here Run the code and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) Part 3 – Add UI (11 Points) Modify the code in part 1 and 2 and add the following UI (Form) to the code. After running the code, by entering X and Y and clicking on “Add New City” we add a new city. This process continues until all the cities are entered. Then we click on “Show Distance Table” to see the distance table (result of part 1). Clicking on the “Find Central City” will show the central point (result of part 2). Test your code with the list of cities given in part 1 (entered one by one) and show the result. Your PHP Code --Copy and paste your code here Run the code and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) P3 – Forms - Certificate Generator Tool (25 Points) In this problem we are going to design a certificate form. For this problem, the design of the certificate (both HTML and CSS files) are given in the “Problem 3” folder. You just need do add the following form to the page and then link it to the certificate fields using PHP code. More details about this problem and expected is given in the following 3-minute YouTube Video (the video has no voice. Please CTRL+Click on the link or simply copy and paste it in the address bar of your web browser). YouTube Video: https://youtu.be/27VbBvx9fOo Note: No design work is needed for this problem. All the files (HTML, CSS and images) are given. Just the above form should be added to the page and then the fields should be linked to the certificate fields, so that when we click on “Create Certificate” button, then the certificate with info entered by the user is created. Your PHP Code --Copy and paste your code here Run the code and create a certificate for Name: John Smith, Date: 10/20/2020 University: San Diego State University, Program: Computer Science and insert the result in the following box. The run result Copy and paste the result here (e.g. the screen shot of the result you get by running the code) The end
Earn money selling
your Study Documents