List, describe, and provide an example of each of the five
characteristics of high quality information
Business decisions are only as good as the
quality of the information used to make the decisions.
Characteristics
of high-quality information include:
Accuracy
(For example, correctly spelt names and values)
- Completeness
( (For example, complete information pertaining to an address, including street,
city, state, and zip code)
- Consistency
(Aggregate or summary information in agreement with detailed information. For example, all total fields equal the true
total of the individual fields)
-
Uniqueness
(Each entity is only represented once. For example, no duplicate customers)
-
Timeliness
(The information current with respect to the business)
Define the relationship between a database and a database
management system
One is data that is stored and one is the way
you interface with that data/way it is presented.
Database is the organized collection of data
while a database management system (DMS) is a group of programs that manipulate
the database, providing an interface between the database and its users and
other application programs. Finally a database administrator (DBA) is a skilled
professional who directs all activities related to an organization’s database
Describe the advantages an organisation can gain by using a
database
Database advantages from a business
perspective include:
- - Increased
flexibility
- - Increased
scalability and performance
- - Reduced
information redundancy
- - Increased
information integrity (quality)
- - Increased
information security
Define the fundamental concepts of the relational database model
-
Unique Records inform the database of which record you may be referring to.
-
Primary Keys ensure that each
record is unique in each table, one field can be established to be a Primary
Key field.
A Primary Key is a field that that will
contain no duplicates and no blank values.
While each column in this particular data set
has unique data, the field that will work best for us is the student ID. Many students will go to the same college,
have the same last name and possibly even share telephone numbers, but each
employee should have a unique student ID.
When there is not a unique field in your data
set, you can use an AutoNumber. Access can create incremented or random
AutoNumbers for your primary key.
Describe the benefits of a data-driven website
-Content management
-Development
-Future
expandability
-Minimizing
human error
-Cutting
production and update costs
-More
efficient
-Improved
stability
-Real
time info like stock levels & price changes
Static websites need constant html updating
compared to data driven sites that link back to a database that can be easily
updated.
If
you were a sales manager in multi national company, what are some reports you
would want to see?
Budgets and forecasts, sales performance of
each individual, sales performance divided by product, profit and loss
statements.
No comments:
Post a Comment