bis assignment 3

Question 1

Attribute

Answer 1

characteristic of an entity

Question 2

Entity

Answer 2

General of people, place or things(objects) in which the data is stored and maintained.

Question 3

Database

Answer 3

organized collection of data

Question 4

DBMS

Answer 4

groups of programs that manipulate the database, provide an interface between the database and its users and other applications.

Question 5

Hierarchy of data

Answer 5

bit, byte, characters, fields, records, databases and files.

Question 6

data centre

Answer 6

climate controlled buildings or set of buildings. Houses the data servers and the systems that deliver mission-critical information and services.

Question 7

important characteristics in selection DBMS

Answer 7

database size
database cost
concurrent user
performance
integration
vendor

Question 8

distributed systems

Answer 8

database in which data may be spread across several smaller databases via telecommunication

Question 9

data warehouse

Answer 9

database that holds information form many sources in the enterprise

Question 10

datamining

Answer 10

provide analysis tools that automate the discovery of patterns and relationships in a data warehouse

Question 11

front end

Answer 11

interact directly with people

Question 12

back end

Answer 12

interacts with application or other programs

Question 13

important things to consider when building a database

Answer 13

content : what data should be collected and at what cost
access : what data should be provided to which user and when
logical structure : how should data be arranged so that it makes sense to a given user
physical structure : where should data be physically allocated

Question 14

BI

Answer 14

involve gathering enough of the right information, in a timely manner and usable form analyzing it to have a positive impact of business strategy, tactics and operations.