The objective of this assignment is to measure your ability to construct queries based on given questions, and research knowledge management systems using the internet. First, please run queries using Access, and attach the screenshots of your queries and query results in Word. Second, search a widely used knowledge management systems in the marketplace, and describe how specific knowledge management systems helps achieve knowledge management. Please name your file as “your name_studentID_Access_hw” in Word.
Grading Policy (QM 3.2)
There are total 50 points allocated in this project. 25 points are allocated to “Prepare queries” and the remaining 25 points are allocated to “Research knowledge management system”.
Prepare queries
You will lose 5 points when you fail each guideline described as follows.
|
Guideline |
Description |
Points Deduction |
|
1 |
Query design view is not included as a screenshot per question (a, b, c, and d). |
5 |
|
2 |
Query result view is not included as a screenshot per question (a, b, c, and d). |
5 |
|
3 |
Answered with quantity rather than dollar values vice versa (How many-> number; What is the total sales->$) |
5 |
|
4 |
Query results are incorrect (i.e., query result shall be one line; students’ answered query results are multiple lines) |
5 |
|
5 |
Tried to input designs and query, but resulted different answers, which are suspicious results. Please do not copy and paste someone else’s work. |
5 |
Research knowledge management system
You will lose 5 points when you fail each guideline described as follows.
|
Guideline |
Description |
Points Deduction |
|
1 |
There is no citation of the specific website, and less than 1 page, double-spaced, 12 font-size. |
5 |
|
2 |
There is no description of specific knowledge management system in your own word. No plagiarism is allowed. |
5 |
|
3 |
There is no description of what the knowledge management system is. |
5 |
|
4 |
There is no description of why the knowledge management system is important. |
5 |
|
5 |
There is no description of how the knowledge management system is helpful to specific users. |
5 |
Prepare queries
Question:
Use the database, ‘Chapter 4 Relational Database’, and construct queries to answer the following questions. Please show the screenshots of queries and query results respectively.
- How many different kinds of inventory items does the Company sell?
- How many sales were made during October?
- What were total sales in October?
- What are total sales by salesperson?
Research knowledge management system
Question: Use the Internet to research knowledge management systems. Specifically, 1) find one example of a knowledge management system, 2) identify the provider or vendor, 3) provide the Web site URL, and 4) list the features of the system found that help an organization manage its knowledge. Write up your findings. Everyone’s answer shall vary. The number of pages shall be minimum 1 page double-spaced, 12 font-size.
0 comments