When would using a personal dbms make sense

Assignment Help Database Management System
Reference no: EM132536071

Assignment 1: Study Questions

1. Develop your own definition of software being certain to explain the key terms.

2. What are the primary functions of an operating system?

3. Which of the following are operating systems and which are applications: Microsoft Excel, Google Chrome, iTunes, Windows, Android, Angry Birds.

4. What is your favorite software application? What tasks does it help you accomplish?

5. How would you categorize the software that runs on mobile devices? Break down these apps into at least three basic categories and give an example of each.

6. What does an ERP system do?

7. What is open-source software? How does it differ from closed-source software? Give an example of each.

8. What does a software license grant to the purchaser of the software?

Exercise: 1. If you were running a small business with limited funds for information technology, would you consider using cloud computing? Find some web-based resources that support your decision.

Assignment 2: Study Questions:

1. What is the difference between data, information, and knowledge?

2. Explain in your own words how the data component relates to the hardware and software components of information systems.

3. What is the difference between quantitative data and qualitative data? In what situations could the number 42 be considered qualitative data?

4. What are the characteristics of a relational database?

5. When would using a personal DBMS make sense?

6. What is the difference between a spreadsheet and a database? List three differences between them.

7. Describe what the term normalization means.

8. Why is it important to define the data type of a field when designing a relational database?

9. Name a database you interact with frequently. What would some of the field names be?

10. What is metadata?

11. Name three advantages of using a data warehouse.

12. What is data mining?

13. In your own words, explain the difference between supervised learning and unsupervised learning. Give an example of each (not from the book).

Exercise: 1. Conduct some independent research on the process of business intelligence. Using at least two scholarly or practitioner sources, write a two-page paper giving examples of how business intelligence is being used.

Reference no: EM132536071

Questions Cloud

Establishing a security cultureusing given information : Review the section on Establishing a Security Culture. Review the methods to reduce the chances of a cyber threat noted in the textbook.
Calculate the cost per equivalent unit for in total : Total costs to be accounted for,Calculate the cost per equivalent unit for direct materials, direct labor, overhead, and in total. Showing your calculations.
Establishing base pay in international assignments : Evaluate the following methods for establishing base pay in international assignments: home country-based pay, headquarters-based pay,
Prepare the journal entries for ARO for the year ended : Vesting occurs if the CEO remains in employment with ARO for four years. Prepare the journal entries for ARO for the year ended 31 December 2019
When would using a personal dbms make sense : When would using a personal DBMS make sense? What is the difference between a spreadsheet and a database? List three differences between them.
Determine the fair value of the consideration : P's share price is $1.25. Determine the fair value of the consideration transferred on 1 January 2019 in accordance with IFRS 3 Business Combinations
How it is anticipated to benefit the organization : Explain why this opportunity/threat was selected, and how it is anticipated to benefit the organization.
Make a process costing journal entries : Prepare journal entries to record transactions 1 through 5. The Molding department requisitioned direct materials totaling $2,000 to be used in production.
Apqc process classification frameworks : Explain the purpose of the APQC Process Classification Frameworks and other frameworks such as the Supply Chain Council's SCOR Framework

Reviews

Write a Review

Database Management System Questions & Answers

  Compare a use case description and an activity diagram

Compare a use case description and an activity diagram. Devise a scenario in which you would use a case description, and devise a scenario in which you would.

  How frequently does each of the sales rep contact customers

How frequently does each of the sales rep contact their customers? Which potential customers are interested in buying HP Laser Jet 5000 Series Laser Printer?

  Create database for easydrive school of motoring

Create mission statements and mission objectives for database systems explained in the following case study EasyDrive School of Motoring. Also in mission objectives include 10 reports that the database system must support

  Explain the manner in which the phase would change

Using the same phase that you selected in Part 1 of this discussion, describe the manner in which the phase would change, based on the distribution of the organization and the associated distributed database design.

  Modify the structure of the payment table

PLUS also creates videos, animations, presentation packages, and slide shows-in short, anything of a visual nature that can be used in a judicial proceeding to make, clarify, or support a point.

  Explain the benefits and current trends of data warehousing

Explain the benefits and current trends of data warehousing and data mining. Outline the architecture, models and views used in the data warehouse.

  Under which conditions would each type of loop be more

there are 3 kinds of loops-for loop while loop and do while loop. under which circumstances would each kind of loop be

  Explain database models-hierarchical and relational

Explain each of three database models, hierarchical, relational, and object-oriented, and provide specific referenced example of each of these model types implemented in a functioning database

  Draw dependency diagram to show the functional dependencies

Draw a dependency diagram to show the functional dependencies that exist in relation and Decompose the Home Library relation into a set of 3NF relation

  Draw a dependency diagram

Draw a dependency diagram to show the functional dependencies in the relation. Create an ERD that represents your 3NF relations

  Make a select query with a calculated field for age

Make a select query with a calculated field for age,  to list only guests between 20 and 40 years of age! Make sure to enter a range of ages in your table so you have something to display.

  Write a term paper on the fasmi characteristics of olap

Write a term paper on the FASMI characteristics of OLAP. The write up should be between 6-8 pages, line spacing = 1½, printed on one side of the paper.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd