HND计算机大二·

1、D85F34: Using Software Applications Packages andD75X34: Information Technology: Application Software 1 Business 6 Qi Ji(a) Products Discontinued 2009-5-11(b) Current Products(c) Suppliers of British, French and German(d) Owner of the firm （e）Sales StaffActivity 2(a) Our customers expect Finland IF A

2、PPROPRIATE INSERT A CONTENTS PAGE HERE(b) Units price increase by 1%(c) Staff salary increase by 2%The Database of USAPITASThis is called the database. The computer database relies on the data which saves in the software organization. This software is called the database management system (DBMS). Da

3、tabase management system's classification defers to the database model, their support. This model often by determines the query language, may visit the database. Massive internal project database management system, but, the independence in the data model, and involve the management factor, if th

4、e performance, the concurrency, the integrity and restores the hardware fault. Has the very big difference product in these domains. The database is very important and a beneficial company.Content Page1. Introduction 32. An explanation of what databases are and how they work .33. An explanation of t

5、he general benefits of using databases .54. Conclusion .65. Bibliographies 7INTRODUCTION1. Insert a statement explaining the objectives or purpose of the report here.This report's goal is the use existing database provides for produces some inquiries and repots. Then in the report, I will analyz

6、e the finance operational practice USAPITAS. Next year's report will provide a communication staff; the communication will also contain the staff development and the training information. Finally, some table suggested that the suitable application software satisfies USAPITAS to determine Campbel

7、l Mr. in some examples.The USAPITAS Limited Company is food and the drink supplier. This company purchases each kind of different specialized drink and food from the world. At present, this company involves reaches 29 different suppliers from the world. The USAPITAS purchase does not surpass 70 diff

8、erent products gives 24 different companies from these suppliers and the sell in 10 different countries.At present, who some are USAPITAS experiencing the constitutive change and Campbell Mr. is an Chief Sales Officer, seeks realizes the efficiency enhancement in this local sales volume in this orga

9、nization. Campbell Mr. hoped increases client base USAPITAS. At first, this will include the self-criticism present country, this company's transaction, but should cause finally to expand to other countries.2. An explanation of what databases are and how they work. Use USAPITAS 2.mdb to illustra

10、te the structure of this database. Explain the relationships between tables in this database and highlight the benefits of setting up such structures.The database definition is the structure collection related data or many subjects. In the daily life, the database which we usually frequently use, if

11、 seeks for a telephone number the telephone table of contents or the use communication book.This data set has many characteristics: The construction of data is the independence uses it in the application procedure, by the data, deletes, the change and the retrieval global administration and control

12、software from the historical development, this database is a data management higher phase, it is by the document management system's development. The basic structure database divides into three levels, had reflected the observation angle looks at three kind of different databases.(1) Physical da

13、ta level. It is the database most inner layer is the data collection which on the actual physics storage device saves. These data are the primary data, the processing user object, describes internal model, digital order string of character processing, constitution character and word.(2) It is the in

14、termediate level database is a database overall logic. Had pointed out between logical definition's each data and the data logical relation is a fair store up the record. This is in a database all object logical relation, but is not its actual situation is, according to concept, database adminis

15、trator database.(3) Logical data level. This is the user sees and the use database, or some user specific data set, namely collection logical record. Between the databases relation, carries on the transformation through the different level's map.It works like this: First, turns on the database t

16、hen shift key to press down. then, opens any motion automatically, you will see the database window. From there, you may open any form and the module in the design view and the assembly code. You may eliminate gradually reason. The copy hindrance from, deletes all codes, and will have a look to have

17、 anything, if you will open it. is final, the increase code domain's domain, found that the problem and eliminates itArab League many to relations are possibly a customer, many addresses, said the mail, the settlement and the shipping. The employee and the employee person mathematical table poss

18、ibly represent the one-to-one relations. But is not uses Mary Boudreaux each place you to determine her, she assigns employee population. Mary is in the skin raft department. Her number is C75.Finally, but also more than to many relations. All staff's Working committee. Has the sales table claus

19、e. Each project involves an employee's employee table. Has mark each X, by peptide Y relations.3. Insert an explanation of the general benefits of using databases. Expand upon these benefits by using examples within USAPITAS LTD. Advantage DBMS is as follows: A true database management system co

20、mpares has certain merit file processing. flexibility: Because the procedure and the data are independent, does not have when the plan makes the revision, the type irrelevant data increases or the deletion from the database, or, when physics saves change. rapid reaction information requirement: Beca

21、use the data integrates to a sole database, the complex request may process rapidly then, if the data is in the different lactic acid, non-comprehensive document. In many enterprises, quicker response method better customer service.Between the databases relation, carries on the transformation throug

22、h the different level's map. Below the database has the main feature: (1) Data sharing(2) To reduce data redundancy.(3) Data independence.(4) Centralized control of data.May reduce the redundancy using the database the data, thus saves the data storage space greatly; realizes the data sharing re

23、sources fully. In addition, the data bank technology provided the tool which for the user was simple and easy to use to enable the user to compile the database application procedure. The database through the database management system softwares data storage, the management and the use is the damsel

24、database management system software.4 Insert a conclusion to your report here.This company uses the database, has collected some data and analysis some information. The database is the very beneficial use, it is an important tool, and in office daily through this point, essential part our research.

25、It has many merits. For example, the information may the tap water and the notebook also facilitates at any time, very easily to investigate. Many people have the opportunity in the same time; Object database memory mechanism. Through this report, this company may understand how to use this database

26、. The existing data origin, this company may use the Internet well in each domain company. May with ease operate the database according to this report's anybody.5. BibliographiesInsert details of any books, newspapers, journals or websites referred to in your report./wiki/D

27、atabaseThe cash figures about USAPITAS.Last YearThis Year£000£000Sales11,67414,228Cost of Sales4,6745,990Administrative Costs4,5055,023Distribution costs1,0791,550Interest Payable234234Dividends390380Retained Profit b/f430Land and Buildings2,8002,800Office Equipment190340Motor Vehicles1,06

28、41,175Fixtures and Fittings2735Stock608902Creditors544450Debtors306705Taxation287295Bank2810Bank Overdraft01115% Debentures1,5601,560Share Capital1,9501,950Profit and loss AccountLast yearThis year000000000000sales11,67414,228Less cost of sales4,6745,990Gross Profit7,0008,238Less ExpenseAdministrati

29、ve Costs4,5055,023Distribution Costs1,0791,550Net Profit before Interest and Taxation1,4161,665Interest Payable234234Net Profit before Taxation1,1821,431Less Corporation Tax287295Net profit after taxation8951,136Add Retained Profit B/F430935Net Profit After Taxation1,3252,071Less AppropriationDivide

30、nds390380Retained Profit C/F9351,691Balance SheetLast YearThis Year000000000000Fixed AssetsLand and Building2,8002,800Office Equipment190340Motor Vehicles1,0641,175Fixtures and Fittings274,081354,350Current AssetsDebtors306705Stock608902Bank281119501,607Less Current LiabilitiesCreditors544450Taxatio

31、n287295Bank overdraft083111756Net Current assets364851Net worth4,4455,201Financed ByShare Capital1,9501,950Inappropriate Profit9351,691Ordinary Shareholders Equity2,8853,64115% Debentures1,5601,5604,4455,201Section 1: The newsletter about the awareness of the internetSection 2The newsletter about the staff development in USAPITASTask 2: Part 4 Activity 1RecommendationsDepartmentTaskType of softwareSuggested productOpinion and reasonPers