Information Systems And Databases Flashcards

1
Q

Characteristics of Information systems

A

Organisation of data into Information

Analysis of Information to give knowledge

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the types of information systems

A

Transaction processing systems

Decision Support Systems

Expert systems

Managment information systems

Office automation systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a Database

A

A database is an organised collection of data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the four main advantages that Computer-based Databases have over non-computer databases

A

Easily edited

Large storage

Fast Retrieval

Display options

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

what are the four data structures of a database

A

File
Record
Field
Character

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

what are the two types of databases

A

Flat file databases and Relational databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the four different types of Keys

A

Single key

Composite key

Primary key

Secondary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

what is a key

A

Keys are fields that are used to sort and retrieve information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a single key

A

a single key is a field in which each item of data is unique

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

what is a composite key

A

a composite key or also known as a compound key is made by joining two or more fields together.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

what is a primary key

A

a primary key is a single key or compound key that must have a value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

what is a secondary key

A

a secondary key is a field that contains useful items of data often used in searches.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

what is a file

A

a file is a block of data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

what is a record

A

a record is a collection of facts about one specific entry in a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

what is a field

A

a field is a specific category of data in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

what is a character

A

a character is the smallest unit of data that people can use

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is a relational database

A

a relational database organises data using a series of related tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is a flat file database

A

a flat file database organises data into a single table and is suitable for many small applications.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is a schema

A

A schema is the data definition for a database. it is an organised plan of the entire database that shows how and where the data is found, descriptions of the data, and the data’s logical relationships. In relational databases schemas define the entities, attributes and relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

what are the three things that Schema’s define in a relational database

A

entities

attributes

relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

what is an entity

A

an entity is a specific thing about which information is collected and stored. In a flat file database there would be a separate file for each entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

what is an attribute

A

an attribute is a defined property of an entity, examples would include LastName, FirstName and PhoneNumber.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is a relationship

A

a relationship is the way the entities are related to each other, in relational databases each entity are related using keys.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

what are the four types of relationships

A

one-one

one-to-many

many-to-one

many-to-many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

what is a one-to-one relationship

A

a one-to-one relationship occurs when each record in the first entity is related to exactly one record in the second entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

what is one-to-many or many-to-one relationship

A

a one-to-many relationship occurs when one record in the first entity is related to many records in the entity, but any record in the second entity relates to only on record in the first entity. Vice versa for many-to-one relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

what is a many-to-many relationship

A

a many-to-many relationship occurs when each record in the first entity is related to many records in the second entity, and each record in the second entity is related to many records in the first entity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

what is a foreign key

A

a foreign key is an attribute(field) of a table that is a primary key of another table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

what is a table in a database

A

a table is the organisation of data into columns and rows, it is sometimes reffered to as a relation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

what is a row in a table also known as

A

tuple of an entity or one record.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

what is a form

A

a form is used to view, enter, and change data in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

what is data modelling

A

data modelling is the process of identifying entities, the relationships between those entities and the attributes of those entities. They are used to develop a schema for the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

what are the three main tools used for data modelling

A

data dictionaries

schematic diagrams

normalisation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

what are data dictionaries

A

a data dictionary is a comprehensive description of each field (attribute) in the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

what are the characteristics of each item in a database

A

field name

field size

data type

field description

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

what is a field name

A

a field name is the name of the field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

what is a data type

A

a data type (or field type) is the kind of data that can be stored in the field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

what is the field size

A

field size or width is the number of characters allowed in each field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

what is a description in a data dictionary

A

description specifies the contents of a field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

what is meta data

A

it is information about data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

what is data redudancy

A

data redudancy is the undersiable duplication of data within a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

what is a Schematic diagram

A

Schematic diagrams are graphical tools that help define the database and develop a schema. A common schematic diagram is an entity-relationship diagram.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

What is an Entity-relationship diagram (ERD)

A

an Entity-relationship diagram is a graphical method of identifying the entities and showing the relationship between them. It helps determine the data to be included in and excluded from the databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

what is normalisation

A

Normalisation is the process of organising data into tables so that the results of using the database are unambiguous and as intended. It is a refinement process that aims to reduce data redundancy. Normalisation results in a database that is more efficent but more complex because the data is separated into more tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

what are the degrees of normalisation

A

first Norm Form (1NF)

Domain/key normal form (DKNF)

45
Q

what is first norm form

A

First norm form is moving data items into separate tables where the data in each table is a similar type. Each table is given a primary key.

46
Q

What is a Domain/key normal form

A

A domain/key Normal form is a key uniquely identifies each row in a table. A domain is the set of permissible values for each attribute. This enforces key and domain restrictions to ensure that there are no problems when modifying the data base. DKNF is the final level of normalisation

47
Q

what is Hypermedia

A

Hypermedia is a combination of media whose locations are linked electronically to provide an easy way to navigate between the information.

48
Q

what is Hypertext

A

Hypertext is a system that allows documents to be cross-linked in such a way that the user can move from one document to another by clicking on a link

49
Q

what is a link or hyperlink

A

a Link or hyperlink is indicated by a highlighted item (usually an under-lined word or a graphic) that allows an electronic connection.

50
Q

what is a node

A

if another computer is the destination of the link that computer is what is known as a node.

51
Q

What is a Uniform resource locator

A

A URL (Uniform resource locator) is the address of a file or resource on the Web. It is usually written in lower case, as a single unbroken line with no spaces.

52
Q

what are the main parts of a URL

A

Protocol

Domain name

file path

53
Q

what is a protocol in a URL

A

a protocol is the transfer method used to access a particular resource on the Web. In most casses the protocol will be ‘http://’ (hypertext transfer protocol)

54
Q

what is a domain name

A

a domain name is the address of the specific computer where the resource is located such as ‘www.hi.com.au’ they can somtimes be replaced by the IP address.

55
Q

what is a file path

A

a file path is the full path to the file to be retrieved. it may be a simple filename or it may be a directory path such as ‘atlas/about.htm’. The domain name and the file path are separated by a forward slash (/)

56
Q

what is a Storyboard

A

a storyboard is a series of frames, each representing a different action or screen image. It is a tool used to organise hypermedia.

57
Q

What are the four types of storyboard layouts

A

linear

hiearchical

non-linear

combination

58
Q

what is a linear storyboard

A

a simple sequential path that is set up quickly

59
Q

what is a hierarchical storyboard

A

a sequential path in a top-down design

60
Q

what is a non-linear storyboard

A

it is a storyboard with no structure

61
Q

what is a combination storyboard

A

it is the blending of the other types of storyboards

62
Q

what is HTML

A

HTML is a set of special instructions that indicate how parts of a document will be displayed and navigated

63
Q

what is an HTML editor

A

an HTML editor is a software program that specialises in writing HTML code

64
Q

are HTML tags meta data

A

yes

65
Q

how do you write HTML tags

A

a tag consists of a left angle bracket (<) a tag name and a right angle bracket (>)

the tags are usually paired for example <H1> and </H1> which indicates the start and and end of the instruction

the end tages are written similar to the start tage except with a slash (/) that precedes the text within the bracjets.

to write a hypertext-related tag it is <a> (which stands for the anchor) then a special instruction using HREF = ‘filename’ then (>) technology </a>

66
Q

what is a database management system (DBMS)

A

a Database management system is a software package that allows users to access a database so they can enter, maintain and view the data.

67
Q

what is the difference between a database and DBMS

A

a database contains the data whereas a DBMS provides access to the data.

68
Q

how is data organised in a DBMS

A

In a DBMS data is organised into tables, viewed in forms, retrieved using queries and displayed in reports

69
Q

how is data manipulated in a DBMS

A

a DBMS manipulates the data in many different ways such as sorting and searching

70
Q

How can a DMBS help users to develop and maintain a database

A

organising the data using a data dictionary

showing relationships between entities using a schematic diagram

checking for identifable errors in a data entry

allowing flexibility to change the definition of the database

restricting access to the data to authorised people

providing information about the performance of the database.

71
Q

what are the methods of acessing data

A

Sequential and direct access

72
Q

what is sequential access

A

Sequential access occurs when data is accessed in a sequence. It is the only method used to access data stored on a magnetic tape. This method reads the beggining of the data until the required item is found. It does not require the exact location of the data item and is much slower than direct access and is impractical when immediate processing is required.

73
Q

what is a direct access

A

Direct access occurs when data is accessed without accessing previous data items. Direct access uses the algorithim for where the data is stored to calculate the approximate location of the data, if it is not found at the location it continues searching until the desired data is accessed. Direct access often involves the use of an index which is called indexed access

74
Q

what is index

A

an index is a table that contains information about the location of the data.

75
Q

what is a distributed database

A

a distributed database is a database located at more than one site. It acts as a single collection of data but is geographicalled dispersed. Distrbuted databases reduce the data transmission costs however it makes it more more difficult to obtain a complete view fo the database.

76
Q

what is a two phase commit

A

it is part of the DBMS used to maintain consistency across a distributed database

77
Q

What is the difference between Online storage and offline storage

A

Online storage uses a peripher device that is under the user’s direct control, such as a hard disk on a personal computer. Where as Offline storage uses a peripheral device that is not under the user’s direct control such as a centralised database.

78
Q

what are some peripheral storage devices and mediums

A

Hard disk

optical disc

Removeable cartridge

magnetic tape

79
Q

what is a hard disk

A

a disk made of metal or glass and covered with magentic material. they are usually set up inside the computer’s case and the storage capcity is usually measured in GB. It uses direct access to retrieve data

80
Q

what is an optical disk

A

a polycarbonate plastic disk with a reflective layer of metal covering the surface. Data is read and written using laser technology. Optical discs use direct acess to retrieve data.

types of otpical disks are CD-Rom and DVD

81
Q

what is a removable cartridge

A

a hard disk encased in a metal or plastic cartridge and can be removed like a floppy disk. They are fast and used direct access.

two common types of removable cartridges are zip disks or jaz disks

82
Q

what is a magnetic tape

A

a magnetic tape is a very long, thin strip of plastic coated with a thin layer of magnetic material. Magnetic tapes can store large quantities of data cheaply and are often used as a back up medium. They use sequential access to retrieve data.

83
Q

What is Encryption

A

Encryption is the process of encoding code and decryption is the proces of changing it back (decoding). It is the most effective way to achieve data security durring the transmission of data.

84
Q

what are the two main types of encryption

A

Asymmetric encryption

Symmetric encryption

85
Q

what is the difference between Asymmetric encryption and Symmetric encryption

A

Asymmetric requires a key for encryption and a key for decription whereas Symmetric encryption requires the same key for both the encryption and decryption.

86
Q

what is a back up

A

a back up is another copy of the data that can be used to rebuild the system

87
Q

What are the three line of defenses in Data security

A

password

Firewall

Encryption

88
Q

what are the two main methods of Sorting

A

Ascending: order from smallest to largest (0 to 9) or first to last (A to Z)

Descending: order from largest to smallest (9 to 0) or from last to first (Z to A)

89
Q

what is a Query

A

a Query is a search of a database for records that meet a certain condition (it is a question you ask of the database)

90
Q

what are the types of operators in a Search query

A

relational operators

Wildcard characters

logical operators

91
Q

what is the difference between relational operators and wildcard characters

A

relational operators are characters or symbols indicating the relationship between two experessions. Examples relational operators are (=, <>, <, >, <=, >=)

wildcard characters represent one or more characters (? or *)

92
Q

what is the difference between the ? and * wildcard characters

A

the * (asterisks) substitutes for any number of characters wheras the question mark (?) substitues for one character.

93
Q

what is the difference between AND and OR operators

A

The AND operator requires both the first and the second query to be true whereas OR oeprators require either the first or second query to be true

94
Q

what is SQL

A

Structured Query Language is a query language used to access and manipulate data in a relational database.

95
Q

what is a query language

A

a specialised language to search a database.

96
Q

what is a search engine

A

A search engine is a database of indexed Web sites that allow a keyword search.

97
Q

what are directories

A

directories are lists of websites organised into categories such as computers, games or sport.

98
Q

what is a search robot or spider

A

a search robot is a program that accesses web sites and gathers information for search engine indexes. They send back the URL of any document they find on the search engine’s indexing software and collects information such as titles and keyword from websites, and then indexes these words in a database.

99
Q

what is a report

A

a report is the formatted and organised presentation of data. they are often based on a query.

100
Q

what is the layout of a report

A

report header: appears once at the beginning of a report such as logo, report title and date.

page header: displays information such as a title, column heading or information needed at the top of every page.

details: section displays most of the information.

page footer: displays information such as the date, page number or any other information the user wants at the bottom of every page.

report footer: appears once at the end of the report

101
Q

what are good design principles in a report

A
  • headings that identify the purpose of the report
  • layouts, such as tabular or column, that efficiently present the information
  • text that is balanced on the page either vertically or horizontally
  • styles that are consistent throughout the report and with its purpose
  • columns that have clear and descriptive headings
  • white space that is appropriately used to improve readability
  • page numbers and the date included in the header or footer
102
Q

what is a data source

A

the source of the data is the person or organisation that developed the data.

103
Q

what is the accuracy of data

A

the accuracy of data is the extent to which it is free from errors

104
Q

what is data validation

A

data validation is the check of the entry of data.

105
Q

what are the types of data validation checks

A

Range check: is used if the data is restricted to a small range of particuar values

List check: is used when the data can be compared to a set of accepted data

Type check: is used to determine whether the data type is correct.

Check digit; is a digit calculated from the digits of code number and then added to that number as an extra digit.

106
Q

what is data intergrity

A

Data integrity describes the reliability of the data. Reliable data is accurate, current and relevant.

107
Q

what is privacy

A

the ability of an individual to control personal data.

108
Q

what is a data warehouse

A

a database that collects information from different data sources. it is a storage area of raw data that can be analysed to assist organisations to make decisions. The contents of data warehouse are usually historical and static.

109
Q

what is data mining

A

Data mining is a process that looks for relationships and patterns in the data stored in a database. It sorts through the data and turns up interesting and useful connections.