100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
INSY 3304 Midterm Review Questions and Answers $11.49   Add to cart

Exam (elaborations)

INSY 3304 Midterm Review Questions and Answers

 0 view  0 purchase
  • Course
  • Practice Tests 2024
  • Institution
  • Practice Tests 2024

INSY 3304 Midterm Review Questions and Answers Components of a Database System - ANSWER-People Hardware Software Procedure Data Functions of a DBMS - ANSWER-Indexing Views Security Integrity Concurrency Backup/Recovery ©EMILLECT 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBL...

[Show more]

Preview 3 out of 17  pages

  • October 30, 2024
  • 17
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Practice Tests 2024
  • Practice Tests 2024
avatar-seller
Emillect
©EMILLECT 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED

FIRST PUBLISH OCTOBER 2024




INSY 3304 Midterm Review Questions and

Answers


Components of a Database System - ANSWER✔✔-People


Hardware


Software


Procedure


Data


Functions of a DBMS - ANSWER✔✔-Indexing


Views


Security


Integrity


Concurrency


Backup/Recovery


Page 1/17

, ©EMILLECT 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED

FIRST PUBLISH OCTOBER 2024




Design


Documentation


Update/Query


The different types of Database Systems (users) - ANSWER✔✔-Desktop Database - one user




Multiple user database - a.k.a. Workgroup database has 50 or less




Enterprise - More than 50 users


The different types of Database systems (Locations) - ANSWER✔✔-Centralized Database - which

supports data located on a single site




Distributed database - data stored on multiple locations


Database models


-Types - ANSWER✔✔-Type and Extent of Use - Operational Database - day to day data transactions,

accounting, production, inventory transactions, sales transactions, payroll, and POS systems


Page 2/17

, ©EMILLECT 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED

FIRST PUBLISH OCTOBER 2024




Decision Support - Stored in data warehouses stores data used fir statistically like 5 yr sales data.




XML- (Extensive Markup Language) data element in textual format provides a semistructured data create

our own tags, ie last name tags to a customer, but diff to html is that we can customize the tags


Database model Structures - ANSWER✔✔-Unstructured Data - having data stored on multiple locations




Structured Data -data resulting from formatting or processing data to give it structure




Semistructured - data processed to some extent


Database model Advantages, and Disadvantages - ANSWER✔✔-improve data sharing, multiple users,

data security, Data Integration, minimizes data inconsistency




Disadvantages - Complexity, cost, security, compatibility


Basic concepts about the relational database model


Page 3/17

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Emillect. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $11.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

82191 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$11.49
  • (0)
  Add to cart