Exam 1 (ITSS 4301) || with 100% Accurate Solutions.
4 views 0 purchase
Course
ITSS
Institution
ITSS
database correct answers is a collection of data that is organized so that it can easily be accessed, managed, and updated
Database (expanded) correct answers The purpose of ________ is to keep track of things (e.g. airline reservations)
- Unlike a spreadsheet or list, a ________ may store in...
Exam 1 (ITSS 4301) || with 100% Accurate Solutions.
database correct answers is a collection of data that is organized so that it can easily be accessed,
managed, and updated
Database (expanded) correct answers The purpose of ________ is to keep track of things (e.g.
airline reservations)
- Unlike a spreadsheet or list, a ________ may store information that is more complicated
than a simple listing (e.g. airline reservations)
- It does this by storing not just the data, but also relationships (which we'll cover later)
- Allows business questions (queries) to be answered
- Created/managed by specialized database software
- ...are optimized to scan large amounts of data
• Millions of rows of data are easy to handle
- ...are designed to handle many (some support thousands) of users
at a time
- ...have built-in data integrity
• E.g. Disallow adding a flight segment if the airport city doesn't exist; can log changes made
- ...have sophisticated, granular secure access mechanisms
Databases vs Excel correct answers A ____(1)____ provides much of the same functionality as a
_______(2)______, but is designed to handle certain data situations beyond what a spreadsheet
can do
answer (1) characteristics:
- ...are optimized to scan large amounts of data
• Millions of rows of data are easy to handle
- ...are designed to handle many (some support thousands) of users
at a time
- ...have built-in data integrity
• E.g. Disallow adding a flight segment if the airport city doesn't exist; can log changes made
- ...have sophisticated, granular secure access mechanisms
Workbook correct answers is a collection of worksheets the same way that a database is a
collection of tables
Query correct answers is a structured statement used to extract data from a database
-can locate
,information stored ACROSS MULTIPLE TABLES
Flat data correct answers This kind of data resides in a single table
Relational Databases correct answers __________ data exists in multiple tables; Focus is on
connecting uniquely "themed" tables
physically store data in separate table
Once you relate separate tables, you've created a relational structure
Theme Characteristic correct answers - A __________ is some identifiable thing that users want
to track
- Keeps data well organized
- Easy to modify the data
- Easy to modify the database structure - Avoids redundant data
Primary keys correct answers ____________ keys ensure all records in a table are unique
- Student ID is a good example
foreign key correct answers A _____________ key is just a field that has been identified as able
to function as a connection point for the primary
SQL (Structured Query Language) correct answers ___________ is an international standard for
creating, processing, and querying databases and their tables.
• Many databases use this to retrieve, format, report, insert, delete, and/or modify data for users.
Database Components correct answers The following are:
- Users
- Database Application
- Database Management System (DBMS) - Database
user correct answers A __________ of a database system will:
- Use a database application to track things
- Use forms to enter, read, delete, and query data
- Produce reports
, database application correct answers A _______________ is a set of one or more
computer programs that serves as an intermediary between the user and the DBMS.
These read or modify database data by sending SQL statements to the DBMS
They also present data to the user in the format of forms and reports
Database Application Functions correct answers -Create and process forms
-Process user queries
-Create and process reports
-Execute applicaiton reports
-Execute application logic
-Control application
DBMS (Database Management System) correct answers _____________ serves as an
intermediary between database applications and the database.
• manages and controls database activities.
• creates, processes, and administers the databases it controls.
DBMS correct answers ____________ performs the following functions/roles
-Creates DB
-creates tables
-Creates supporting structures (indexes)
-Reads db data
-Modify db data (insert, update, delete)
DBMS correct answers The key role of this is to organize the data through the metadata
structure. You cant load any data until a metadata structure in the firs place
Referential Integrity (Constraints) correct answers ________________(s) ensure that the values
of a column in one table are valid based on the values in another table.
- For example, if a 5 was entered as a CustomerID in the PROJECT table, a customer having a
CustomerID value of 5 must exist in the CUSTOMER table.
Database Elements correct answers These are:
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.19. You're not tied to anything after your purchase.
