• As a suggestion, you might want to accomplish this SQL exercise before you accomplish the primary assignment for this week.
• If you have not already done so, use MSSQLS Management Studio to create a new database named ch07_ConstructCo. Use the default settings. When the database has been created, run the Ch07_ConstructCo_SQL.txt script linked above to create and load the database tables and data.  
• Write a T-SQL query for the constructco tables to list the employee last name, first name, job code, and hire date from the employee table.
• Write a T-SQL query for the constructco tables to list the employee last name, first name, and hire date where the hire date is greater than 2000-01-01.
• Write a T-SQL query for the constructco tables to list the employee last name, project number, assigned job from the employee, and assignment tables where the employee table employee number is equal to the assignment table employee number.
• Ensure that you have copied and pasted all of the T-SQL statements and verification results into your assignment submission.

Once you have accomplished that action, paste the script into your assignment submission document for this part of your assignment.

Use only the operators discussed in class (select, project, Cartesian product, join, union, intersection, set difference and renaming). Type your answers.

Consider the following database schema:

INGREDIENT(ingredient-id,name,price-ounce)

RECIPE(recipe-id,name,country,time)

USES(rid,iid,quantity)

where INGREDIENT lists ingredient information (id, name, and the price per ounce); RECIPE lists recipe information (id, name, country of origin, and time it takes to cook it); and USES tells us which ingredients (and how much of each) a recipe uses. The primary key of each table is underlined; rid is a foreign key to RECIPE and iid is a foreign key to INGREDIENT.

Write the following queries in Relational Algebra.

(a) Find the names of French recipes that use butter and take longer than 45 minutes to cook.

(b) Find the names of recipes that use butter or lard.

(c) Find the names of recipes that use butter and lard.

(d) Find the name of recipes that do not use butter.

(e) Find the names of recipes that use 2 or more ingredients.

(f) (*) Find the names of recipes where at least 3 oz. (quantity) of every ingredient are used.

JAVA/Netbeans

•Design a class named Person with fields for holding a person’s name, address and phone number (all Strings)

–Write a constructor that takes all the required information.

–Write a constructor that only takes the name of the person and uses this to call the first constructor you wrote.

–Implement the accessor and mutator methods. Make them final so subclasses cannot override them

–Implement the toString() method

•Design a class named Customer, which extends the Person class. It should have a field for the Customer ID (String) and a Boolean field indicating whether the customer wishes to be on a mailing list.

–Write a constructor that takes the name of the customer, id, address, phone number and the Boolean. Use super to call the appropriate constructor in Person

–Write a constructor that takes the name of the customer and id only and uses this to call the first constructor you wrote. It should set the Boolean to false.

–Implement the accessor and mutator methods for the customer id and Boolean.

–Override the toString() method using @override and use super to call Person’s toString()

•Write a main method that asks the user for the info of two customers, the first asking only for name and id, and the second asking for all the information. It creates 2 Customers and prints them out.

2.13 Program: Food receipt (Python 3)

1.Enter food item name: hot dog

Enter item price: 2

Enter item quantity: 5

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

Total cost: $ 10.0

2.Enter food item name: hot dog

Enter item price: 2

Enter item quantity: 5

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

Total cost: $ 10.0

Enter second food item name: ice cream

Enter item price: 2.50

Enter item quantity: 4

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

4 ice cream @ $ 2.5 = $ 10.0

Total cost: $ 20.0

3.Enter food item name: hot dog

Enter item price: 2

Enter item quantity: 5

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

Total cost: $ 10.0

Enter second food item name: ice cream

Enter item price: 2.50

Enter item quantity: 4

RECEIPT

5 hot dog @ $ 2.0 = $ 10.0

4 ice cream @ $ 2.5 = $ 10.0

Total cost: $ 20.0

15% gratuity: $ 3.0

Total with tip: $ 23.0

1. Create an example of what a form in a database could look like. The form should have 5 fields to get the following information (Music ID, Album Name, Medium Type, Artist Name, and Release Year.) (You can sketch it using Paint, draw it on paper and scan it, use shapes in Word, use wireframe.cc and take a screenshot of the result and turn that in...sky's the limit)
2. Create an example report (same method used as the example form). This report display the information Music ID, Album Name, Medium Type, Artist Name, and Release Year in an organized manner with titles.
3. Create a table named tblMusic.
4. In the table, add fields called MusicID, AlbumName, MediumType, ArtistName, ReleaseYear.
5. Make MusicID the primary key. The MusicID should be simply a number (you can have it auto-generate, if you wish).
6. Create a form named frmMusic. This form should have 5 required fields.
7. Use the form to input five CDs, records, or other types of musical media. You can make up names or use real albums.
8. Create a report that displays the information from the tblMusic in an attractive and clear manner. Make sure all items are labeled and are visible. Name it rptMusic.

1. Create a Project and a Class called “FinalGrade”

Write a Java program to compute your final grade for the course.

Assume the following (you can hard-code these values in your program).

Assignments are worth 30%

Labs are worth 40%

Mid-term is worth 15%

Final is worth 15%

Ask for the grades in each category. Store them in a double variable.
Print out the final percentage grade.

          For example,

Final Grade Calculation

Enter percentage grades in the following order.

Assignments, Labs, Mid-term test, Final Exam: 95 88 86 92

The final grade is 90

2. Create a Project and a Class called “AgeCheck”

Write a Java program to ask the user for their name and age. Use a string variable for the name and an int variable for the age. Output a message using the name and whether the user is old enough to purchase alcohol (21 years old).

For example,

Age Checker
Enter your name: Steve
Enter your age: 19
Hello, Steve, you are only 19 and not old enough to purchase alcohol.

Age Checker
Enter your name: Jane
Enter your age: 25
Hello, Jane, you are 25 and old enough to purchase alcohol.

i want Solution From Question Number 5 Solution Of questions 1-4 in Previou Post
Note (I Want ScreenShot For Solution)

Use Kali Linux Commands to show me the following:
1. Who are you?
2. Change directory to Downloads
3. Make a new directory
4. Make a new text file under your name (Ghada.txt)
5. Write a paragraph about Cyber security (4 to 5 sentences) >>simply open the file and write
inside it
6. Change the permission to be 764
7. Open the file but with a cyber security match Show me each and every step with figure
b. Enter into Portswagger lab (Username enumeration via subtly different responses)

https://portswigger.net/web-security/authentication/password-based/lab-username-enumerationvia-subtly-different-responses
Show me step-by-step how to use burp to get the username and password. Name the username list

with your name ex. Ghada_usename.txt and Ghada_password.txt
Use Seed Machine (the same SQL injection website)to conduct SQL Injection such that:
1. Update Boby nickname to be your name (by Alice)
2. Update Boby password to be (your name as a password) (by Alice).

C++ programming

To store the information about a city and its weather forecast, create a struct that holds the city's name (string), population (int), and a forecast array storing 7 string elements representing the city's weather in the next 7 days.

The program will then accept user input to enter the name and population of the city, then it accepts 7 string inputs to store into the forecast array.

Then the program will output the city's name, population, and forecast data.

Ex: If the inputs are:

Houston 2313000 sunny sunny sunny rainy thunderstorm sunny sunny

the function outputs:

Houston
Population: 2313000
7 Day Forecast: 
Day 0: sunny
Day 1: sunny
Day 2: sunny
Day 3: rainy
Day 4: thunderstorm
Day 5: sunny
Day 6: sunny

Your program must name the struct "city" with name, population, and forecast as the corresponding member names!

Your program must define and call this function to output the city information:

void city_info(city c)

#include <iostream>
using namespace std;

/* Define your struct here */

/* Define your printing function here */

int main() {
/* Type your code here */

return 0;
}

Using an Aging Schedule to Account for Bad Debts

Sparkle Jewels distributes fine stones. It sells on credit to retail jewelry stores and extends terms that require the stores to pay in 60 days. For accounts that are not overdue, Sparkle has found that there is a 90% probability of collection. For accounts up to one month past due, the likelihood of collection decreases to 75%. If accounts are between one and two months past due, the probability of collection is 60%, and if an account is over two months past due, Sparkle Jewels estimates only a 40% chance of collecting the receivable.

On December 31, 2016, the credit balance in Allowance for Doubtful Accounts is $11,500. The amounts of gross receivables by age on this date are as follows:

Required:

1. Prepare a schedule to estimate the amount of uncollectible accounts at December 31, 2016.

2. On the basis of the schedule in part (1), prepare the journal entry on December 31, 2016, to estimate bad debts. Indicate the effect on financial statement items by selecting "–" for decrease (or negative effect), "+" for increase (or positive effect) and "NE" for No Entry (or no effect) on the financial statement.

3. Show how accounts receivable would be presented on the December 31, 2016, balance sheet.

Oshimbala Foods Ltd is a fast food company that operates many outlets across the country. The reporting period of Oshimbala Foods Ltd ends on 31 October. Oshimbala Foods Ltd is not registered as a VAT vendor.

MATTER 1

On 1 November 2014 Oshimbala Foods Ltd purchased equipment with an invoice price of N$ 273 600 under a lease agreement. The lease payments will consist of equal annual instilments over a period of 4 years, payable in arrears. The interest rate applicable on this lease agreement is 8% per year. All payments due have been paid on time each year. The equipment is depreciated on the straight line basis over 5 years with no residual value.

Required:

Disclose the long term borrowings note applicable to the lease liability in the Statement of Financial Position of Oshimbala Foods Ltd on 31 October 2016 in accordance with International Financial Reporting Standards. Note: Round disclosed amounts to the nearest Dollar.

MATTER 2

On 1 January 2016 Oshimbala Foods Ltd signed a 3-year rental agreement on a new outlet to be opened in Maruua Mall. The business was able to negotiate a very good deal on this 3-year rental agreement. For the first year of the agreement, Oshimbala Foods Ltd will not have to pay any rent on the outlet. In the second year of the contract, the business will pay N$ 2 500 rental per month and in the third (last) year of the agreement Oshimbala Foods Ltd will pay N$ 5 000 per month. The accountant of Oshimbala Foods Ltd did not recognize any entries in the accounting records of the business for the period ended 31 October 2016 since no payments had to be made during the first year of the agreement.

Required:

a) Explain whether the accountant of Oshimbala Foods Ltd was correct in not recording any journal entries on the rental agreement for the period ended 31 October 2016 in accordance with International Financial Reporting Standards.

b) Provide the journal entry (if any) to appropriately account for the rental agreement in the accounting records of Oshimbala Foods Ltd for the reporting period ended 31 October 2016.

(Total 30 MARKS)