1 / 6

Unit 1 Online World

Unit 1 Online World. Data Storage. Database structure. 1 What is a database system? . Answer 1 a database is a system for managing a collection of data. 2 How is data stored in a database?. Answer 2 data bases are stored in tables.

grazia
Download Presentation

Unit 1 Online World

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Unit 1 Online World Data Storage

  2. Database structure 1 What is a database system? Answer 1 a database is a system for managing a collection of data. 2 How is data stored in a database? Answer 2 data bases are stored in tables 3-6 Give brief descriptions of different four types of data Answer 3 time: a sequence of numbers, letters or symbols Answer 4 number: represents a numerical value. Answer 5 date/time: stores a combination of dates and times Answer 6 logical: represents the data as true and false

  3. Database structure 7-8 Describe the part played by a primary key and a foreign key in a database Answer 7 the primary key is the key used to organise and sort data. It is the unique identifier of each record in each table. Answer 8 a foreign key is a piece of data which is not meant to be in another table. 9\ Use a simple diagram to show the relationship between database tables 9Diagram below

  4. Online databases 10 -11 What is an online database and what are the main advantages of using oneline databases? Answer 10 an online data base is a data base that can be accessed using a network. Answer 11 an advantages of online data bases is that you can check to see if the products in stock and you can buy lots of different products. 12-15 What does DBMS, SQL, DDL and DML file stand for? Answer 12 DBMS: Database Manager System Answer 13 SQL: Structured Query Language Answer 14 DDL: Data Definition Language Answer 15 DML: Data Manipulation Language

  5. Threats to data 16-20 Describe each of the following threats to data: opportunist, computer viruses, malware, phishing and accidental damage Answer 16 Opportunists: People who damage files and documents, with computers which are left logged on by the user. Answer1 7 computer viruses: These are programmes which harm the computer and spread viruses. They harm the computer via e-mails and files. Answer 18 malware: malware is a intrusive or annoying piece of software or programming code which harms the computer. Answer 19 phishing: this tries to gain access to passwords, financial details and other info. Answer20 accidental damage: this is damage caused by floods or storms or mishap.

  6. Threats to data 21-24 Discuss four ways an organisation can be affected after data loss take places Answer 21 reputation people will be put of using the organisation as they won’t feel safe. Answer 22 secrets this will be bad as then the competition will find out if the companies making any new products. Answer 23 identity theft this will be a problem when trying to get loans ect. Answer 24 legal problems then the company will lose there costumers as they wont feel safe any more.

More Related