ess News | Sto...Home- Microsoft A...D Page viewARead aloud Add textTask #2Bob employs a Landscaping company that wants to use your services to help create an invoicegenerating system. The landscapers submit an invoice weekly. They charge $50 per hour worked. Theyalso charge tax- 13%. Bob likes to see an invoice that displays all the information -number of hours,the charge per hour, the total BEFORE tax and the total AFTER tax. Since this is an invoice, we also needto display the name of the company (Landscaping Xperts) at the top of the invoice. Display all of theinformation on the screen.Using Pseudocode, develop an algorithm for this problem.The comments must include the Number (i.e. Task#1), your full name and your studentQuestionnumberSubmit an electronic version using the submission point located in the week 1 folder. Theelectronic version MUST be in pdf format. Any other format will NOT be accepted and you willreceive a zero mark for your assignment.The assignments MUST be submitted before due date. Once the due date and time has passed- the submission is considered late a mark of zero (0) will be assigned.Change the name of the files to your firstnamelastname buildersAid.txt andfirstnameLastname_invoiceMaker.txtGrading 5 marks each

The number of hours worked by an employee must be entered. Then we find out that their hourly rate…

The comments must include the Question Number (i.e. Task#1), your full name and your student number Submit an electronic version using the submission point located in the week 1 folder. The electronic version MUST be in pdf format. Any other format will NOT be accepted and you will receive a zero mark for your assignment. The assignments MUST be submitted before due date. Once the due date and time has passed - the submission is considered late a mark of zero (0) will be assigned. Change the name of the files to your firstnameLastname buildersAid.txt and firstnameLastname invoiceMaker.txt 9. Grading 5 marks each

The comments must include the Question Number (i.e. Task#1), your full name and your student number Submit an electronic version using the submission point located in the week 1 folder. The electronic version MUST be in pdf format. Any other format will NOT be accepted and you will receive a zero mark for your assignment. The assignments MUST be submitted before due date. Once the due date and time has passed - the submission is considered late a mark of zero (0) will be assigned. Change the name of the files to your firstnameLastname buildersAid.txt and firstnameLastname invoiceMaker.txt 9. Grading 5 marks each

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.
Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task Retrieve the mailing address (first name, surname, and address) for each resident. Task 7: The development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT. Alter the RESIDENTS table and change the ID field to an auto-incremented field. Task 8: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table. Task Add Yigit…
Complete the exercise described in the attached document. Algorithm Exercise.docx Rubric: 1-Uses pseudo code not actual code 1-Includes prompt output steps before input steps 1-Calculates p 1-Calculates A Assume that there is an available function that will calculate the square root of a value use the name SQRT() https://quincy.instructure.com/courses/15140/files/1261838/download?verifier=pHUEAZhXer74z5lq0g563Ijk84PHhv34VOUZxuzH&wrap=1
Managers Sales ManagerfirstName ManagerlastName ManagerTitle EmployeefirstName CompanyName RecipientFirstName RecipientlastName Product Quanity Address EmplooyeelastName EmployeeTitle Apt City Province PostalCode PricePerUnit TotalPrice SalesManFirstName SalesManlastName OperationExpenses EmployeefirstName/Vendoriame EmployeelastName PaymentType Paymentamount PaymentDate Address Quanity Apt City Province PostalCode Comments With the above, 1. Draw the cardinality charts including correct parent, child, min cardinality, and max cardinality
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
files for the work: https://mega.nz/file/AEJQFZIT#IKKIb5DD9h-5fHiWzEAIg8Lm60syggKnAwL1fqQQ168 Therefore, you should have print statements only where it is explicitly mentioned in the assignment. If you have additional print statements, make sure they are all converted to comments before you submit the assignment. Page 4 of 12 Assignment # 4 Due: Nov. 27th 11:00 PM 1. Text File Format Download the zipped file Files_for_A4 from Brightspace. When you will extract this zipped file you should find the following text files in the folder. The sample text files (datafile) are aTaleOfTwoCities.txt, harry.txt, harryPotter.txt, and invisibleMan.txt. You may assume that the words of the text files are separated by spaces (* ') and newline characters ( *\n'). You will be using these text files to do the analysis. There are two additional files (wordfile) named positivewords.txt and negativewords.txt; each of these files contains a sequence of words (one word per line) and these words will be…
File Home Insert Draw Page Layout Formulas Data Review View Help A Share P Comments 14 fe A E G H J K L M Q R 1 Semeste Course NumbelCoure NameCredit Hours Letter Grad Grade Points Directions Create a spreadsheet that correctly calculates your GPA - must use formulas for GPA = full credit. You need to inlcude grades for two semesters. If you do not already have two semesters worth of grades assume this semesters grades and one future semester worth of grades. 2 3 4 To calculate GPA dividing the total amount 5 of grade points earned by the total amount of credit hours attempted. Your grade point 6 7 8 average may range from 0.0 to a 4.0. 9 Grade Points - multiply credit hours of course by the number associated with the 3 letter grade you earned. • A = 4 B = 3 C = 2 5 -7 D = 1 F = 0 1 Wine Sales Cinderella's Grades Your GPA + + 95%
Create a form that includes a dropdown list with 4 items: Windows 95, Windows XP, Windows NT, Windows 7. The form should contain submit button. Assume this form will use the processing program "formProc.cgi", which is located at www.formprocessing.com/cgi-bin. Form data should be sent to server by "POST".
Create 3 separate detailed flowcharts for a burger restaurant. 1st flowchart: Ordering process based on pre- selected burgers: Choose which burger the customer wants to order based on the available options. Burgers may be named however you'd want. 2. Create-your-own burger: Customer will be prompted to choose what meat, toppings, sauces, and bun they would like to create their own burger. Choose whatever price you like 3. Receipt printing process: Print a receipt with order details, including total, price of menu items purchased, company name, address, contact, date, etc. Add 6% tax at the end and display total.
Calculate a bonus depending on job id using a case expression. Display the employee id, last name, job id, department id, salary, and the bonus amount • If job id is AD_VP, the bonus amount will be Salary * .1555 • If job id is IT_PROG, the bonus amount will be Salary * .1050 • For all other job roles, the bonus amount will be 50.00 dollars. Name the column bonus amount and round the values to a whole number (0 decimal places).
3) Why might a total field on a form not show a total, even though data has been entered in fields that are to be summed? O Fields associated with the total are not set to calculate on exit The total field is defined as a Text Form Field The total field includes an incorrect bookmark O The total field is associated with a macro.
If the user makes an incorrect product category selection, prompt the user to re-enter a valid product category.Q.1.6 Provide the user with the option to select between the following product warranty options:• 1 – Applies a six-month product warranty.• Any other key applies a two-year warranty.Q.1.7 Once the entire submission has been completed, the user must be informed that the product details have been successfully saved. The user must have the ability to search for a product. The user will select menu item two (2), which will prompt the user to enter a product code. If a valid product is found in the application, then display the product details to the user. If no valid product is found, display an error message to the user that the product cannot be located.Sample Product Search ScreenshotSample Invalid Product ScreenshotQ.1.9 The user must have the option to delete a product that has been saved. The user must first enter the product code to be deleted. Next, the user must confirm…