Visual Basic 2010 Checking Account Calculation with All Validations, Low Balance Validation

Checking Account Calculation with All Validations, Low Balance Validation

Using Visual Basic 2010, create form that computes a checking acount balance.  The form must include radio buttons to indicate the type of transaction: deposit, check or service charge.  A text box that will allow the user to enter the amount of the transaction.  Display the new balance in a READ ONLY text box or a label.  It also needs to calculate the balance by adding deposits and subtracting service charges checks.  Include buttons for Calculate Clear, Print and Exit.  I have enclosed a copy of the picture of how the form should look

Preview Screen Shot:

• This tutorial was purchased 1 time and rated A+ by students like you.
• Posted on Apr. 14, 2013 at 05:00:53AM 

Asked: $50

Email: syedjahangirb@gmail.com for downloading assignment

Files in Solution:

Preview.jpg (0K)
CheckingAccount.zip (138K)
[ 
 CheckingAccount/CheckingAccount/App.config
 CheckingAccount/CheckingAccount/bin/Debug/CheckingAccount.exe
 CheckingAccount/CheckingAccount/bin/Debug/CheckingAccount.pdb
 CheckingAccount/CheckingAccount/bin/Debug/CheckingAccount.vshost.exe
 CheckingAccount/CheckingAccount/bin/Debug/CheckingAccount.vshost.exe.manifest
 CheckingAccount/CheckingAccount/bin/Debug/CheckingAccount.xml
 CheckingAccount/CheckingAccount/CheckingAccount.vbproj
 CheckingAccount/CheckingAccount/Form1.Designer.vb
 CheckingAccount/CheckingAccount/Form1.resx
 CheckingAccount/CheckingAccount/Form1.vb
 CheckingAccount/CheckingAccount/My Project/Application.Designer.vb
 CheckingAccount/CheckingAccount/My Project/Application.myapp
 CheckingAccount/CheckingAccount/My Project/AssemblyInfo.vb
 CheckingAccount/CheckingAccount/My Project/Resources.Designer.vb
 CheckingAccount/CheckingAccount/My Project/Resources.resx
 CheckingAccount/CheckingAccount/My Project/Settings.Designer.vb
 CheckingAccount/CheckingAccount/My Project/Settings.settings
 CheckingAccount/CheckingAccount/obj/x86/Debug/CheckingAccount.exe
 CheckingAccount/CheckingAccount/obj/x86/Debug/CheckingAccount.Form1.resources
 CheckingAccount/CheckingAccount/obj/x86/Debug/CheckingAccount.pdb
 CheckingAccount/CheckingAccount/obj/x86/Debug/CheckingAccount.Resources.resources
 CheckingAccount/CheckingAccount/obj/x86/Debug/CheckingAccount.vbproj.FileListAbsolute.txt
 CheckingAccount/CheckingAccount/obj/x86/Debug/CheckingAccount.xml
 CheckingAccount/CheckingAccount/obj/x86/Debug/DesignTimeResolveAssemblyReferences.cache
 CheckingAccount/CheckingAccount/obj/x86/Debug/DesignTimeResolveAssemblyReferencesInput.cache
 CheckingAccount/CheckingAccount/obj/x86/Debug/GenerateResource.read.1.tlog
 CheckingAccount/CheckingAccount/obj/x86/Debug/GenerateResource.write.1.tlog
 CheckingAccount/CheckingAccount/obj/x86/Debug/TempPE/My Project.Resources.Designer.vb.dll
 CheckingAccount/CheckingAccount.sln
 CheckingAccount/CheckingAccount.suo
 CheckingAccount/Preview.jpg
 CheckingAccount/Solution 3.png
 ]

VB 2010, Weekly Salary Calculator Sales Person Commission Program

Visual Studio 2010 Help with Salesperson Weekly Salary Calculator

A salesperson earns a weekly base salary plus a commission when sales are at or above quota. Create a project that allows the user to input the weekly sales and the salesperson name, calculates the commission, and displays summary information. Form: The form should have text boxes for the salesperson’s name and his or her weekly sales. Menu: File Edit Help Pay Clear About Summary ________ Exit Font... Color... Use constants to establish the base pay, the quota, and the commission rate. The Pay menu item calculates and displays the commission and the total pay for that person. However, if there is no commission, do not display the commission amount (do not display a zero-commission amount). Write a function procedure to calculate the commission. The function must compare sales to the quota. When the sales are equal to or greater than the quota, calculate the commission by multiplying sales by the commission rate. Each salesperson receives the base pay plus the commission (if one has been earned). Format the dollar amounts to two decimal places; do not display a dollar sign. The Summary menu item displays a message box that holds total sales, total commissions, and total pay for all salespersons. Display the numbers with two decimal places and dollar signs. The Clear menu item clears the name, sales, and pay for the current employee and then resets the focus. The Color and Font menu items should change the color and font of the information displayed in the total pay text box. Use a message box to display the program name and your name as programmer for the About option on the Help menu. Test Data: Quota = 1000; Commission rate = .15; and Base pay = $250.  I have attached a photo of how the project should look.  Would like to have done by 4/23/2010.  Thanks

Functions:
Sales Commission Calculator, Font, Color, Clear, Exit, ShortKeys

Vb.Net 2010 Express Auto Repair, Splash Screen, Clear Exit, Multiple Forms Background, Previews

Preview Screen Shot:

Commission Calculator Screen

Summary Sales Commission Calculation

Excel Calculation Verification

• This tutorial was purchased 1 time and rated A+ by students like you.
• Posted on Apr 24, 2013 at 8:49:52PM 

Asked: $50

Email: syedjahangirb@gmail.com for downloading assignment

Files in Solution:

ExcelPreviewCalculations.JPG (22K)
CommissionCalculatorPreview.JPG (23K)
SummaryPreview.JPG (17K) (Preview)
SalesCommissionCalculator.zip (87K)
[ 
 SalesCommissionCalculator/SalesCommissionCalculator/App.config
 SalesCommissionCalculator/SalesCommissionCalculator/bin/Debug/SalesCommissionCalculator.exe
 SalesCommissionCalculator/SalesCommissionCalculator/bin/Debug/SalesCommissionCalculator.pdb
 SalesCommissionCalculator/SalesCommissionCalculator/bin/Debug/SalesCommissionCalculator.vshost.exe
 SalesCommissionCalculator/SalesCommissionCalculator/bin/Debug/SalesCommissionCalculator.xml
 SalesCommissionCalculator/SalesCommissionCalculator/CommissionCalculator.Designer.vb
 SalesCommissionCalculator/SalesCommissionCalculator/CommissionCalculator.resx
 SalesCommissionCalculator/SalesCommissionCalculator/CommissionCalculator.vb
 SalesCommissionCalculator/SalesCommissionCalculator/My Project/Application.Designer.vb
 SalesCommissionCalculator/SalesCommissionCalculator/My Project/Application.myapp
 SalesCommissionCalculator/SalesCommissionCalculator/My Project/AssemblyInfo.vb
 SalesCommissionCalculator/SalesCommissionCalculator/My Project/Resources.Designer.vb
 SalesCommissionCalculator/SalesCommissionCalculator/My Project/Resources.resx
 SalesCommissionCalculator/SalesCommissionCalculator/My Project/Settings.Designer.vb
 SalesCommissionCalculator/SalesCommissionCalculator/My Project/Settings.settings
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/DesignTimeResolveAssemblyReferences.cache
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/DesignTimeResolveAssemblyReferencesInput.cache
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/SalesCommissionCalculator.CommissionCalculator.resources
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/SalesCommissionCalculator.exe
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/SalesCommissionCalculator.pdb
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/SalesCommissionCalculator.Resources.resources
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/SalesCommissionCalculator.vbproj.FileListAbsolute.txt
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/SalesCommissionCalculator.vbproj.GenerateResource.Cache
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/SalesCommissionCalculator.xml
 SalesCommissionCalculator/SalesCommissionCalculator/obj/x86/Debug/TempPE/My Project.Resources.Designer.vb.dll
 SalesCommissionCalculator/SalesCommissionCalculator/SalesCommissionCalculator.vbproj
 SalesCommissionCalculator/SalesCommissionCalculator.sln
 SalesCommissionCalculator/SalesCommissionCalculator.suo
 ]

Solution for Programming in Visual Basic 2010 1st Edition Chapter 6 Problem 2PE Program that will produce a summary of amounts for Pat's Auto Repair Shop

Solution for Programming in Visual Basic 2010 1st Edition Chapter 6 Problem 2PE Visual Basic 2010 Program that will produce a summary of amounts for Pat's Auto Repair Shop

Create a project that will produce a summary of the amounts due for Pat's Auto Repair Shop. Display a splash screen first; then display the Job Information form. Add a graphic to the form. 

The Job Information Form Menu: 

File Edit Help
Exit Calculate About
Clear

Job Information Form: The Job Information form must have text boxes for the user to enter the job number, customer name, amount charged for parts, and the hours of labor. Include labels and text boxes for Parts, Labor, Subtotal, Sales Tax, and Total. 

The Calculate menu item finds the charges and displays them in labels. The tax rate and the hourly labor charge should be set up as named constants so that they can be easily modified if either changes. Current charges are $50 per hour for labor and 8 percent (.08) for the sales tax 
rate. Sales tax is charged only on parts, not on labor. 


The Clear menu item clears the text boxes and resets the focus in the first text box. 

The Exit menu item closes the Job Information form.

I need a Visual Basic Program that will produce a summary of the amounts due for Pat's Auto Repair Shop.  It needs to display a splash screen first; then display the main form, which has only the menus.  If you wish, you can add a graphic to the form but not necessary.  The job information menu item will display the Job Information form, for the user to enter the job number, customer name, amount charged for parts, and the hours of labor.  Include labels and text boxes for Parts, Labor, Subtotal, Sales Tax and Total.  Please include buttons for Calculate, Clear and OK.  The calculate button finds the charges and displays them in controls.  The tax rate and the hourly labor charge should be set up as named contstants so that they can be easily modified if either changes.  Current charges are $50 per hour for labor and 8 percent(.08) for the sales tax rate. Sales tax is charged only on parts, not on Labor.  The clear button should clear the text boxes and reset the focus in the first text box.  The OK button closes the Job Information form and displays the main form.  I have attached a Picture of what the form should look like.

Preview Screen Shots:

Splash form Screen

Main Form, with File Menus and Sub Menus

Process Job Information Form Calculation

• This tutorial was purchased 1 time and rated A+ by students like you.
• Posted on Apr 29, 2013 at 1:53:06PM 

Asked: $50

Email: syedjahangirb@gmail.com for downloading assignment

Files in Solution:

Vb.Net 2010 Express Auto Repair, Splash Screen, Clear Exit, Multiple Forms Background, Previews

Attachments:
PreviewSplashForm.jpg (52K)
FirstFormPreview.JPG (77K)
JobInformationPreview.JPG (43K)
Pats Auto Repair Shop.zip (1117K)
[ 
 Pats Auto Repair Shop/Pats Auto Repair Shop/AutoRepair.Designer.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/AutoRepair.resx
 Pats Auto Repair Shop/Pats Auto Repair Shop/AutoRepair.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/bin/Debug/Pats Auto Repair Shop.exe
 Pats Auto Repair Shop/Pats Auto Repair Shop/bin/Debug/Pats Auto Repair Shop.pdb
 Pats Auto Repair Shop/Pats Auto Repair Shop/bin/Debug/Pats Auto Repair Shop.vshost.exe
 Pats Auto Repair Shop/Pats Auto Repair Shop/bin/Debug/Pats Auto Repair Shop.vshost.exe.manifest
 Pats Auto Repair Shop/Pats Auto Repair Shop/bin/Debug/Pats Auto Repair Shop.xml
 Pats Auto Repair Shop/Pats Auto Repair Shop/bin/Release/Pats Auto Repair Shop.exe
 Pats Auto Repair Shop/Pats Auto Repair Shop/bin/Release/Pats Auto Repair Shop.pdb
 Pats Auto Repair Shop/Pats Auto Repair Shop/bin/Release/Pats Auto Repair Shop.xml
 Pats Auto Repair Shop/Pats Auto Repair Shop/Forms/DescriptionDefault.Designer.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/Forms/DescriptionDefault.resx
 Pats Auto Repair Shop/Pats Auto Repair Shop/Forms/DescriptionDefault.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/Forms/JobInformationvb.Designer.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/Forms/JobInformationvb.resx
 Pats Auto Repair Shop/Pats Auto Repair Shop/Forms/JobInformationvb.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/My Project/Application.Designer.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/My Project/Application.myapp
 Pats Auto Repair Shop/Pats Auto Repair Shop/My Project/AssemblyInfo.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/My Project/Resources.Designer.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/My Project/Resources.resx
 Pats Auto Repair Shop/Pats Auto Repair Shop/My Project/Settings.Designer.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/My Project/Settings.settings
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/DesignTimeResolveAssemblyReferences.cache
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/DesignTimeResolveAssemblyReferencesInput.cache
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats Auto Repair Shop.exe
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats Auto Repair Shop.pdb
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats Auto Repair Shop.vbproj.FileListAbsolute.txt
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats Auto Repair Shop.vbproj.GenerateResource.Cache
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats Auto Repair Shop.xml
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats_Auto_Repair_Shop.AutoRepair.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats_Auto_Repair_Shop.DescriptionDefault.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats_Auto_Repair_Shop.JobInformationvb.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats_Auto_Repair_Shop.Resources.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/Pats_Auto_Repair_Shop.Welcome.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Debug/TempPE/My Project.Resources.Designer.vb.dll
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/DesignTimeResolveAssemblyReferencesInput.cache
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats Auto Repair Shop.exe
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats Auto Repair Shop.pdb
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats Auto Repair Shop.vbproj.FileListAbsolute.txt
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats Auto Repair Shop.vbproj.GenerateResource.Cache
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats Auto Repair Shop.xml
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats_Auto_Repair_Shop.AutoRepair.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats_Auto_Repair_Shop.DescriptionDefault.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats_Auto_Repair_Shop.JobInformationvb.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats_Auto_Repair_Shop.Resources.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/Pats_Auto_Repair_Shop.Welcome.resources
 Pats Auto Repair Shop/Pats Auto Repair Shop/obj/x86/Release/TempPE/My Project.Resources.Designer.vb.dll
 Pats Auto Repair Shop/Pats Auto Repair Shop/Pats Auto Repair Shop.vbproj
 Pats Auto Repair Shop/Pats Auto Repair Shop/Pats Auto Repair Shop.vbproj.user
 Pats Auto Repair Shop/Pats Auto Repair Shop/Resources/1102IMG00001.gif
 Pats Auto Repair Shop/Pats Auto Repair Shop/Resources/992-car_repair_spanner_PRVW.jpg
 Pats Auto Repair Shop/Pats Auto Repair Shop/Welcome.Designer.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop/Welcome.resx
 Pats Auto Repair Shop/Pats Auto Repair Shop/Welcome.vb
 Pats Auto Repair Shop/Pats Auto Repair Shop.sln
 Pats Auto Repair Shop/Pats Auto Repair Shop.suo
 Pats Auto Repair Shop/Preview/FirstFormPreview.JPG
 Pats Auto Repair Shop/Preview/JobInformationPreview.JPG
 Pats Auto Repair Shop/Preview/PreviewSplashForm.jpg
 ]

ABC Consulting Inc, SQL Script, ERD Preview, Primary Key, Indexes, References Foreign Keys, Constraints With Diagram.

Case Scenario

ABC Consulting Inc. is a software development company that develops custom software solutions for other companies. They need a database to maintain information about their customers, employees, and the projects that they are working on. The customer information would include the name of the company as well as the contact name, address information, and phone information.    A customer may have many projects going on at any point in time. The employee information would include the name of the employee and the skill(s) that the employee maintains. 

ABC employees have a variety of different skills such as Java, C++, SQL, PHP, etc.  An employee may be working on many projects at the same time. The project information would include a description of the project, the customer for whom the project is being done and the budget dollars that were estimated for the project. Each project is for one customer.

Some of the other goals that ABC wants to accomplish with their database include the following information:

• The employees who are currently working on a particular project.
• The projects that are under way for each customer.
• The skills that are maintained by each employee.

You are assigned to design a database for this project by creating the ER diagram and writing SQL script to generate a database for maintaining information about the company's customers, employees, and the on-going projects.

Preview files:

Preview SQL Server ERD

Asked: $30

Email: syedjahangirb@gmail.com

Solution Files Present

 PreviewERDSQLServer.JPG (92K) 
Tables_Preview_SQLServer.JPG (23K)
sweetpepper66.zip (83K)
[ 
 PreviewERDSQLServer.JPG
 Tables_Preview_SQLServer.JPG
 SQLScript_ERD_Drop_Create_Index_ForeignKey_Constraint.sql ]

Database Difference Between Union and Union All

Database Difference Between Union and Union All

What is Union?

What is Union Alternative?

Solution Preview:

Union and Union All Differences Benefits

Asked: $8

Email: syedjahangirb@gmail.com

Solution Files Present

Union_Alternative_Differences_Benefits.txt (2K) 

POS 355 weeks 4 assignment Oracle Failures in Distributed Transaction Systems

POS 355, week 4

Oracle Failures in Distributed Transaction Systems

Write a 3-page paper describing four types of failures that may occur in a distributed system. Specify which of these are also applicable to a centralized system. Choose two of the four failures and describe how you would isolate and fix each failure

Screen Shot (Preview) :

Differences between Centralized and Distributed Systems

Personal Experience Distributed Centralized Issues Fix and Resolutions - Notes 

• This tutorial was purchased 1 time and rated No Rating by students like you.
• Posted on Feb. 13, 2013 at 03:56:43AM

Asked: $15

Email: syedjahangirb@gmail.com

Solution Files Present

Distributed_centralized_issues_fix_resolutions.txt (2K) 

OLAP Sales Entity Relationship Diagram ERD OLAP DATABASE design to Monitor Sales By Product, Customer and Date, ERD and Preview

OLAP DATABASE design to Monitor Sales By Product, Customer and Date, ERD and Preview

OLAP SALES ERD

Click Below or Copy Link in Browser To Download!

http://www.askassignment.com/product/olap-database-design-monitor-sales-product-customer-date

$ 20

ON SALE

Regular price: $ 25

You Save: $ 5

 

 

This assignment requires you to develop an ER Diagram and design OLTP database that shows all tables (and attributes) and relationships based on the giving information and ER Diagram

Step 1: Please consider the ER Diagram for an OLTP database below:

Step 2: Develop an OLAP database design based on the following information:

Fact: Quantity and Price of each item sold

Granularity: All sales

Dimensions: Products, Customers, Dates

Step 3: Develop the ER Diagram that shows all tables (and attributes) and relationships.

Email at support@askassignment.com for complete solution

Attachments:

File Attachment 1:
[OLAP ERD for Sales.vsd]

File Attachment 2:
olap_product_customer_date_sales.zip[olap_product_customer_date_sales.vsd
olap_product_customer_date_sales.png]

 

SumOddEven Visual Basic Dot Net Solution

Visual basic Dot Net - Odd Even Integers

Open the SumOddEven Solution (SumOddEven Solution.sln) fi le con-tained in the VbReloaded2010\Chap06\SumOddEven Solution folder.  the application should allow the user to enter a series of integers. It then should display the sum of the odd integers and the sum of the even integers. Code the application. Use the InputBox function to get the input. Save the solution and then start the application. Test the application using the following integers: 45, 2, 34, 7, 55, 90, and 32.  e sum of the odd and even integers should be 107 and 158, respec-tively. Now test it again using the following integers: 5, 7, and 33. Close the solution

File Present in Complete Solution: 

Preview.jpg (57K) (Preview)
Solution.zip (73K)
[ 
 Solution/SumOddEven Project/bin/Debug/SumOddEven Project.exe
 Solution/SumOddEven Project/bin/Debug/SumOddEven Project.pdb
 Solution/SumOddEven Project/bin/Debug/SumOddEven Project.vshost.exe
 Solution/SumOddEven Project/bin/Debug/SumOddEven Project.vshost.exe.manifest
 Solution/SumOddEven Project/bin/Debug/SumOddEven Project.xml
 Solution/SumOddEven Project/InputForm.Designer.vb
 Solution/SumOddEven Project/InputForm.resx
 Solution/SumOddEven Project/InputForm.vb
 Solution/SumOddEven Project/Main Form.Designer.vb
 Solution/SumOddEven Project/Main Form.resx
 Solution/SumOddEven Project/Main Form.vb
 Solution/SumOddEven Project/My Project/Application.Designer.vb
 Solution/SumOddEven Project/My Project/Application.myapp
 Solution/SumOddEven Project/My Project/ApplicationEvents.vb
 Solution/SumOddEven Project/My Project/AssemblyInfo.vb
 Solution/SumOddEven Project/My Project/Resources.Designer.vb
 Solution/SumOddEven Project/My Project/Resources.resx
 Solution/SumOddEven Project/My Project/Settings.Designer.vb
 Solution/SumOddEven Project/My Project/Settings.settings
 Solution/SumOddEven Project/obj/Debug/DesignTimeResolveAssemblyReferences.cache
 Solution/SumOddEven Project/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache
 Solution/SumOddEven Project/obj/Debug/GenerateResource.read.1.tlog
 Solution/SumOddEven Project/obj/Debug/GenerateResource.write.1.tlog
 Solution/SumOddEven Project/obj/Debug/SumOddEven Project.exe
 Solution/SumOddEven Project/obj/Debug/SumOddEven Project.pdb
 Solution/SumOddEven Project/obj/Debug/SumOddEven Project.vbproj.FileListAbsolute.txt
 Solution/SumOddEven Project/obj/Debug/SumOddEven Project.xml
 Solution/SumOddEven Project/obj/Debug/SumOddEven_Project.InputForm.resources
 Solution/SumOddEven Project/obj/Debug/SumOddEven_Project.MainForm.resources
 Solution/SumOddEven Project/obj/Debug/SumOddEven_Project.Resources.resources
 Solution/SumOddEven Project/obj/Debug/TempPE/My Project.Resources.Designer.vb.dll
 Solution/SumOddEven Project/SumOddEven Project.vbproj
 Solution/SumOddEven Solution.sln
 Solution/SumOddEven Solution.suo
 ]

Chapter 6 screen shots

Sum Even and Odd Integers in Dot net

Email at syedjahangirb@gmail.com for solution 

Oracle Database Security User Creation and Table Space and Temp Allocation Quota, Multiple Addition

Database Security

1.  You were just hired as a new junior Oracle database administrator to assist a team of five senior database administrators. In your first week, you were handed the task of writing a script as a template for creating database users. The script is to prompt the administrator for a user name and password, and the script creates the user according to the following guidelines:
     a.  The default tablespace is TOOLS.
     b.  The temporary tablespace is TEMP_TOOL_GROUP.
     c.  The account is initially locked.
     d.  The user account will be assigned to the DEFAULT profile.
     e. The TOOLS tablespace has a 10 MB quota.


2.  Outline the steps to create a database user account.

3. What procedures would you follow if you were told that an employee was terminated?

Email at syedjahangirb@gmail.com for complete assignment

Price: $15.00

Files with Assignment:
Preview.jpg (21K) (Preview)
Details.txt (1K) (Preview)
CreateUser.zip (0K)
[ 
 CreateUser.sql
 ]

Database Security UserProfile Space OnlineDatabase Triggers Controls

A new dot-com company has decided to launch an affiliated Web site specifically for individuals interested in database issues. The main mission of the website is to provide a forum for database technical tips, issues, and scripts. The CIO and his technical team held a meeting to draft the requirements for the new Web Site and decided that it should include the following:

- Technical documents

- A forum where members can exchange ideas and share experiences

- Online access so that members can query or try the site’s technical examples and scripts.

- A tips section.

- Technical support for error messages

Immediately after the meeting, the newly appointed project manager asks you to implement security for the site. She mentions that the security of a public database is so important that the CIO himself outlined the security requirements, as follows:

- The online database will have 10 public host database accounts that allow multiple sessions.

- The password of a public host account must be reset to its original setting whenever disconnects or logoffs occur.

- The maximum duration for a session is 45 minutes.

- Allocations will be set on memory and CPU usage to make sure the database is not overloaded due to excessive burden caused by badly written queries.

- Storage for each public host account must be limited to 1 MB

- The public host accounts will have privileges to create the most common database objects.

- All newly created objects must be removed before logoff.

- The database must have the default human resources (HR) user account enabled. All other accounts will be removed. All public host accounts must be able to view the data owned by HR, but must not be allowed to modify the data or structure of the database objects.

- When a member logs onto the database, all session information, such as IP address, terminal, and user session information, must be recorded for future analysis.

You may add other security or auditing features, as long as you don’t overlook any of the requirements in this list.

You will need to submit responses to the questions including all the SQL scripts that you may have created. You also must provide screen shots of specific portions of the work you have done, especially the final results and some important intermediate steps.

To make a screen shot for Word, use the following steps:
* Have the image you want to copy visible on your computer screen.
* Simultaneously, hold down the Control (Ctrl), Alternate (Alt) and Print Screen (PrntScrn) keys on your keyboard.
* Go to an open Word Document
* Paste the image (either right click on your mouse and choose the Paste option, or simultaneously hold down the Control (Ctrl) and V keys.
* Resize the image by clicking and holding on one corner, then dragging the box size toward the center of the image (make sure the entire image is visible on a single page).

Preview of SQL Script, Database Security