Logged out
Access All our Essays in an Instant
Swap your work for FREE access, or pay £4.99 for instant access
Data Manipulation.
Member rating: No Rating | Words: | Submitted: Mon Oct 27 2003
Page Preview
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Data Manipulation The tables required in the system will be Customer, Products, Staff and salary. The individual fields in each table will be as follows: CUSTOMER (CustomerID, Surname, FirstName and customer address) PRODUCTS (ProductID, Title, Description, Type and Amount) STAFF (StaffID, Name, address and contact number) STAFF SALARY (wages per hour, hours per day and days per week) There will be two reports produced. To produce a report for the products purchased; a query will be run to combine the data from the customer table and the product table. The user will be able to specify the products bought by a customer with the entire amount calculated to give the customer benefits of getting more offers. The second report will print the amount of salary each staff earns per hour, hours/day and days/week. The user is asked to enter the StaffID and name to enter its database. Output The two reports should be able to be viewed...
Get instant access
- Instant, unlimited access to our documents in full
- Swap your work for free access, or pay £4.99
- To see the full version of this document and 149,430 others
