Exam (elaborations)
WGU D322 - Introduction to IT Section 6_ DatA WITH 100- SURE ANSWERS
- Course
- Institution
WGU D322 - Introduction to IT Section 6_ DatA WITH 100- SURE ANSWERS
[Show more]
Seller
Follow
Content preview
10/5/24, 7:19 AMEUNICE
WGU D322 - Introduction to IT Section 6: Data WITH 100%
SURE ANSWERS
Terms in this set (43)
Flat File,
Hierarchical,
Common Database Models
Relational,
Object Oriented
integrate the information stored and database systems
maintained by an organization
Refers to the whole set of activities that ensure all databases are highly available,
Database Administration
secure, scalable.
Multi-dimensional, allowing information to be accessed from various views through
Relational Database
internal linking between entries.
One dimensional: present information from a single point of view and dont interact
Traditional Flat File
with other files
Act of analyzing and converting data into information that can be used in decision-
Database Research
making.
Underlying technology that supports much of the World Wide Web. Websites
interface between clients and databases, responding to client requests. Web servers
Database system
search a database, organize the results in a web page and send that page to the
client
Two Database Application layers application layers and a database management layer
communicates with the end user and can application layer
be fairly complex. For example, when end
users access a database through a website,
the application layer consists of programs
and services within a server that queries the
database on behalf of the client.
1/5
, 10/5/24, 7:19 AM
It is like an OS in that it supports the application software and the data. Serves as an
interface between an end-user and a database, allowing users to create, read,
Database Management System (DBMS) update, and delete data in the database. DBMS manages the data, the database
engine, and the database schema, allowing for data to be manipulated or extracted
by users and other programs.
composed of records and fields that hold database table
data. For more information, do a bit of
research on such benefits and weaknesses
of Microsoft Access.
A database does not directly manipulate the data. After the application software
Application Layer receives a request from a user, it uses data management system (DBMS) as tool to
obtain results.
Stores data in a plain text file. each line of the text
file holds one record. Fields are separated by
Flat File Database delimiters like spaces or commas. Because a flat
database uses a simple structure, it cannot contain
multiple tables.
One of the oldest database models. Data is
organized in a tree structure, much like an
Hierarchical Database
organizational chart.
Contain database tables that can be joined
together in a logical way.
each record has a unique identifier, such as a
product identification number or user name. This
Relational Database unique identifier, referred to as a primary key,
creates the relationship among tables. A field may
be marked as the primary key on one table but
also be found on another table. When this
happens, a relationship called a foreign key is
created.
Primary Key Unique identifier, creates the relationship among tables.
1. Data retrieval speed
Factors of file organization system 2. Scalability
3. Security
What is the collection of names, addresses, database
and account balances of all the patients of
Mei's office more technically known as? A database is a collection of records. The name, address, and account balance of a
patient form the patient's record.
File
Key field
Database
Record
What are the name, address, and account record
balance of each individual patient in Mei's
office known as? The name, address, and account balance of each individual patient of the office
Key field forms a record of the patient. A collection of records forms a database.
Record
Database
File
2/5
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 mbitheeunice2015. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81503 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now