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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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