Write a script that creates a user-defined database role named paymententry in the ap database. give update permission to the new role for the invoices table, update and insert permission for the invoicelineitems table, and select permission for all user tables.

2. write a script that (1) creates a login id named "aaaron" with the password "aaar999"; (2) sets the default database for the login to the ap database; (3) creates a user named "aaron" for the login; and (4) assigns the user to the paymententry role you created in exercise1.

4. using the management studio, create a login id named "ffalk" with the password "ffal", and set the default database to the ap database. then, create a user for the login id named "ffalk" and assign the user to the paymententry role you created in exercise1.

In this lab, you complete a prewritten c++ program for a carpenter who creates personalized house signs. the program is supposed to compute the price of any sign a customer orders, based on the following facts: the charge for all signs is a minimum of $35.00. the first five letters or numbers are included in the minimum charge; there is a $4 charge for each additional character. if the sign is made of oak, add $20.00. no charge is added for pine. black or white characters are included in the minimum charge; there is an additional $15 charge for gold-leaf lettering. instructions ensure the file named housesign.cppis open in the code editor. you need to declare variables for the following, and initialize them where specified: a variable for the cost of the sign initialized to 0.00 (charge). a variable for the number of characters initialized to 8 (numchars). a variable for the color of the characters initialized to "gold" (color). a variable for the wood type initialized to "oak" (woodtype). write the rest of the program using assignment statements and ifstatements as appropriate. the output statements are written for you. execute the program by clicking the run button. your output should be: the charge for this sign is $82. this is the code, // housesign.cpp - this program calculates prices for custom made signs. #include #include using namespace std; int main() { // this is the work done in the housekeeping() function // declare and initialize variables here // charge for this sign // color of characters in sign // number of characters in sign // type of wood // this is the work done in the detailloop() function // write assignment and if statements here // this is the work done in the endofjob() function // output charge for this sign cout < < "the charge for this sign is $" < < charge < < endl; return(0); }

Digital information is stored using a series of ones and zeros. computers are digital machines because they can only read information as on or off –1 or 0. this method of computation is known as the system

The blank button automatically displays next to the data when you select a range of numeric data which is an available option for creating a chart